PREVIEW / etf_30min / 2006-06-01

all etf 30-min files

  file:    by_date/etf_30min/2006/2006-06-01.parquet
  size:    68 KB
  rows:    2,362

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-06-01 04:00:00	SPY	ETF	126.98	126.98	126.98	126.98	100.0
2006-06-01 04:30:00	SPY	ETF	126.91	126.91	126.91	126.91	100.0
2006-06-01 06:00:00	SPY	ETF	127.1	127.1	127.1	127.1	2000.0
2006-06-01 06:30:00	SPY	ETF	127.02	127.02	126.96	127.0	81700.0
2006-06-01 07:00:00	SPY	ETF	127.03	127.16	127.0	127.16	198100.0
2006-06-01 07:30:00	SPY	ETF	127.12	127.18	127.12	127.16	391300.0
2006-06-01 08:00:00	SPY	ETF	127.15	127.51	126.8	127.21	1247000.0
2006-06-01 08:30:00	SPY	ETF	127.22	127.58	127.19	127.46	2432100.0
2006-06-01 09:00:00	SPY	ETF	127.44	127.44	127.32	127.4	505600.0
2006-06-01 09:30:00	SPY	ETF	127.38	127.87	127.27	127.66	8060100.0
2006-06-01 10:00:00	SPY	ETF	127.66	127.76	127.41	127.6	8166800.0
2006-06-01 10:30:00	SPY	ETF	127.61	128.05	127.61	127.87	6498200.0
2006-06-01 11:00:00	SPY	ETF	127.86	128.19	127.82	128.14	4771000.0
2006-06-01 11:30:00	SPY	ETF	128.13	128.26	127.94	127.96	3373900.0
2006-06-01 12:00:00	SPY	ETF	127.96	128.15	127.95	128.13	1419500.0
2006-06-01 12:30:00	SPY	ETF	128.14	128.28	128.02	128.02	2804100.0
2006-06-01 13:00:00	SPY	ETF	128.03	128.21	127.99	128.18	1062200.0
2006-06-01 13:30:00	SPY	ETF	128.2	128.3	128.13	128.22	2410900.0
2006-06-01 14:00:00	SPY	ETF	128.21	128.38	128.02	128.31	4067900.0
2006-06-01 14:30:00	SPY	ETF	128.32	128.43	128.26	128.37	3374300.0
2006-06-01 15:00:00	SPY	ETF	128.37	128.66	128.2692	128.56	6122600.0
2006-06-01 15:30:00	SPY	ETF	128.57	128.94	128.55	128.83	11518100.0
2006-06-01 16:00:00	SPY	ETF	128.81	128.91	128.69	128.7	1472700.0
2006-06-01 16:30:00	SPY	ETF	128.7	128.74	128.69	128.73	111100.0
2006-06-01 17:00:00	SPY	ETF	128.74	128.75	128.72	128.72	5200.0
2006-06-01 17:30:00	SPY	ETF	128.73	128.75	128.71	128.75	5500.0
2006-06-01 18:00:00	SPY	ETF	128.72	128.79	128.72	128.72	5900.0
2006-06-01 18:30:00	SPY	ETF	128.68	128.68	128.68	128.68	400.0
2006-06-01 19:00:00	SPY	ETF	128.7	128.72	128.7	128.72	7300.0
2006-06-01 19:30:00	SPY	ETF	128.72	128.72	128.7	128.71	1500.0
2006-06-01 09:30:00	QQQ	ETF	38.91	39.1	38.84	39.02	17787200.0
2006-06-01 10:00:00	QQQ	ETF	39.03	39.06	38.92	39.03	9392900.0
2006-06-01 10:30:00	QQQ	ETF	39.02	39.27	39.02	39.2	15715200.0
2006-06-01 11:00:00	QQQ	ETF	39.19	39.31	39.17	39.25	6059300.0
2006-06-01 11:30:00	QQQ	ETF	39.25	39.31	39.2	39.21	3911200.0
2006-06-01 12:00:00	QQQ	ETF	39.21	39.27	39.2	39.24	2201400.0
2006-06-01 12:30:00	QQQ	ETF	39.25	39.36	39.24	39.26	7367400.0
2006-06-01 13:00:00	QQQ	ETF	39.26	39.32	39.24	39.31	3290500.0
2006-06-01 13:30:00	QQQ	ETF	39.3	39.34	39.25	39.33	3234100.0
2006-06-01 14:00:00	QQQ	ETF	39.34	39.44	39.29	39.42	7637100.0
2006-06-01 14:30:00	QQQ	ETF	39.43	39.51	39.41	39.48	7457700.0
2006-06-01 15:00:00	QQQ	ETF	39.48	39.61	39.4	39.56	9243100.0
2006-06-01 15:30:00	QQQ	ETF	39.55	39.73	39.55	39.72	15112600.0
2006-06-01 08:00:00	IWM	ETF	71.87	71.87	71.63	71.63	1103100.0
2006-06-01 08:30:00	IWM	ETF	71.68	72.0	71.67	71.9	715600.0
2006-06-01 09:00:00	IWM	ETF	71.89	71.94	71.82	71.87	474400.0
2006-06-01 09:30:00	IWM	ETF	71.88	72.3	71.65	72.06	6123200.0
2006-06-01 10:00:00	IWM	ETF	72.07	72.17	71.9	72.0699	3064000.0
2006-06-01 10:30:00	IWM	ETF	72.07	72.43	72.05	72.26	3170400.0
2006-06-01 11:00:00	IWM	ETF	72.24	72.58	72.19	72.52	3102100.0

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

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