PREVIEW / etf_30min / 2022-09-21

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-09-21.parquet
  size:    653 KB
  rows:    26,669

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-09-21 04:00:00	SPY	ETF	383.96	384.65	383.75	384.4	18366.0
2022-09-21 04:30:00	SPY	ETF	384.43	384.62	384.24	384.39	7419.0
2022-09-21 05:00:00	SPY	ETF	384.41	384.41	384.04	384.36	5650.0
2022-09-21 05:30:00	SPY	ETF	384.59	385.32	384.59	385.21	25928.0
2022-09-21 06:00:00	SPY	ETF	385.24	385.31	384.69	385.05	44294.0
2022-09-21 06:30:00	SPY	ETF	384.85	385.3	384.16	384.91	120039.0
2022-09-21 07:00:00	SPY	ETF	384.96	385.09	384.64	384.73	225231.0
2022-09-21 07:30:00	SPY	ETF	384.7	385.79	384.67	385.51	218157.0
2022-09-21 08:00:00	SPY	ETF	384.85	385.85	382.79	385.81	144137.0
2022-09-21 08:30:00	SPY	ETF	385.85	386.44	385.74	386.05	288434.0
2022-09-21 09:00:00	SPY	ETF	386.09	386.4	385.84	386.09	179613.0
2022-09-21 09:30:00	SPY	ETF	386.11	386.88	385.42	386.24	5210710.0
2022-09-21 10:00:00	SPY	ETF	386.23	387.2305	385.87	387.15	3241349.0
2022-09-21 10:30:00	SPY	ETF	387.17	387.26	385.57	385.99	2356995.0
2022-09-21 11:00:00	SPY	ETF	385.985	386.23	385.4	385.85	1981121.0
2022-09-21 11:30:00	SPY	ETF	385.8879	386.38	385.77	386.05	1465627.0
2022-09-21 12:00:00	SPY	ETF	386.03	386.52	385.81	386.495	1287983.0
2022-09-21 12:30:00	SPY	ETF	386.491	386.85	385.89	385.89	1359054.0
2022-09-21 13:00:00	SPY	ETF	385.91	386.15	385.59	385.99	1248294.0
2022-09-21 13:30:00	SPY	ETF	386.0	387.33	385.96	387.1	2147461.0
2022-09-21 14:00:00	SPY	ETF	387.1	387.23	380.25	381.8	14534051.0
2022-09-21 14:30:00	SPY	ETF	381.8	389.31	380.81	387.5	16414155.0
2022-09-21 15:00:00	SPY	ETF	387.51	388.06	381.51	381.55	10236907.0
2022-09-21 15:30:00	SPY	ETF	381.53	381.99	377.39	377.39	16638166.0
2022-09-21 16:00:00	SPY	ETF	377.4	378.6	376.21	376.32	4159067.0
2022-09-21 16:30:00	SPY	ETF	376.3	377.39	376.2	376.63	465151.0
2022-09-21 17:00:00	SPY	ETF	376.65	377.39	376.52	376.53	116044.0
2022-09-21 17:30:00	SPY	ETF	376.53	376.65	376.4	376.56	58308.0
2022-09-21 18:00:00	SPY	ETF	376.51	376.97	376.33	376.46	104482.0
2022-09-21 18:30:00	SPY	ETF	376.62	376.63	375.29	375.45	127939.0
2022-09-21 19:00:00	SPY	ETF	375.43	375.65	375.04	375.31	85120.0
2022-09-21 19:30:00	SPY	ETF	375.25	375.52	375.0	375.1	161755.0
2022-09-21 04:00:00	QQQ	ETF	288.7	288.98	288.17	288.92	27727.0
2022-09-21 04:30:00	QQQ	ETF	288.65	288.91	288.53	288.74	6024.0
2022-09-21 05:00:00	QQQ	ETF	288.69	288.75	288.21	288.48	15528.0
2022-09-21 05:30:00	QQQ	ETF	288.5	289.17	288.5	288.98	18825.0
2022-09-21 06:00:00	QQQ	ETF	289.04	289.04	288.57	288.87	7746.0
2022-09-21 06:30:00	QQQ	ETF	288.72	288.98	288.25	288.79	50638.0
2022-09-21 07:00:00	QQQ	ETF	288.76	288.9	288.47	288.54	103152.0
2022-09-21 07:30:00	QQQ	ETF	288.56	289.28	288.45	289.09	93862.0
2022-09-21 08:00:00	QQQ	ETF	288.71	289.5	287.74	289.45	152412.0
2022-09-21 08:30:00	QQQ	ETF	289.47	290.22	289.46	289.89	263508.0
2022-09-21 09:00:00	QQQ	ETF	289.97	290.1	289.55	289.73	190308.0
2022-09-21 09:30:00	QQQ	ETF	289.61	290.48	289.025	289.84	4522447.0
2022-09-21 10:00:00	QQQ	ETF	289.83	290.54	289.39	290.48	3023272.0
2022-09-21 10:30:00	QQQ	ETF	290.4915	290.56	289.13	289.5	2060747.0
2022-09-21 11:00:00	QQQ	ETF	289.52	289.76	289.08	289.67	1305447.0
2022-09-21 11:30:00	QQQ	ETF	289.69	290.05	289.54	289.81	879393.0
2022-09-21 12:00:00	QQQ	ETF	289.79	290.39	289.56	290.37	935494.0
2022-09-21 12:30:00	QQQ	ETF	290.37	290.81	290.1198	290.1198	1408791.0

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

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