PREVIEW / etf_30min / 2022-07-12

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-07-12.parquet
  size:    645 KB
  rows:    25,335

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-07-12 04:00:00	SPY	ETF	381.82	382.49	381.39	381.72	17151.0
2022-07-12 04:30:00	SPY	ETF	381.93	382.29	381.93	382.0	11595.0
2022-07-12 05:00:00	SPY	ETF	382.14	382.19	381.74	381.75	19081.0
2022-07-12 05:30:00	SPY	ETF	381.61	381.67	381.1	381.33	28254.0
2022-07-12 06:00:00	SPY	ETF	381.38	382.35	381.38	382.13	30627.0
2022-07-12 06:30:00	SPY	ETF	382.06	382.06	381.18	381.18	19102.0
2022-07-12 07:00:00	SPY	ETF	381.23	382.36	381.13	382.23	150840.0
2022-07-12 07:30:00	SPY	ETF	382.28	383.0	382.22	382.36	153350.0
2022-07-12 08:00:00	SPY	ETF	381.278	382.99	381.15	382.5	284479.0
2022-07-12 08:30:00	SPY	ETF	382.47	383.24	382.37	382.9	263270.0
2022-07-12 09:00:00	SPY	ETF	382.94	383.87	382.8	383.63	417003.0
2022-07-12 09:30:00	SPY	ETF	383.65	386.16	383.59	383.75	5654554.0
2022-07-12 10:00:00	SPY	ETF	383.72	383.9101	382.525	382.9684	3838850.0
2022-07-12 10:30:00	SPY	ETF	382.97	384.27	382.91	384.0416	2356060.0
2022-07-12 11:00:00	SPY	ETF	384.04	385.15	383.5	385.04	2602957.0
2022-07-12 11:30:00	SPY	ETF	385.07	385.35	383.86	384.33	2253961.0
2022-07-12 12:00:00	SPY	ETF	384.32	384.72	383.92	384.65	1804923.0
2022-07-12 12:30:00	SPY	ETF	384.66	385.22	384.37	384.8201	1517573.0
2022-07-12 13:00:00	SPY	ETF	384.82	385.38	383.66	384.0724	2029593.0
2022-07-12 13:30:00	SPY	ETF	384.08	384.61	383.92	384.43	1201223.0
2022-07-12 14:00:00	SPY	ETF	384.4	384.51	383.67	383.84	1579246.0
2022-07-12 14:30:00	SPY	ETF	383.84	383.95	382.48	382.5	2168951.0
2022-07-12 15:00:00	SPY	ETF	382.51	382.51	380.12	380.25	5553292.0
2022-07-12 15:30:00	SPY	ETF	380.26	381.07	378.99	380.8802	10919021.0
2022-07-12 16:00:00	SPY	ETF	380.89	380.9	380.3	380.58	2611984.0
2022-07-12 16:30:00	SPY	ETF	380.55	380.81	380.38	380.81	131065.0
2022-07-12 17:00:00	SPY	ETF	380.81	380.83	380.67	380.75	18281.0
2022-07-12 17:30:00	SPY	ETF	380.75	380.8496	380.72	380.8496	29756.0
2022-07-12 18:00:00	SPY	ETF	380.85	381.08	380.6	380.81	50052.0
2022-07-12 18:30:00	SPY	ETF	380.81	380.96	380.7	380.71	15985.0
2022-07-12 19:00:00	SPY	ETF	380.75	380.99	380.41	380.62	39254.0
2022-07-12 19:30:00	SPY	ETF	380.61	381.21	379.98	380.64	54950.0
2022-07-12 04:00:00	QQQ	ETF	287.26	287.26	286.55	286.95	68505.0
2022-07-12 04:30:00	QQQ	ETF	287.05	287.37	287.05	287.23	30283.0
2022-07-12 05:00:00	QQQ	ETF	287.28	287.5	287.07	287.07	18899.0
2022-07-12 05:30:00	QQQ	ETF	287.0	287.12	286.7	286.99	23922.0
2022-07-12 06:00:00	QQQ	ETF	287.03	288.05	287.03	287.74	54056.0
2022-07-12 06:30:00	QQQ	ETF	287.68	287.89	287.25	287.28	54268.0
2022-07-12 07:00:00	QQQ	ETF	287.25	288.9	287.2	288.56	210716.0
2022-07-12 07:30:00	QQQ	ETF	288.56	289.38	288.5	288.8	298309.0
2022-07-12 08:00:00	QQQ	ETF	287.31	289.37	286.64	288.95	265034.0
2022-07-12 08:30:00	QQQ	ETF	289.02	289.84	288.77	289.4	299747.0
2022-07-12 09:00:00	QQQ	ETF	289.4	290.5	289.22	290.2	635530.0
2022-07-12 09:30:00	QQQ	ETF	290.32	292.28	288.03	288.16	7692823.0
2022-07-12 10:00:00	QQQ	ETF	288.14	288.41	286.9	287.74	5131561.0
2022-07-12 10:30:00	QQQ	ETF	287.76	289.35	287.534	288.53	3311614.0
2022-07-12 11:00:00	QQQ	ETF	288.54	289.96	288.05	289.68	2418843.0
2022-07-12 11:30:00	QQQ	ETF	289.69	289.95	288.39	289.0899	1793253.0
2022-07-12 12:00:00	QQQ	ETF	289.06	289.62	288.6	289.31	1647852.0
2022-07-12 12:30:00	QQQ	ETF	289.33	289.99	289.065	289.53	1458176.0

> showing 50 of 25,335 rows — these rows as CSV

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