PREVIEW / etf_30min / 2021-04-06

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-04-06.parquet
  size:    630 KB
  rows:    23,904

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-06 04:00:00	SPY	ETF	405.5	405.62	405.0	405.16	19127.0
2021-04-06 04:30:00	SPY	ETF	405.22	406.01	405.22	405.78	4850.0
2021-04-06 05:00:00	SPY	ETF	405.54	405.62	405.46	405.57	2236.0
2021-04-06 05:30:00	SPY	ETF	405.52	405.7	405.41	405.53	8099.0
2021-04-06 06:00:00	SPY	ETF	405.63	405.73	405.26	405.26	5050.0
2021-04-06 06:30:00	SPY	ETF	405.43	405.5	405.36	405.47	33745.0
2021-04-06 07:00:00	SPY	ETF	405.52	405.72	405.47	405.67	106336.0
2021-04-06 07:30:00	SPY	ETF	405.66	405.91	405.63	405.91	53599.0
2021-04-06 08:00:00	SPY	ETF	405.62	406.09	405.2	405.94	76408.0
2021-04-06 08:30:00	SPY	ETF	405.92	406.24	405.41	405.68	313274.0
2021-04-06 09:00:00	SPY	ETF	405.72	405.83	405.6	405.77	157238.0
2021-04-06 09:30:00	SPY	ETF	405.76	406.89	405.51	406.77	5381860.0
2021-04-06 10:00:00	SPY	ETF	406.77	407.1999	406.64	406.84	3064847.0
2021-04-06 10:30:00	SPY	ETF	406.85	406.99	406.55	406.82	2806559.0
2021-04-06 11:00:00	SPY	ETF	406.81	407.13	406.51	406.895	1988828.0
2021-04-06 11:30:00	SPY	ETF	406.9	407.24	406.7	407.17	1607601.0
2021-04-06 12:00:00	SPY	ETF	407.18	407.21	406.88	406.8898	2404797.0
2021-04-06 12:30:00	SPY	ETF	406.88	406.92	406.65	406.82	2126723.0
2021-04-06 13:00:00	SPY	ETF	406.81	406.85	405.87	406.059	2697030.0
2021-04-06 13:30:00	SPY	ETF	406.0404	406.68	405.92	406.63	2105653.0
2021-04-06 14:00:00	SPY	ETF	406.635	406.81	406.55	406.68	1917849.0
2021-04-06 14:30:00	SPY	ETF	406.68	406.83	406.29	406.58	3073996.0
2021-04-06 15:00:00	SPY	ETF	406.58	406.69	405.9442	406.29	4061248.0
2021-04-06 15:30:00	SPY	ETF	406.2814	406.37	405.4	406.06	9519957.0
2021-04-06 16:00:00	SPY	ETF	406.06	406.15	405.89	405.96	4131578.0
2021-04-06 16:30:00	SPY	ETF	405.96	406.23	405.9	406.22	148390.0
2021-04-06 17:00:00	SPY	ETF	406.23	406.23	406.15	406.16	51827.0
2021-04-06 17:30:00	SPY	ETF	406.2	406.35	406.2	406.26	43299.0
2021-04-06 18:00:00	SPY	ETF	406.28	406.3	406.12	406.13	25886.0
2021-04-06 18:30:00	SPY	ETF	406.12	406.58	406.12	406.49	27507.0
2021-04-06 19:00:00	SPY	ETF	406.44	406.5	406.39	406.48	8875.0
2021-04-06 19:30:00	SPY	ETF	406.5	406.77	406.43	406.73	186132.0
2021-04-06 04:00:00	QQQ	ETF	330.07	330.23	329.69	330.05	34091.0
2021-04-06 04:30:00	QQQ	ETF	330.09	330.69	330.08	330.4	31643.0
2021-04-06 05:00:00	QQQ	ETF	330.33	330.41	330.09	330.41	28503.0
2021-04-06 05:30:00	QQQ	ETF	330.32	330.46	330.09	330.26	30465.0
2021-04-06 06:00:00	QQQ	ETF	330.34	330.54	330.12	330.14	19776.0
2021-04-06 06:30:00	QQQ	ETF	330.16	330.32	329.93	330.22	14857.0
2021-04-06 07:00:00	QQQ	ETF	330.25	330.64	330.11	330.3	106459.0
2021-04-06 07:30:00	QQQ	ETF	330.31	330.98	330.31	330.92	94745.0
2021-04-06 08:00:00	QQQ	ETF	330.1996	331.36	329.78	331.24	161999.0
2021-04-06 08:30:00	QQQ	ETF	331.2	331.649	330.7892	331.2	124429.0
2021-04-06 09:00:00	QQQ	ETF	331.3	331.36	330.72	330.74	110218.0
2021-04-06 09:30:00	QQQ	ETF	330.73	331.44	330.02	331.41	3771432.0
2021-04-06 10:00:00	QQQ	ETF	331.44	331.81	330.85	331.23	2313921.0
2021-04-06 10:30:00	QQQ	ETF	331.27	331.9599	330.65	331.66	2112777.0
2021-04-06 11:00:00	QQQ	ETF	331.66	332.615	331.36	332.29	1931045.0
2021-04-06 11:30:00	QQQ	ETF	332.29	332.83	332.05	332.76	1175026.0
2021-04-06 12:00:00	QQQ	ETF	332.765	332.785	331.86	331.8656	1264132.0
2021-04-06 12:30:00	QQQ	ETF	331.86	332.255	331.7701	331.8808	1058027.0

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

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