PREVIEW / etf_30min / 2006-08-23

all etf 30-min files

  file:    by_date/etf_30min/2006/2006-08-23.parquet
  size:    78 KB
  rows:    2,748

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
2006-08-23 07:30:00	SPY	ETF	130.05	130.05	130.05	130.05	1000.0
2006-08-23 08:00:00	SPY	ETF	130.02	130.15	129.98	130.15	455600.0
2006-08-23 08:30:00	SPY	ETF	130.14	130.22	130.1	130.19	195600.0
2006-08-23 09:00:00	SPY	ETF	130.2	130.24	130.13	130.17	316600.0
2006-08-23 09:30:00	SPY	ETF	130.18	130.44	130.12	130.31	6205200.0
2006-08-23 10:00:00	SPY	ETF	130.31	130.32	129.88	129.96	11653600.0
2006-08-23 10:30:00	SPY	ETF	129.95	130.05	129.7	129.79	5960100.0
2006-08-23 11:00:00	SPY	ETF	129.8	129.82	129.43	129.58	9362100.0
2006-08-23 11:30:00	SPY	ETF	129.58	129.7	129.5	129.65	6214900.0
2006-08-23 12:00:00	SPY	ETF	129.65	129.76	129.54	129.62	2594600.0
2006-08-23 12:30:00	SPY	ETF	129.6	129.73	129.56	129.67	1539300.0
2006-08-23 13:00:00	SPY	ETF	129.67	129.7	129.52	129.58	1787700.0
2006-08-23 13:30:00	SPY	ETF	129.59	129.6	129.22	129.34	4238000.0
2006-08-23 14:00:00	SPY	ETF	129.34	129.42	129.29	129.311	2254700.0
2006-08-23 14:30:00	SPY	ETF	129.31	129.44	129.21	129.23	2418800.0
2006-08-23 15:00:00	SPY	ETF	129.22	129.42	129.19	129.37	3681600.0
2006-08-23 15:30:00	SPY	ETF	129.37	129.58	129.3	129.58	4998300.0
2006-08-23 16:00:00	SPY	ETF	129.57	129.79	129.57	129.7	1419800.0
2006-08-23 16:30:00	SPY	ETF	129.72	129.78	129.72	129.72	177400.0
2006-08-23 17:00:00	SPY	ETF	129.71	129.71	129.66	129.69	4800.0
2006-08-23 17:30:00	SPY	ETF	129.7	129.7	129.66	129.66	3400.0
2006-08-23 18:00:00	SPY	ETF	129.69	129.69	129.66	129.66	8000.0
2006-08-23 18:30:00	SPY	ETF	129.67	129.67	129.66	129.66	25000.0
2006-08-23 19:00:00	SPY	ETF	129.65	129.65	129.65	129.65	100.0
2006-08-23 19:30:00	SPY	ETF	129.71	129.71	129.7	129.7	600.0
2006-08-23 09:30:00	QQQ	ETF	38.47	38.67	38.29	38.59	10288600.0
2006-08-23 10:00:00	QQQ	ETF	38.59	38.61	38.4	38.43	10385100.0
2006-08-23 10:30:00	QQQ	ETF	38.44	38.95	38.05	38.32	12661600.0
2006-08-23 11:00:00	QQQ	ETF	38.32	38.32	37.9	38.15	11356700.0
2006-08-23 11:30:00	QQQ	ETF	38.15	38.22	38.13	38.19	4222000.0
2006-08-23 12:00:00	QQQ	ETF	38.18	38.24	38.15	38.17	3575900.0
2006-08-23 12:30:00	QQQ	ETF	38.18	38.24	38.14	38.22	2721200.0
2006-08-23 13:00:00	QQQ	ETF	38.22	38.22	38.15	38.2	1908300.0
2006-08-23 13:30:00	QQQ	ETF	38.2	38.2	38.01	38.07	5918300.0
2006-08-23 14:00:00	QQQ	ETF	38.08	38.11	38.01	38.02	3631500.0
2006-08-23 14:30:00	QQQ	ETF	38.02	38.08	37.92	37.97	8327200.0
2006-08-23 15:00:00	QQQ	ETF	37.97	38.09	37.97	38.06	5504100.0
2006-08-23 15:30:00	QQQ	ETF	38.07	38.17	37.12	38.17	8922200.0
2006-08-23 08:00:00	IWM	ETF	70.39	70.44	70.36	70.44	52000.0
2006-08-23 08:30:00	IWM	ETF	70.54	70.54	70.48	70.48	1600.0
2006-08-23 09:00:00	IWM	ETF	70.47	70.54	70.47	70.5	16200.0
2006-08-23 09:30:00	IWM	ETF	70.5	70.8	70.5	70.6	1928500.0
2006-08-23 10:00:00	IWM	ETF	70.6	70.6	70.02	70.09	4424400.0
2006-08-23 10:30:00	IWM	ETF	70.08	70.17	69.7	69.78	5368600.0
2006-08-23 11:00:00	IWM	ETF	69.79	69.8	69.52	69.71	3853600.0
2006-08-23 11:30:00	IWM	ETF	69.71	69.74	69.61	69.66	1584200.0
2006-08-23 12:00:00	IWM	ETF	69.65	69.76	69.55	69.6	1574700.0
2006-08-23 12:30:00	IWM	ETF	69.6	69.77	69.59	69.71	722800.0
2006-08-23 13:00:00	IWM	ETF	69.71	69.71	69.59	69.65	619400.0
2006-08-23 13:30:00	IWM	ETF	69.65	69.65	69.25	69.33	3395600.0

> showing 50 of 2,748 rows — these rows as CSV

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