PREVIEW / etf_30min / 2006-02-02

all etf 30-min files

  file:    by_date/etf_30min/2006/2006-02-02.parquet
  size:    60 KB
  rows:    2,138

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-02-02 05:00:00	SPY	ETF	128.05	128.05	128.02	128.02	1900.0
2006-02-02 07:00:00	SPY	ETF	128.0	128.0	127.97	127.97	22400.0
2006-02-02 07:30:00	SPY	ETF	127.98	127.99	127.93	127.97	33900.0
2006-02-02 08:00:00	SPY	ETF	127.94	128.06	127.94	128.01	368200.0
2006-02-02 08:30:00	SPY	ETF	128.01	128.4	127.93	128.02	1230300.0
2006-02-02 09:00:00	SPY	ETF	128.03	128.12	128.0	128.12	207800.0
2006-02-02 09:30:00	SPY	ETF	128.1	128.14	127.89	128.02	5545500.0
2006-02-02 10:00:00	SPY	ETF	128.0	128.1	127.87	127.94	4333000.0
2006-02-02 10:30:00	SPY	ETF	127.94	128.02	127.5	127.53	10047300.0
2006-02-02 11:00:00	SPY	ETF	127.53	127.58	126.85	126.91	11251600.0
2006-02-02 11:30:00	SPY	ETF	126.91	127.23	126.8	127.11	9696900.0
2006-02-02 12:00:00	SPY	ETF	127.11	127.42	127.04	127.1	7557800.0
2006-02-02 12:30:00	SPY	ETF	127.1	127.29	127.01	127.16	1752100.0
2006-02-02 13:00:00	SPY	ETF	127.15	127.23	127.0	127.0288	1890100.0
2006-02-02 13:30:00	SPY	ETF	127.0299	127.16	126.83	127.1	6202000.0
2006-02-02 14:00:00	SPY	ETF	127.11	127.17	126.94	126.99	2529200.0
2006-02-02 14:30:00	SPY	ETF	126.98	127.27	126.92	126.97	2821600.0
2006-02-02 15:00:00	SPY	ETF	126.97	127.25	126.82	127.19	4196000.0
2006-02-02 15:30:00	SPY	ETF	127.2	127.28	127.09	127.11	4427900.0
2006-02-02 16:00:00	SPY	ETF	127.11	127.16	126.84	126.85	3329900.0
2006-02-02 16:30:00	SPY	ETF	126.85	126.94	126.85	126.88	165200.0
2006-02-02 17:00:00	SPY	ETF	126.89	126.9	126.87	126.88	2900.0
2006-02-02 17:30:00	SPY	ETF	126.9	126.95	126.9	126.95	1900.0
2006-02-02 18:00:00	SPY	ETF	126.9	126.9	126.88	126.9	1400.0
2006-02-02 09:30:00	QQQ	ETF	42.01	42.08	41.05	41.96	8127900.0
2006-02-02 10:00:00	QQQ	ETF	41.96	41.99	41.85	41.89	7987900.0
2006-02-02 10:30:00	QQQ	ETF	41.89	41.93	41.62	41.66	9975400.0
2006-02-02 11:00:00	QQQ	ETF	41.66	41.66	41.47	41.5	10612000.0
2006-02-02 11:30:00	QQQ	ETF	41.51	41.67	41.44	41.54	7242500.0
2006-02-02 12:00:00	QQQ	ETF	41.53	41.8	41.5	41.51	7093300.0
2006-02-02 12:30:00	QQQ	ETF	41.52	41.6	41.48	41.54	2467800.0
2006-02-02 13:00:00	QQQ	ETF	41.53	41.6	41.5	41.52	2482800.0
2006-02-02 13:30:00	QQQ	ETF	41.52	41.62	41.47	41.59	4067200.0
2006-02-02 14:00:00	QQQ	ETF	41.59	41.62	41.5	41.51	3643700.0
2006-02-02 14:30:00	QQQ	ETF	41.52	41.62	41.49	41.49	4589900.0
2006-02-02 15:00:00	QQQ	ETF	41.49	41.58	41.41	41.57	6179200.0
2006-02-02 15:30:00	QQQ	ETF	41.58	41.6	41.44	41.44	8261700.0
2006-02-02 07:30:00	IWM	ETF	72.87	72.87	72.87	72.87	2000.0
2006-02-02 08:00:00	IWM	ETF	72.98	72.98	72.98	72.98	100.0
2006-02-02 08:30:00	IWM	ETF	72.93	73.09	72.9	72.9	18100.0
2006-02-02 09:00:00	IWM	ETF	72.94	72.98	72.92	72.98	10100.0
2006-02-02 09:30:00	IWM	ETF	73.0	73.09	72.84	73.02	4258100.0
2006-02-02 10:00:00	IWM	ETF	73.02	73.05	72.75	72.76	4456900.0
2006-02-02 10:30:00	IWM	ETF	72.77	72.82	72.26	72.28	4625400.0
2006-02-02 11:00:00	IWM	ETF	72.28	72.28	71.69	71.69	9567200.0
2006-02-02 11:30:00	IWM	ETF	71.69	71.9	71.66	71.89	5019200.0
2006-02-02 12:00:00	IWM	ETF	71.9	72.17	71.8	71.96	2575200.0
2006-02-02 12:30:00	IWM	ETF	71.97	72.24	71.93	72.15	1347900.0
2006-02-02 13:00:00	IWM	ETF	72.15	72.21	72.04	72.04	1413000.0
2006-02-02 13:30:00	IWM	ETF	72.04	72.06	71.83	72.03	1465000.0

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

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