PREVIEW / etf_30min / 2022-06-28

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-06-28.parquet
  size:    662 KB
  rows:    26,401

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-06-28 04:00:00	SPY	ETF	389.63	390.46	389.63	390.36	29252.0
2022-06-28 04:30:00	SPY	ETF	390.48	390.91	390.29	390.91	5058.0
2022-06-28 05:00:00	SPY	ETF	390.86	391.36	390.83	391.02	14537.0
2022-06-28 05:30:00	SPY	ETF	391.0	391.0	390.22	390.22	19153.0
2022-06-28 06:00:00	SPY	ETF	390.44	390.53	390.22	390.39	26447.0
2022-06-28 06:30:00	SPY	ETF	390.56	390.93	390.46	390.75	19245.0
2022-06-28 07:00:00	SPY	ETF	390.81	391.15	390.55	391.11	72678.0
2022-06-28 07:30:00	SPY	ETF	391.07	391.1	390.63	390.84	87840.0
2022-06-28 08:00:00	SPY	ETF	390.7099	391.5	388.52	389.48	301387.0
2022-06-28 08:30:00	SPY	ETF	389.53	390.19	389.24	390.17	162143.0
2022-06-28 09:00:00	SPY	ETF	390.18	390.46	390.06	390.23	178914.0
2022-06-28 09:30:00	SPY	ETF	390.22	393.16	390.14	391.9199	6787267.0
2022-06-28 10:00:00	SPY	ETF	391.9	392.32	389.4	389.59	5179682.0
2022-06-28 10:30:00	SPY	ETF	389.57	389.6405	387.71	388.77	4012991.0
2022-06-28 11:00:00	SPY	ETF	388.76	389.0	385.76	385.77	4145377.0
2022-06-28 11:30:00	SPY	ETF	385.77	386.2499	383.87	384.09	5704919.0
2022-06-28 12:00:00	SPY	ETF	384.1	384.92	383.31	384.8997	4238206.0
2022-06-28 12:30:00	SPY	ETF	384.875	385.34	383.95	384.53	2871056.0
2022-06-28 13:00:00	SPY	ETF	384.5	384.5675	382.53	383.5301	3258160.0
2022-06-28 13:30:00	SPY	ETF	383.52	383.68	382.635	383.085	1883869.0
2022-06-28 14:00:00	SPY	ETF	383.02	383.78	381.53	381.8601	2724176.0
2022-06-28 14:30:00	SPY	ETF	381.86	382.0	380.71	381.51	3954993.0
2022-06-28 15:00:00	SPY	ETF	381.495	381.94	380.74	381.4999	3505124.0
2022-06-28 15:30:00	SPY	ETF	381.5	381.8	380.53	380.74	11180228.0
2022-06-28 16:00:00	SPY	ETF	380.74	381.15	380.41	381.01	3954643.0
2022-06-28 16:30:00	SPY	ETF	381.0	381.11	380.65	381.06	251795.0
2022-06-28 17:00:00	SPY	ETF	381.0	381.24	380.9	380.91	78594.0
2022-06-28 17:30:00	SPY	ETF	380.95	381.05	380.9	381.04	39286.0
2022-06-28 18:00:00	SPY	ETF	381.06	381.3	380.87	381.21	62195.0
2022-06-28 18:30:00	SPY	ETF	381.24	381.38	381.13	381.38	26987.0
2022-06-28 19:00:00	SPY	ETF	381.22	381.29	380.8	381.18	38772.0
2022-06-28 19:30:00	SPY	ETF	381.22	381.36	381.0	381.2	42095.0
2022-06-28 04:00:00	QQQ	ETF	293.3	293.83	293.26	293.75	34801.0
2022-06-28 04:30:00	QQQ	ETF	293.85	294.16	293.56	294.16	14750.0
2022-06-28 05:00:00	QQQ	ETF	294.17	294.5	294.09	294.1	12615.0
2022-06-28 05:30:00	QQQ	ETF	294.24	294.24	293.5	293.52	32596.0
2022-06-28 06:00:00	QQQ	ETF	293.57	293.7	293.34	293.7	15293.0
2022-06-28 06:30:00	QQQ	ETF	293.67	294.04	293.59	293.88	29717.0
2022-06-28 07:00:00	QQQ	ETF	294.0	294.36	293.73	294.36	84910.0
2022-06-28 07:30:00	QQQ	ETF	294.34	294.38	293.68	293.87	99687.0
2022-06-28 08:00:00	QQQ	ETF	293.84	295.0	292.669	292.74	360481.0
2022-06-28 08:30:00	QQQ	ETF	292.88	293.2	292.53	293.16	220932.0
2022-06-28 09:00:00	QQQ	ETF	293.19	293.44	292.82	293.0	198376.0
2022-06-28 09:30:00	QQQ	ETF	293.0	295.65	292.59	293.98	6658240.0
2022-06-28 10:00:00	QQQ	ETF	293.98	294.44	291.54	291.76	4259783.0
2022-06-28 10:30:00	QQQ	ETF	291.76	291.82	289.8301	290.68	3730834.0
2022-06-28 11:00:00	QQQ	ETF	290.64	290.98	288.045	288.05	3511311.0
2022-06-28 11:30:00	QQQ	ETF	288.07	288.5	286.16	286.34	4500592.0
2022-06-28 12:00:00	QQQ	ETF	286.3495	286.88	285.55	286.85	4054912.0
2022-06-28 12:30:00	QQQ	ETF	286.85	287.5	285.98	286.99	2628417.0

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

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