PREVIEW / etf_30min / 2022-05-05

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-05-05.parquet
  size:    692 KB
  rows:    27,792

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-05 04:00:00	SPY	ETF	427.16	427.24	426.38	426.38	31982.0
2022-05-05 04:30:00	SPY	ETF	426.31	426.4	425.48	425.9	58237.0
2022-05-05 05:00:00	SPY	ETF	425.88	426.37	425.81	426.15	34896.0
2022-05-05 05:30:00	SPY	ETF	426.0	426.5	425.67	426.38	25784.0
2022-05-05 06:00:00	SPY	ETF	426.3	426.86	426.19	426.79	52609.0
2022-05-05 06:30:00	SPY	ETF	426.73	426.78	425.79	425.79	66180.0
2022-05-05 07:00:00	SPY	ETF	425.83	426.98	425.83	425.93	115659.0
2022-05-05 07:30:00	SPY	ETF	425.88	426.72	425.79	426.2	228635.0
2022-05-05 08:00:00	SPY	ETF	426.06	429.09	425.5196	426.29	357080.0
2022-05-05 08:30:00	SPY	ETF	426.32	426.46	425.8	425.8	273349.0
2022-05-05 09:00:00	SPY	ETF	425.83	425.83	424.45	424.5	763001.0
2022-05-05 09:30:00	SPY	ETF	424.52	425.0	421.11	421.565	12986270.0
2022-05-05 10:00:00	SPY	ETF	421.59	421.63	417.75	418.1	12358511.0
2022-05-05 10:30:00	SPY	ETF	418.095	418.47	415.22	416.77	10774719.0
2022-05-05 11:00:00	SPY	ETF	416.76	417.135	413.62	414.74	10170820.0
2022-05-05 11:30:00	SPY	ETF	414.71	416.51	412.28	412.335	8727409.0
2022-05-05 12:00:00	SPY	ETF	412.33	414.9201	411.01	414.061	10289547.0
2022-05-05 12:30:00	SPY	ETF	414.01	414.81	412.06	414.51	6357959.0
2022-05-05 13:00:00	SPY	ETF	414.5263	416.39	413.86	414.9	5783714.0
2022-05-05 13:30:00	SPY	ETF	414.88	415.95	412.83	413.45	4650784.0
2022-05-05 14:00:00	SPY	ETF	413.46	415.18	411.92	411.9899	5323472.0
2022-05-05 14:30:00	SPY	ETF	411.96	414.14	411.58	412.77	6571026.0
2022-05-05 15:00:00	SPY	ETF	412.77	413.08	409.73	410.03	9779979.0
2022-05-05 15:30:00	SPY	ETF	410.04	414.3199	409.44	413.92	27658516.0
2022-05-05 16:00:00	SPY	ETF	413.89	414.77	413.51	414.2	5942901.0
2022-05-05 16:30:00	SPY	ETF	414.2	415.17	413.81	414.47	996728.0
2022-05-05 17:00:00	SPY	ETF	414.69	414.69	413.81	414.1	124251.0
2022-05-05 17:30:00	SPY	ETF	414.1	414.35	413.8	413.8	34980.0
2022-05-05 18:00:00	SPY	ETF	414.3	414.3	413.14	413.4	302256.0
2022-05-05 18:30:00	SPY	ETF	413.47	414.1	413.45	413.93	41294.0
2022-05-05 19:00:00	SPY	ETF	413.8	413.98	413.61	413.9	47823.0
2022-05-05 19:30:00	SPY	ETF	413.98	414.32	413.82	414.23	148217.0
2022-05-05 04:00:00	QQQ	ETF	327.5	327.78	327.15	327.21	120562.0
2022-05-05 04:30:00	QQQ	ETF	327.21	327.21	326.02	326.55	101217.0
2022-05-05 05:00:00	QQQ	ETF	326.68	327.5	326.65	327.03	45876.0
2022-05-05 05:30:00	QQQ	ETF	327.0	327.2	326.58	327.12	31764.0
2022-05-05 06:00:00	QQQ	ETF	327.04	327.7	327.04	327.7	42922.0
2022-05-05 06:30:00	QQQ	ETF	327.56	327.62	326.84	326.84	60532.0
2022-05-05 07:00:00	QQQ	ETF	326.85	327.77	326.81	326.87	172906.0
2022-05-05 07:30:00	QQQ	ETF	326.82	327.47	326.71	327.08	219209.0
2022-05-05 08:00:00	QQQ	ETF	326.981	329.5	326.76	327.29	277863.0
2022-05-05 08:30:00	QQQ	ETF	327.33	327.46	326.44	326.55	282414.0
2022-05-05 09:00:00	QQQ	ETF	326.55	326.55	324.95	325.1	701959.0
2022-05-05 09:30:00	QQQ	ETF	325.17	325.25	320.61	321.02	12887952.0
2022-05-05 10:00:00	QQQ	ETF	321.06	321.1	316.96	317.16	11929883.0
2022-05-05 10:30:00	QQQ	ETF	317.13	317.49	315.04	316.4	10954755.0
2022-05-05 11:00:00	QQQ	ETF	316.4	316.54	313.75	314.78	7942399.0
2022-05-05 11:30:00	QQQ	ETF	314.76	316.44	312.91	312.98	7199277.0
2022-05-05 12:00:00	QQQ	ETF	312.96	315.29	311.89	314.46	7088028.0
2022-05-05 12:30:00	QQQ	ETF	314.42	315.08	312.57	314.5181	4830413.0

> showing 50 of 27,792 rows — these rows as CSV

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