PREVIEW / etf_30min / 2021-05-19

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-05-19.parquet
  size:    626 KB
  rows:    24,069

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
2021-05-19 04:00:00	SPY	ETF	409.6	410.15	408.5	408.61	27534.0
2021-05-19 04:30:00	SPY	ETF	408.64	408.91	408.37	408.7	14504.0
2021-05-19 05:00:00	SPY	ETF	408.67	409.73	408.67	409.44	31778.0
2021-05-19 05:30:00	SPY	ETF	409.49	409.66	408.2	408.41	49011.0
2021-05-19 06:00:00	SPY	ETF	408.35	408.67	408.16	408.67	24817.0
2021-05-19 06:30:00	SPY	ETF	408.74	408.88	408.45	408.66	36271.0
2021-05-19 07:00:00	SPY	ETF	408.75	408.75	407.65	407.71	159672.0
2021-05-19 07:30:00	SPY	ETF	407.8	407.99	407.33	407.62	473438.0
2021-05-19 08:00:00	SPY	ETF	408.6101	410.85	407.39	407.88	574561.0
2021-05-19 08:30:00	SPY	ETF	407.85	407.9	406.34	406.65	666344.0
2021-05-19 09:00:00	SPY	ETF	406.63	407.17	406.47	406.91	554269.0
2021-05-19 09:30:00	SPY	ETF	406.92	407.64	405.84	406.95	11761822.0
2021-05-19 10:00:00	SPY	ETF	406.9	407.26	405.33	406.94	10396442.0
2021-05-19 10:30:00	SPY	ETF	406.94	407.41	405.38	407.06	6149372.0
2021-05-19 11:00:00	SPY	ETF	407.05	408.34	406.45	408.125	4812060.0
2021-05-19 11:30:00	SPY	ETF	408.09	408.43	407.23	408.33	4062337.0
2021-05-19 12:00:00	SPY	ETF	408.32	409.29	407.953	408.94	3295149.0
2021-05-19 12:30:00	SPY	ETF	408.97	409.42	408.74	409.16	2340896.0
2021-05-19 13:00:00	SPY	ETF	409.14	410.25	409.13	409.875	3067501.0
2021-05-19 13:30:00	SPY	ETF	409.85	409.9	408.925	409.4	1959397.0
2021-05-19 14:00:00	SPY	ETF	409.41	410.52	407.59	410.07	7632853.0
2021-05-19 14:30:00	SPY	ETF	410.05	410.56	407.94	408.18	5804322.0
2021-05-19 15:00:00	SPY	ETF	408.19	410.23	407.6	409.9596	6306723.0
2021-05-19 15:30:00	SPY	ETF	409.95	411.05	408.665	410.89	13430333.0
2021-05-19 16:00:00	SPY	ETF	410.89	411.1	410.26	410.47	3509509.0
2021-05-19 16:30:00	SPY	ETF	410.47	410.86	410.2	410.54	215999.0
2021-05-19 17:00:00	SPY	ETF	410.45	410.6	410.45	410.54	9441.0
2021-05-19 17:30:00	SPY	ETF	410.54	410.65	410.54	410.65	82629.0
2021-05-19 18:00:00	SPY	ETF	410.58	410.69	410.17	410.26	65818.0
2021-05-19 18:30:00	SPY	ETF	410.86	410.86	409.78	409.8	29562.0
2021-05-19 19:00:00	SPY	ETF	409.81	409.99	409.75	409.82	16431.0
2021-05-19 19:30:00	SPY	ETF	409.82	409.91	409.67	409.81	19784.0
2021-05-19 04:00:00	QQQ	ETF	319.96	319.96	318.01	318.22	63554.0
2021-05-19 04:30:00	QQQ	ETF	318.23	318.5	317.82	318.21	35678.0
2021-05-19 05:00:00	QQQ	ETF	318.17	319.12	318.12	318.82	35182.0
2021-05-19 05:30:00	QQQ	ETF	318.82	318.87	317.59	317.78	43249.0
2021-05-19 06:00:00	QQQ	ETF	317.82	318.25	317.68	318.21	24551.0
2021-05-19 06:30:00	QQQ	ETF	318.23	318.64	318.0	318.39	73061.0
2021-05-19 07:00:00	QQQ	ETF	318.4	318.56	317.48	317.68	197940.0
2021-05-19 07:30:00	QQQ	ETF	317.59	317.59	316.97	317.17	280893.0
2021-05-19 08:00:00	QQQ	ETF	317.17	320.96	317.05	317.44	219676.0
2021-05-19 08:30:00	QQQ	ETF	317.47	317.64	316.22	316.58	419803.0
2021-05-19 09:00:00	QQQ	ETF	316.54	316.88	315.96	316.66	516888.0
2021-05-19 09:30:00	QQQ	ETF	316.66	318.91	316.3	318.09	8618063.0
2021-05-19 10:00:00	QQQ	ETF	318.05	319.42	317.14	319.26	5576037.0
2021-05-19 10:30:00	QQQ	ETF	319.251	319.87	318.09	319.33	4265137.0
2021-05-19 11:00:00	QQQ	ETF	319.32	320.65	318.735	320.061	3427531.0
2021-05-19 11:30:00	QQQ	ETF	320.05	320.4	319.35	320.25	2274764.0
2021-05-19 12:00:00	QQQ	ETF	320.23	321.16	319.83	320.84	2448975.0
2021-05-19 12:30:00	QQQ	ETF	320.88	321.2	320.45	320.68	1589694.0

> showing 50 of 24,069 rows — these rows as CSV

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