PREVIEW / etf_30min / 2006-07-31

all etf 30-min files

  file:    by_date/etf_30min/2006/2006-07-31.parquet
  size:    72 KB
  rows:    2,686

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-07-31 06:30:00	SPY	ETF	127.7	127.7	127.7	127.7	100.0
2006-07-31 07:00:00	SPY	ETF	127.66	127.79	127.66	127.75	25100.0
2006-07-31 07:30:00	SPY	ETF	127.74	127.79	127.74	127.79	12300.0
2006-07-31 08:00:00	SPY	ETF	127.63	127.84	127.63	127.71	113800.0
2006-07-31 08:30:00	SPY	ETF	127.71	127.8	127.61	127.61	363500.0
2006-07-31 09:00:00	SPY	ETF	127.64	127.71	127.6	127.7	233000.0
2006-07-31 09:30:00	SPY	ETF	127.66	127.72	126.55	127.6	8160300.0
2006-07-31 10:00:00	SPY	ETF	127.61	127.9	127.47	127.85	8649400.0
2006-07-31 10:30:00	SPY	ETF	127.85	127.87	127.63	127.76	2613100.0
2006-07-31 11:00:00	SPY	ETF	127.75	127.87	127.58	127.59	2542800.0
2006-07-31 11:30:00	SPY	ETF	127.59	127.72	127.57	127.65	2077800.0
2006-07-31 12:00:00	SPY	ETF	127.64	127.74	127.57	127.72	1207000.0
2006-07-31 12:30:00	SPY	ETF	127.72	127.73	127.53	127.56	4885800.0
2006-07-31 13:00:00	SPY	ETF	127.57	127.7	127.54	127.6	1487700.0
2006-07-31 13:30:00	SPY	ETF	127.58	127.89	127.58	127.82	2889200.0
2006-07-31 14:00:00	SPY	ETF	127.83	127.9	127.72	127.82	1577200.0
2006-07-31 14:30:00	SPY	ETF	127.82	127.84	127.65	127.73	1735200.0
2006-07-31 15:00:00	SPY	ETF	127.72	127.96	127.69	127.74	2908300.0
2006-07-31 15:30:00	SPY	ETF	127.75	127.93	127.67	127.67	4224800.0
2006-07-31 16:00:00	SPY	ETF	127.67	127.85	127.64	127.79	1937700.0
2006-07-31 16:30:00	SPY	ETF	127.8	127.83	127.7	127.74	377300.0
2006-07-31 17:00:00	SPY	ETF	127.74	127.75	127.73	127.73	30100.0
2006-07-31 17:30:00	SPY	ETF	127.73	127.75	127.73	127.75	3000.0
2006-07-31 18:00:00	SPY	ETF	127.8	127.8	127.76	127.76	200.0
2006-07-31 19:30:00	SPY	ETF	127.75	127.75	127.75	127.75	4000.0
2006-07-31 09:30:00	QQQ	ETF	37.08	37.08	36.89	37.01	13716600.0
2006-07-31 10:00:00	QQQ	ETF	37.01	37.32	36.92	37.28	11990300.0
2006-07-31 10:30:00	QQQ	ETF	37.28	37.3	37.13	37.22	7128300.0
2006-07-31 11:00:00	QQQ	ETF	37.23	37.27	36.91	37.08	4334500.0
2006-07-31 11:30:00	QQQ	ETF	37.09	37.14	37.08	37.1	1919600.0
2006-07-31 12:00:00	QQQ	ETF	37.1	37.13	37.06	37.1	2375600.0
2006-07-31 12:30:00	QQQ	ETF	37.1	37.11	37.0	37.02	4209900.0
2006-07-31 13:00:00	QQQ	ETF	37.02	37.06	37.0	37.03	1983300.0
2006-07-31 13:30:00	QQQ	ETF	37.03	37.23	37.02	37.14	7651100.0
2006-07-31 14:00:00	QQQ	ETF	37.13	37.18	37.1	37.13	3501700.0
2006-07-31 14:30:00	QQQ	ETF	37.13	37.14	37.04	37.07	3010000.0
2006-07-31 15:00:00	QQQ	ETF	37.07	37.17	37.04	37.1	3811700.0
2006-07-31 15:30:00	QQQ	ETF	37.1	37.15	37.07	37.09	6808400.0
2006-07-31 08:00:00	IWM	ETF	69.66	69.66	69.58	69.58	7000.0
2006-07-31 08:30:00	IWM	ETF	69.56	69.6	69.5	69.51	94900.0
2006-07-31 09:00:00	IWM	ETF	69.54	69.54	69.42	69.44	247800.0
2006-07-31 09:30:00	IWM	ETF	69.43	69.47	69.11	69.3	4610200.0
2006-07-31 10:00:00	IWM	ETF	69.3	69.58	69.09	69.54	3179500.0
2006-07-31 10:30:00	IWM	ETF	69.55	69.57	69.28	69.48	2466500.0
2006-07-31 11:00:00	IWM	ETF	69.49	69.56	69.19	69.2	3680300.0
2006-07-31 11:30:00	IWM	ETF	69.21	69.41	69.17	69.36	1839000.0
2006-07-31 12:00:00	IWM	ETF	69.35	69.41	69.27	69.33	577000.0
2006-07-31 12:30:00	IWM	ETF	69.32	69.35	69.16	69.19	1834800.0
2006-07-31 13:00:00	IWM	ETF	69.19	69.26	69.06	69.2	1856600.0
2006-07-31 13:30:00	IWM	ETF	69.2	69.58	69.18	69.49	3714300.0

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

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