PREVIEW / etf_30min / 2019-12-12

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-12-12.parquet
  size:    544 KB
  rows:    18,965

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2019-12-12 04:00:00	SPY	ETF	314.99	315.19	314.99	315.18	7810.0
2019-12-12 04:30:00	SPY	ETF	315.17	315.28	315.17	315.19	10117.0
2019-12-12 05:00:00	SPY	ETF	315.22	315.27	314.93	314.93	7171.0
2019-12-12 05:30:00	SPY	ETF	314.83	314.84	314.8	314.82	1700.0
2019-12-12 06:00:00	SPY	ETF	314.85	314.91	314.81	314.81	3745.0
2019-12-12 06:30:00	SPY	ETF	314.78	314.95	314.78	314.94	26925.0
2019-12-12 07:00:00	SPY	ETF	314.95	314.95	314.54	314.73	77023.0
2019-12-12 07:30:00	SPY	ETF	314.68	314.76	314.54	314.6	79099.0
2019-12-12 08:00:00	SPY	ETF	314.8399	315.15	314.12	314.39	285790.0
2019-12-12 08:30:00	SPY	ETF	314.39	314.53	314.02	314.45	171488.0
2019-12-12 09:00:00	SPY	ETF	314.37	314.56	314.3102	314.42	97759.0
2019-12-12 09:30:00	SPY	ETF	314.43	316.8698	314.17	316.845	11015098.0
2019-12-12 10:00:00	SPY	ETF	316.85	317.99	316.8457	317.7401	12394558.0
2019-12-12 10:30:00	SPY	ETF	317.75	317.8	316.77	317.34	5759631.0
2019-12-12 11:00:00	SPY	ETF	317.35	317.41	316.405	316.405	3543570.0
2019-12-12 11:30:00	SPY	ETF	316.41	316.66	315.61	316.16	5352526.0
2019-12-12 12:00:00	SPY	ETF	316.17	316.17	315.33	315.57	3000228.0
2019-12-12 12:30:00	SPY	ETF	315.572	316.38	315.54	316.0	4042395.0
2019-12-12 13:00:00	SPY	ETF	316.0	316.53	315.97	316.315	2561157.0
2019-12-12 13:30:00	SPY	ETF	316.31	316.38	316.02	316.2	1646654.0
2019-12-12 14:00:00	SPY	ETF	316.21	316.36	315.76	316.0	4162194.0
2019-12-12 14:30:00	SPY	ETF	316.01	317.32	315.88	316.71	11033664.0
2019-12-12 15:00:00	SPY	ETF	316.71	317.195	316.62	317.16	5236786.0
2019-12-12 15:30:00	SPY	ETF	317.17	317.68	316.785	317.14	12841437.0
2019-12-12 16:00:00	SPY	ETF	317.14	317.1692	316.7	317.11	9051707.0
2019-12-12 16:30:00	SPY	ETF	317.11	317.36	317.07	317.23	319637.0
2019-12-12 17:00:00	SPY	ETF	317.24	317.8	317.17	317.67	934880.0
2019-12-12 17:30:00	SPY	ETF	317.68	317.76	317.45	317.6	100503.0
2019-12-12 18:00:00	SPY	ETF	317.68	318.36	317.68	318.15	367538.0
2019-12-12 18:30:00	SPY	ETF	318.19	318.5	318.12	318.37	42062.0
2019-12-12 19:00:00	SPY	ETF	318.35	318.45	317.91	318.22	54267.0
2019-12-12 19:30:00	SPY	ETF	318.2	318.45	318.04	318.41	69050.0
2019-12-12 04:00:00	QQQ	ETF	205.47	205.62	205.47	205.54	9431.0
2019-12-12 04:30:00	QQQ	ETF	205.66	205.66	205.55	205.55	4200.0
2019-12-12 05:00:00	QQQ	ETF	205.61	205.62	205.38	205.39	6500.0
2019-12-12 05:30:00	QQQ	ETF	205.4	205.4	205.25	205.33	2055.0
2019-12-12 06:00:00	QQQ	ETF	205.33	205.39	205.28	205.3	3512.0
2019-12-12 06:30:00	QQQ	ETF	205.31	205.4	205.27	205.38	4990.0
2019-12-12 07:00:00	QQQ	ETF	205.39	205.39	205.13	205.21	20627.0
2019-12-12 07:30:00	QQQ	ETF	205.16	205.32	205.02	205.05	86493.0
2019-12-12 08:00:00	QQQ	ETF	205.3199	205.6341	204.62	204.91	571209.0
2019-12-12 08:30:00	QQQ	ETF	204.75	204.94	204.56	204.89	147124.0
2019-12-12 09:00:00	QQQ	ETF	204.89	204.93	204.66	204.74	162096.0
2019-12-12 09:30:00	QQQ	ETF	204.77	206.53	204.491	206.51	4669681.0
2019-12-12 10:00:00	QQQ	ETF	206.53	207.32	206.53	207.22	2969579.0
2019-12-12 10:30:00	QQQ	ETF	207.23	207.25	206.52	206.905	2268289.0
2019-12-12 11:00:00	QQQ	ETF	206.91	206.94	205.84	205.8452	1663525.0
2019-12-12 11:30:00	QQQ	ETF	205.85	206.09	205.34	205.7101	2408868.0
2019-12-12 12:00:00	QQQ	ETF	205.72	205.74	205.0	205.24	1733462.0
2019-12-12 12:30:00	QQQ	ETF	205.2355	205.85	205.21	205.61	1565609.0

> showing 50 of 18,965 rows — these rows as CSV

> unlock the full archive -- $79 one-time