PREVIEW / etf_30min / 2006-08-02

all etf 30-min files

  file:    by_date/etf_30min/2006/2006-08-02.parquet
  size:    77 KB
  rows:    2,719

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-02 04:00:00	SPY	ETF	127.47	127.47	127.47	127.47	500.0
2006-08-02 07:00:00	SPY	ETF	127.6	127.6	127.47	127.56	28500.0
2006-08-02 07:30:00	SPY	ETF	127.58	127.65	127.56	127.56	113200.0
2006-08-02 08:00:00	SPY	ETF	127.53	127.64	127.22	127.45	227700.0
2006-08-02 08:30:00	SPY	ETF	127.47	127.5	127.4	127.47	52800.0
2006-08-02 09:00:00	SPY	ETF	127.47	127.62	127.44	127.58	967800.0
2006-08-02 09:30:00	SPY	ETF	127.58	127.91	127.55	127.77	6425200.0
2006-08-02 10:00:00	SPY	ETF	127.77	127.85	127.55	127.66	4288200.0
2006-08-02 10:30:00	SPY	ETF	127.66	127.79	127.59	127.68	2557800.0
2006-08-02 11:00:00	SPY	ETF	127.69	128.16	127.68	128.0	7657600.0
2006-08-02 11:30:00	SPY	ETF	127.99	128.39	127.97	128.36	5193300.0
2006-08-02 12:00:00	SPY	ETF	128.36	128.46	128.25	128.3	3105500.0
2006-08-02 12:30:00	SPY	ETF	128.3	128.3	128.18	128.27	2571300.0
2006-08-02 13:00:00	SPY	ETF	128.28	128.32	128.14	128.25	1857600.0
2006-08-02 13:30:00	SPY	ETF	128.25	128.32	128.19	128.25	1488000.0
2006-08-02 14:00:00	SPY	ETF	128.25	128.43	127.98	128.03	4186000.0
2006-08-02 14:30:00	SPY	ETF	128.04	128.11	127.9	127.93	3706900.0
2006-08-02 15:00:00	SPY	ETF	127.92	127.93	127.65	127.8	6506900.0
2006-08-02 15:30:00	SPY	ETF	127.8	128.02	127.8	127.91	5512800.0
2006-08-02 16:00:00	SPY	ETF	127.9	128.1	127.84	128.05	727400.0
2006-08-02 16:30:00	SPY	ETF	128.06	128.06	127.98	128.01	143700.0
2006-08-02 17:00:00	SPY	ETF	128.01	128.08	127.0076	128.07	5561800.0
2006-08-02 17:30:00	SPY	ETF	128.07	128.08	128.0	128.0	1500.0
2006-08-02 18:00:00	SPY	ETF	128.02	128.07	128.0	128.07	16100.0
2006-08-02 18:30:00	SPY	ETF	128.07	128.07	128.02	128.02	2600.0
2006-08-02 19:00:00	SPY	ETF	128.02	128.02	128.02	128.02	2900.0
2006-08-02 19:30:00	SPY	ETF	128.03	128.03	128.03	128.03	400.0
2006-08-02 09:30:00	QQQ	ETF	36.61	36.87	36.61	36.79	14303800.0
2006-08-02 10:00:00	QQQ	ETF	36.79	36.82	36.67	36.73	7335300.0
2006-08-02 10:30:00	QQQ	ETF	36.73	36.8	36.66	36.7	5792800.0
2006-08-02 11:00:00	QQQ	ETF	36.71	36.91	36.7	36.84	6918100.0
2006-08-02 11:30:00	QQQ	ETF	36.84	37.03	36.84	37.0	5074300.0
2006-08-02 12:00:00	QQQ	ETF	37.0	37.13	36.97	37.04	6738100.0
2006-08-02 12:30:00	QQQ	ETF	37.03	37.08	36.98	37.07	2687200.0
2006-08-02 13:00:00	QQQ	ETF	37.07	37.08	37.01	37.04	2368200.0
2006-08-02 13:30:00	QQQ	ETF	37.04	37.07	37.02	37.06	2418200.0
2006-08-02 14:00:00	QQQ	ETF	37.05	37.12	36.95	36.97	6846900.0
2006-08-02 14:30:00	QQQ	ETF	36.97	37.0	36.89	36.92	7799000.0
2006-08-02 15:00:00	QQQ	ETF	36.92	36.93	36.8	36.85	6541000.0
2006-08-02 15:30:00	QQQ	ETF	36.84	36.96	36.84	36.89	7199900.0
2006-08-02 07:30:00	IWM	ETF	68.95	68.95	68.95	68.95	1000.0
2006-08-02 08:00:00	IWM	ETF	68.95	69.0	68.59	68.59	18700.0
2006-08-02 08:30:00	IWM	ETF	68.93	68.94	68.86	68.9	42200.0
2006-08-02 09:00:00	IWM	ETF	68.9	69.05	68.9	69.01	116700.0
2006-08-02 09:30:00	IWM	ETF	69.01	69.45	68.97	69.2	9479200.0
2006-08-02 10:00:00	IWM	ETF	69.2	69.27	68.9	69.04	2594200.0
2006-08-02 10:30:00	IWM	ETF	69.04	69.23	68.96	69.08	2199700.0
2006-08-02 11:00:00	IWM	ETF	69.09	69.55	68.64	69.34	5051700.0
2006-08-02 11:30:00	IWM	ETF	69.35	69.55	69.29	69.51	2541500.0
2006-08-02 12:00:00	IWM	ETF	69.5	69.6	69.45	69.48	3771000.0

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

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