PREVIEW / etf_30min / 2019-12-19

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-12-19.parquet
  size:    523 KB
  rows:    18,344

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-19 04:00:00	SPY	ETF	319.92	319.95	319.85	319.88	2149.0
2019-12-19 04:30:00	SPY	ETF	319.86	320.08	319.86	320.08	5051.0
2019-12-19 05:00:00	SPY	ETF	320.08	320.08	319.95	319.95	1906.0
2019-12-19 05:30:00	SPY	ETF	320.09	320.11	320.04	320.04	4357.0
2019-12-19 06:00:00	SPY	ETF	320.02	320.05	319.88	319.89	2144.0
2019-12-19 06:30:00	SPY	ETF	319.91	319.97	319.86	319.95	2682.0
2019-12-19 07:00:00	SPY	ETF	319.91	320.0	319.88	319.93	20525.0
2019-12-19 07:30:00	SPY	ETF	319.95	319.95	319.59	319.71	48623.0
2019-12-19 08:00:00	SPY	ETF	319.9099	319.97	319.58	319.6898	153436.0
2019-12-19 08:30:00	SPY	ETF	319.65	319.65	319.43	319.6001	191399.0
2019-12-19 09:00:00	SPY	ETF	319.59	319.8	319.59	319.75	202186.0
2019-12-19 09:30:00	SPY	ETF	319.8	320.1	319.75	319.96	3970419.0
2019-12-19 10:00:00	SPY	ETF	319.95	320.11	319.82	320.11	4483692.0
2019-12-19 10:30:00	SPY	ETF	320.11	320.25	319.99	320.13	5259754.0
2019-12-19 11:00:00	SPY	ETF	320.13	320.63	320.12	320.52	7247404.0
2019-12-19 11:30:00	SPY	ETF	320.52	320.7	320.42	320.51	2431101.0
2019-12-19 12:00:00	SPY	ETF	320.5	320.78	320.48	320.65	3131334.0
2019-12-19 12:30:00	SPY	ETF	320.65	320.66	320.49	320.54	3686290.0
2019-12-19 13:00:00	SPY	ETF	320.54	320.7	320.4553	320.635	5318209.0
2019-12-19 13:30:00	SPY	ETF	320.64	320.82	320.57	320.79	2802576.0
2019-12-19 14:00:00	SPY	ETF	320.79	320.97	320.74	320.9167	2994916.0
2019-12-19 14:30:00	SPY	ETF	320.915	320.98	320.8	320.86	3522766.0
2019-12-19 15:00:00	SPY	ETF	320.85	320.93	320.59	320.61	8662355.0
2019-12-19 15:30:00	SPY	ETF	320.6151	320.96	320.42	320.91	10522395.0
2019-12-19 16:00:00	SPY	ETF	320.92	321.09	319.5246	321.01	14042554.0
2019-12-19 16:30:00	SPY	ETF	321.01	321.24	319.5246	321.17	1449132.0
2019-12-19 17:00:00	SPY	ETF	321.18	321.18	320.9	321.15	315776.0
2019-12-19 17:30:00	SPY	ETF	321.13	321.19	320.9	321.18	2484050.0
2019-12-19 18:00:00	SPY	ETF	321.19	321.2	321.08	321.16	73021.0
2019-12-19 18:30:00	SPY	ETF	321.17	321.19	321.16	321.19	4247.0
2019-12-19 19:00:00	SPY	ETF	321.19	321.22	321.11	321.11	22765.0
2019-12-19 19:30:00	SPY	ETF	321.11	321.14	321.06	321.14	38349.0
2019-12-19 04:00:00	QQQ	ETF	209.62	209.65	209.56	209.62	21667.0
2019-12-19 04:30:00	QQQ	ETF	209.6	209.78	209.6	209.78	9400.0
2019-12-19 05:00:00	QQQ	ETF	209.77	209.78	209.65	209.65	28800.0
2019-12-19 05:30:00	QQQ	ETF	209.69	209.77	209.69	209.77	1369.0
2019-12-19 06:00:00	QQQ	ETF	209.82	209.82	209.61	209.64	3000.0
2019-12-19 06:30:00	QQQ	ETF	209.67	209.7	209.64	209.7	2600.0
2019-12-19 07:00:00	QQQ	ETF	209.68	209.7	209.63	209.69	40862.0
2019-12-19 07:30:00	QQQ	ETF	209.7	209.72	209.41	209.49	43011.0
2019-12-19 08:00:00	QQQ	ETF	209.6499	209.68	209.2709	209.52	521976.0
2019-12-19 08:30:00	QQQ	ETF	209.49	209.59	209.43	209.59	145702.0
2019-12-19 09:00:00	QQQ	ETF	209.58	209.67	209.54	209.66	52337.0
2019-12-19 09:30:00	QQQ	ETF	209.64	210.055	209.62	209.92	1248865.0
2019-12-19 10:00:00	QQQ	ETF	209.9	210.1099	209.77	210.1	890171.0
2019-12-19 10:30:00	QQQ	ETF	210.1	210.14	209.95	210.02	670770.0
2019-12-19 11:00:00	QQQ	ETF	210.02	210.43	210.01	210.41	1017831.0
2019-12-19 11:30:00	QQQ	ETF	210.402	210.55	210.36	210.48	573010.0
2019-12-19 12:00:00	QQQ	ETF	210.46	210.59	210.45	210.47	549684.0
2019-12-19 12:30:00	QQQ	ETF	210.47	210.49	210.35	210.41	367600.0

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

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