PREVIEW / etf_30min / 2021-04-08

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-04-08.parquet
  size:    615 KB
  rows:    23,399

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-04-08 04:00:00	SPY	ETF	407.98	408.22	407.69	407.89	8854.0
2021-04-08 04:30:00	SPY	ETF	407.93	407.93	407.69	407.85	2319.0
2021-04-08 05:00:00	SPY	ETF	407.84	407.99	407.66	407.66	11300.0
2021-04-08 05:30:00	SPY	ETF	407.63	407.89	407.56	407.89	6981.0
2021-04-08 06:00:00	SPY	ETF	407.95	408.14	407.85	408.11	13479.0
2021-04-08 06:30:00	SPY	ETF	408.13	408.16	407.84	407.92	17066.0
2021-04-08 07:00:00	SPY	ETF	407.89	408.09	407.85	407.97	63371.0
2021-04-08 07:30:00	SPY	ETF	407.98	408.2	407.93	407.99	92772.0
2021-04-08 08:00:00	SPY	ETF	407.8684	408.8	407.86	407.98	108447.0
2021-04-08 08:30:00	SPY	ETF	407.95	408.14	407.62	407.8	230124.0
2021-04-08 09:00:00	SPY	ETF	407.8	408.04	407.64	407.92	153149.0
2021-04-08 09:30:00	SPY	ETF	407.93	408.05	407.16	407.72	5116310.0
2021-04-08 10:00:00	SPY	ETF	407.74	407.85	406.93	407.45	3527340.0
2021-04-08 10:30:00	SPY	ETF	407.445	407.94	407.36	407.58	2976886.0
2021-04-08 11:00:00	SPY	ETF	407.59	407.9	407.445	407.85	2352157.0
2021-04-08 11:30:00	SPY	ETF	407.85	408.08	407.65	407.88	2318466.0
2021-04-08 12:00:00	SPY	ETF	407.884	408.39	407.79	408.16	2405886.0
2021-04-08 12:30:00	SPY	ETF	408.16	408.33	407.97	408.01	1657629.0
2021-04-08 13:00:00	SPY	ETF	408.01	408.195	407.94	408.11	1275807.0
2021-04-08 13:30:00	SPY	ETF	408.11	408.28	407.835	408.07	1456315.0
2021-04-08 14:00:00	SPY	ETF	408.07	408.44	407.99	408.33	1717458.0
2021-04-08 14:30:00	SPY	ETF	408.34	408.51	408.26	408.4553	1687860.0
2021-04-08 15:00:00	SPY	ETF	408.45	408.58	408.27	408.33	2071613.0
2021-04-08 15:30:00	SPY	ETF	408.34	408.56	407.97	408.49	8634619.0
2021-04-08 16:00:00	SPY	ETF	408.49	409.1	408.1415	409.0	2639675.0
2021-04-08 16:30:00	SPY	ETF	408.99	409.39	408.99	409.34	263310.0
2021-04-08 17:00:00	SPY	ETF	409.3	409.37	409.27	409.37	36108.0
2021-04-08 17:30:00	SPY	ETF	409.36	409.45	409.36	409.42	22369.0
2021-04-08 18:00:00	SPY	ETF	409.37	409.37	409.07	409.2	80968.0
2021-04-08 18:30:00	SPY	ETF	408.52	409.3	408.52	409.3	16044.0
2021-04-08 19:00:00	SPY	ETF	409.29	409.41	409.15	409.4	24894.0
2021-04-08 19:30:00	SPY	ETF	409.34	409.52	409.29	409.52	21032.0
2021-04-08 04:00:00	QQQ	ETF	333.13	334.23	333.13	334.09	22820.0
2021-04-08 04:30:00	QQQ	ETF	334.07	334.07	333.75	334.0	7290.0
2021-04-08 05:00:00	QQQ	ETF	334.02	334.18	333.78	333.81	6283.0
2021-04-08 05:30:00	QQQ	ETF	333.77	334.31	333.58	334.31	31443.0
2021-04-08 06:00:00	QQQ	ETF	334.39	334.98	334.29	334.81	43932.0
2021-04-08 06:30:00	QQQ	ETF	334.81	334.84	334.59	334.63	23094.0
2021-04-08 07:00:00	QQQ	ETF	334.47	334.68	334.39	334.53	45890.0
2021-04-08 07:30:00	QQQ	ETF	334.58	334.67	334.23	334.438	70608.0
2021-04-08 08:00:00	QQQ	ETF	334.525	334.88	334.02	334.22	122775.0
2021-04-08 08:30:00	QQQ	ETF	334.28	334.64	334.02	334.27	164673.0
2021-04-08 09:00:00	QQQ	ETF	334.31	334.71	334.0	334.55	117507.0
2021-04-08 09:30:00	QQQ	ETF	334.56	335.23	334.05	335.145	4396484.0
2021-04-08 10:00:00	QQQ	ETF	335.15	335.27	333.7399	334.07	2950717.0
2021-04-08 10:30:00	QQQ	ETF	334.07	334.89	334.0	334.39	2284263.0
2021-04-08 11:00:00	QQQ	ETF	334.42	334.73	333.83	334.62	1878402.0
2021-04-08 11:30:00	QQQ	ETF	334.63	334.83	334.37	334.7	1275536.0
2021-04-08 12:00:00	QQQ	ETF	334.72	335.05	334.41	334.71	1117596.0
2021-04-08 12:30:00	QQQ	ETF	334.72	334.89	334.265	334.53	832294.0

> showing 50 of 23,399 rows — these rows as CSV

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