PREVIEW / etf_30min / 2006-08-03

all etf 30-min files

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

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-03 04:00:00	SPY	ETF	127.74	127.74	127.74	127.74	1200.0
2006-08-03 05:00:00	SPY	ETF	127.75	127.75	127.75	127.75	100.0
2006-08-03 07:00:00	SPY	ETF	127.66	127.66	127.47	127.57	110300.0
2006-08-03 07:30:00	SPY	ETF	127.5	127.57	127.44	127.57	73300.0
2006-08-03 08:00:00	SPY	ETF	127.58	127.69	127.44	127.48	587100.0
2006-08-03 08:30:00	SPY	ETF	127.47	127.49	127.23	127.38	1590800.0
2006-08-03 09:00:00	SPY	ETF	127.38	127.4	127.26	127.33	1009800.0
2006-08-03 09:30:00	SPY	ETF	127.33	127.51	127.15	127.44	7539600.0
2006-08-03 10:00:00	SPY	ETF	127.4495	127.74	127.36	127.66	6062400.0
2006-08-03 10:30:00	SPY	ETF	127.6605	127.83	127.48	127.81	4925700.0
2006-08-03 11:00:00	SPY	ETF	127.81	127.94	127.59	127.6	3897300.0
2006-08-03 11:30:00	SPY	ETF	127.59	127.64	127.46	127.55	2329800.0
2006-08-03 12:00:00	SPY	ETF	127.55	127.73	127.55	127.73	1057300.0
2006-08-03 12:30:00	SPY	ETF	127.72	127.86	127.7	127.8005	1937800.0
2006-08-03 13:00:00	SPY	ETF	127.81	128.33	127.81	128.17	7008400.0
2006-08-03 13:30:00	SPY	ETF	128.18	128.42	128.07	128.31	4217200.0
2006-08-03 14:00:00	SPY	ETF	128.32	128.52	128.2	128.32	4791700.0
2006-08-03 14:30:00	SPY	ETF	128.32	128.55	128.25	128.44	3525800.0
2006-08-03 15:00:00	SPY	ETF	128.42	128.5	128.29	128.46	3127500.0
2006-08-03 15:30:00	SPY	ETF	128.46	128.49	128.04	128.11	7240400.0
2006-08-03 16:00:00	SPY	ETF	128.11	128.45	128.1	128.42	561000.0
2006-08-03 16:30:00	SPY	ETF	128.42	128.42	128.34	128.35	212500.0
2006-08-03 17:00:00	SPY	ETF	128.34	128.35	128.32	128.33	10900.0
2006-08-03 17:30:00	SPY	ETF	128.37	128.37	128.35	128.37	6100.0
2006-08-03 18:00:00	SPY	ETF	128.35	128.37	128.35	128.37	6200.0
2006-08-03 18:30:00	SPY	ETF	128.34	128.38	128.34	128.34	33400.0
2006-08-03 19:30:00	SPY	ETF	128.33	128.33	128.33	128.33	600.0
2006-08-03 09:30:00	QQQ	ETF	36.54	36.67	36.48	36.64	11943100.0
2006-08-03 10:00:00	QQQ	ETF	36.64	36.86	36.6	36.83	9487600.0
2006-08-03 10:30:00	QQQ	ETF	36.82	36.85	36.7	36.84	4648000.0
2006-08-03 11:00:00	QQQ	ETF	36.85	36.92	36.75	36.78	6008700.0
2006-08-03 11:30:00	QQQ	ETF	36.78	36.79	36.71	36.73	3408300.0
2006-08-03 12:00:00	QQQ	ETF	36.73	36.83	36.72	36.82	2531200.0
2006-08-03 12:30:00	QQQ	ETF	36.82	36.9	36.82	36.89	3647500.0
2006-08-03 13:00:00	QQQ	ETF	36.89	37.23	36.89	37.18	11599700.0
2006-08-03 13:30:00	QQQ	ETF	37.18	37.27	37.11	37.24	6750100.0
2006-08-03 14:00:00	QQQ	ETF	37.24	37.34	37.16	37.22	8572700.0
2006-08-03 14:30:00	QQQ	ETF	37.22	37.32	37.19	37.29	4328900.0
2006-08-03 15:00:00	QQQ	ETF	37.29	37.32	37.2	37.27	6145600.0
2006-08-03 15:30:00	QQQ	ETF	37.27	37.29	37.07	37.1	10289700.0
2006-08-03 07:30:00	IWM	ETF	69.1	69.1	69.1	69.1	100.0
2006-08-03 08:00:00	IWM	ETF	69.0	69.5	68.96	69.0	575600.0
2006-08-03 08:30:00	IWM	ETF	68.96	69.03	68.76	68.86	164500.0
2006-08-03 09:00:00	IWM	ETF	68.86	68.87	68.73	68.8	207700.0
2006-08-03 09:30:00	IWM	ETF	68.78	68.82	68.54	68.63	4676100.0
2006-08-03 10:00:00	IWM	ETF	68.64	69.09	68.57	68.97	4158000.0
2006-08-03 10:30:00	IWM	ETF	68.96	69.13	68.74	69.12	2934100.0
2006-08-03 11:00:00	IWM	ETF	69.12	69.21	68.87	68.94	2674300.0
2006-08-03 11:30:00	IWM	ETF	68.95	69.02	68.84	68.93	1067300.0
2006-08-03 12:00:00	IWM	ETF	68.92	69.16	68.91	69.15	1047100.0

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

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