PREVIEW / etf_30min / 2022-05-27

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-05-27.parquet
  size:    667 KB
  rows:    26,186

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
2022-05-27 04:00:00	SPY	ETF	405.01	406.32	405.01	406.32	22315.0
2022-05-27 04:30:00	SPY	ETF	406.3	406.79	406.11	406.54	18579.0
2022-05-27 05:00:00	SPY	ETF	406.3	406.32	405.9	406.32	12184.0
2022-05-27 05:30:00	SPY	ETF	406.44	407.37	406.38	407.17	16599.0
2022-05-27 06:00:00	SPY	ETF	406.89	406.89	406.35	406.37	9948.0
2022-05-27 06:30:00	SPY	ETF	406.52	406.88	406.2	406.85	18651.0
2022-05-27 07:00:00	SPY	ETF	406.8	406.8	405.96	406.22	75992.0
2022-05-27 07:30:00	SPY	ETF	406.24	406.32	405.4	405.48	60022.0
2022-05-27 08:00:00	SPY	ETF	406.7001	407.0704	404.72	405.96	154462.0
2022-05-27 08:30:00	SPY	ETF	405.96	408.45	405.6	408.25	655013.0
2022-05-27 09:00:00	SPY	ETF	408.24	408.49	407.5999	407.9	425390.0
2022-05-27 09:30:00	SPY	ETF	407.93	411.55	407.7	411.03	8481658.0
2022-05-27 10:00:00	SPY	ETF	411.02	412.29	410.66	411.7	6502248.0
2022-05-27 10:30:00	SPY	ETF	411.71	412.08	410.85	410.95	4093329.0
2022-05-27 11:00:00	SPY	ETF	410.96	412.13	410.51	411.81	3167095.0
2022-05-27 11:30:00	SPY	ETF	411.8	412.64	411.62	412.5	2651952.0
2022-05-27 12:00:00	SPY	ETF	412.52	412.87	411.95	412.35	2668376.0
2022-05-27 12:30:00	SPY	ETF	412.35	412.59	411.8	412.41	1815738.0
2022-05-27 13:00:00	SPY	ETF	412.42	412.82	412.19	412.39	2095240.0
2022-05-27 13:30:00	SPY	ETF	412.4	412.6199	411.885	412.275	2036616.0
2022-05-27 14:00:00	SPY	ETF	412.28	412.71	411.94	412.51	2266067.0
2022-05-27 14:30:00	SPY	ETF	412.505	413.21	412.37	413.14	3029357.0
2022-05-27 15:00:00	SPY	ETF	413.15	414.49	413.0	414.36	5872538.0
2022-05-27 15:30:00	SPY	ETF	414.37	415.3801	413.61	415.35	12927696.0
2022-05-27 16:00:00	SPY	ETF	415.35	416.2	414.97	416.2	6238065.0
2022-05-27 16:30:00	SPY	ETF	416.15	416.49	416.15	416.46	478933.0
2022-05-27 17:00:00	SPY	ETF	416.46	416.46	415.26	416.24	146632.0
2022-05-27 17:30:00	SPY	ETF	416.22	416.28	416.16	416.27	54693.0
2022-05-27 18:00:00	SPY	ETF	416.27	416.31	416.2	416.28	34621.0
2022-05-27 18:30:00	SPY	ETF	416.28	416.45	416.27	416.44	19700.0
2022-05-27 19:00:00	SPY	ETF	416.43	416.61	416.36	416.45	13571.0
2022-05-27 19:30:00	SPY	ETF	416.52	416.8	416.52	416.7	26428.0
2022-05-27 04:00:00	QQQ	ETF	299.26	300.5	298.62	300.47	40034.0
2022-05-27 04:30:00	QQQ	ETF	300.63	301.05	300.3	300.81	48882.0
2022-05-27 05:00:00	QQQ	ETF	300.59	300.59	300.14	300.47	34592.0
2022-05-27 05:30:00	QQQ	ETF	300.52	301.65	300.45	301.38	27066.0
2022-05-27 06:00:00	QQQ	ETF	301.34	301.34	300.5	300.9	30618.0
2022-05-27 06:30:00	QQQ	ETF	300.79	301.12	300.46	301.12	73962.0
2022-05-27 07:00:00	QQQ	ETF	301.15	301.24	300.16	300.54	92145.0
2022-05-27 07:30:00	QQQ	ETF	300.53	300.64	299.7	299.8	98739.0
2022-05-27 08:00:00	QQQ	ETF	300.8999	301.07	299.05	300.38	213617.0
2022-05-27 08:30:00	QQQ	ETF	300.25	303.2	299.94	302.8	1093400.0
2022-05-27 09:00:00	QQQ	ETF	302.78	303.16	301.9	302.53	501172.0
2022-05-27 09:30:00	QQQ	ETF	302.53	305.55	302.42	305.275	8343973.0
2022-05-27 10:00:00	QQQ	ETF	305.26	306.7633	304.85	306.3495	5415929.0
2022-05-27 10:30:00	QQQ	ETF	306.37	307.0418	305.39	305.55	4114907.0
2022-05-27 11:00:00	QQQ	ETF	305.58	306.66	304.93	306.28	3301820.0
2022-05-27 11:30:00	QQQ	ETF	306.31	307.17	306.2602	307.03	2394637.0
2022-05-27 12:00:00	QQQ	ETF	307.05	307.49	306.5	306.71	2046242.0
2022-05-27 12:30:00	QQQ	ETF	306.705	307.03	306.22	306.865	1761521.0

> showing 50 of 26,186 rows — these rows as CSV

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