PREVIEW / etf_30min / 2007-02-02

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-02-02.parquet
  size:    94 KB
  rows:    3,386

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
2007-02-02 06:30:00	SPY	ETF	144.65	144.65	144.65	144.65	7500.0
2007-02-02 07:00:00	SPY	ETF	144.62	144.67	144.62	144.67	8000.0
2007-02-02 07:30:00	SPY	ETF	144.67	144.67	144.61	144.61	15800.0
2007-02-02 08:00:00	SPY	ETF	144.62	144.67	144.54	144.58	102900.0
2007-02-02 08:30:00	SPY	ETF	144.58	144.98	144.46	144.94	2461400.0
2007-02-02 09:00:00	SPY	ETF	144.95	144.96	144.74	144.74	757800.0
2007-02-02 09:30:00	SPY	ETF	144.73	144.8	144.38	144.41	7325500.0
2007-02-02 10:00:00	SPY	ETF	144.42	144.84	144.39	144.75	6776100.0
2007-02-02 10:30:00	SPY	ETF	144.75	144.9	144.73	144.78	3636500.0
2007-02-02 11:00:00	SPY	ETF	144.79	144.79	144.6	144.6399	2641900.0
2007-02-02 11:30:00	SPY	ETF	144.64	144.73	144.45	144.71	3813700.0
2007-02-02 12:00:00	SPY	ETF	144.71	144.85	144.64	144.69	2240400.0
2007-02-02 12:30:00	SPY	ETF	144.69	144.83	144.69	144.81	572600.0
2007-02-02 13:00:00	SPY	ETF	144.82	144.89	144.77	144.81	1904300.0
2007-02-02 13:30:00	SPY	ETF	144.81	144.89	144.79	144.84	1254300.0
2007-02-02 14:00:00	SPY	ETF	144.83	144.95	144.62	144.66	2956600.0
2007-02-02 14:30:00	SPY	ETF	144.6699	144.83	144.62	144.77	2517000.0
2007-02-02 15:00:00	SPY	ETF	144.78	144.85	144.69	144.78	1928500.0
2007-02-02 15:30:00	SPY	ETF	144.77	144.87	144.72	144.79	3929700.0
2007-02-02 16:00:00	SPY	ETF	144.79	144.85	144.68	144.79	1603600.0
2007-02-02 16:30:00	SPY	ETF	144.79	144.8	144.51	144.77	885600.0
2007-02-02 17:00:00	SPY	ETF	144.77	144.94	144.77	144.77	37700.0
2007-02-02 17:30:00	SPY	ETF	144.8	144.8	144.8	144.8	500.0
2007-02-02 18:00:00	SPY	ETF	144.8	144.8	144.78	144.78	600.0
2007-02-02 07:30:00	QQQ	ETF	44.07	44.07	44.07	44.07	200.0
2007-02-02 08:00:00	QQQ	ETF	44.07	44.07	44.01	44.03	993028.0
2007-02-02 08:30:00	QQQ	ETF	44.0	44.22	43.99	44.19	4177530.0
2007-02-02 09:00:00	QQQ	ETF	44.19	44.2	44.1	44.11	688516.0
2007-02-02 09:30:00	QQQ	ETF	44.11	44.17	43.94	43.96	14824400.0
2007-02-02 10:00:00	QQQ	ETF	43.96	44.25	43.94	44.17	15674000.0
2007-02-02 10:30:00	QQQ	ETF	44.17	44.25	44.11	44.17	6076500.0
2007-02-02 11:00:00	QQQ	ETF	44.16	44.2	44.1	44.14	6225100.0
2007-02-02 11:30:00	QQQ	ETF	44.14	44.16	43.99	44.14	10136700.0
2007-02-02 12:00:00	QQQ	ETF	44.14	44.22	44.09	44.12	4059500.0
2007-02-02 12:30:00	QQQ	ETF	44.13	44.23	44.12	44.2	2990800.0
2007-02-02 13:00:00	QQQ	ETF	44.21	44.24	44.15	44.18	2069700.0
2007-02-02 13:30:00	QQQ	ETF	44.18	44.22	44.16	44.18	1680600.0
2007-02-02 14:00:00	QQQ	ETF	44.18	44.21	44.03	44.07	7532300.0
2007-02-02 14:30:00	QQQ	ETF	44.07	44.11	44.01	44.1	6994700.0
2007-02-02 15:00:00	QQQ	ETF	44.1	44.17	44.06	44.11	3477300.0
2007-02-02 15:30:00	QQQ	ETF	44.11	44.17	44.1	44.17	5703800.0
2007-02-02 16:00:00	QQQ	ETF	44.16	44.19	44.14	44.18	3460756.0
2007-02-02 16:30:00	QQQ	ETF	44.17	44.18	44.16	44.17	24517.0
2007-02-02 17:00:00	QQQ	ETF	44.17	44.18	44.17	44.18	13731.0
2007-02-02 17:30:00	QQQ	ETF	44.19	44.2	44.17	44.18	26575.0
2007-02-02 18:00:00	QQQ	ETF	44.2	44.21	44.18	44.18	9700.0
2007-02-02 18:30:00	QQQ	ETF	44.19	44.21	44.19	44.21	2900.0
2007-02-02 19:00:00	QQQ	ETF	44.22	44.22	44.2	44.22	7372.0
2007-02-02 19:30:00	QQQ	ETF	44.21	44.22	44.21	44.21	5287.0
2007-02-02 07:30:00	IWM	ETF	80.12	80.12	80.11	80.11	3000.0

> showing 50 of 3,386 rows — these rows as CSV

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