PREVIEW / etf_1hour / 2008-01-25

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-01-25.parquet
  size:    101 KB
  rows:    3,367

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
2008-01-25 04:00:00	SPY	ETF	136.15	136.15	135.55	135.75	33300.0
2008-01-25 05:00:00	SPY	ETF	135.77	135.93	135.72	135.75	14200.0
2008-01-25 06:00:00	SPY	ETF	135.81	136.1	135.81	135.98	45700.0
2008-01-25 07:00:00	SPY	ETF	135.88	136.07	135.67	136.03	595400.0
2008-01-25 08:00:00	SPY	ETF	135.99	136.25	135.84	136.2	3612700.0
2008-01-25 09:00:00	SPY	ETF	136.2	136.76	135.91	136.08	29984387.0
2008-01-25 10:00:00	SPY	ETF	136.08	136.57	134.75	134.84	48046470.0
2008-01-25 11:00:00	SPY	ETF	134.85	136.51	134.4	135.24	40461133.0
2008-01-25 12:00:00	SPY	ETF	135.25	135.35	133.77	133.98	25311805.0
2008-01-25 13:00:00	SPY	ETF	133.98	135.3001	132.6	133.03	40441454.0
2008-01-25 14:00:00	SPY	ETF	133.01	135.1218	132.67	133.09	34701461.0
2008-01-25 15:00:00	SPY	ETF	133.09	134.05	132.63	132.98	36656894.0
2008-01-25 16:00:00	SPY	ETF	132.98	135.83	132.82	133.21	7866073.0
2008-01-25 17:00:00	SPY	ETF	133.21	135.29	133.08	133.22	1015000.0
2008-01-25 18:00:00	SPY	ETF	133.23	133.33	133.2	133.3	36600.0
2008-01-25 19:00:00	SPY	ETF	133.3	133.34	133.02	133.1	3000.0
2008-01-25 04:00:00	QQQ	ETF	45.44	45.44	45.44	45.44	400.0
2008-01-25 05:00:00	QQQ	ETF	45.47	45.53	45.47	45.53	2000.0
2008-01-25 06:00:00	QQQ	ETF	45.56	45.56	45.55	45.55	50500.0
2008-01-25 07:00:00	QQQ	ETF	45.51	45.56	45.42	45.54	541576.0
2008-01-25 08:00:00	QQQ	ETF	45.55	45.77	45.49	45.76	1843271.0
2008-01-25 09:00:00	QQQ	ETF	45.76	45.88	45.3	45.35	31000583.0
2008-01-25 10:00:00	QQQ	ETF	45.35	45.36	44.71	44.78	37947413.0
2008-01-25 11:00:00	QQQ	ETF	44.79	44.95	44.59	44.9	27738088.0
2008-01-25 12:00:00	QQQ	ETF	44.9	44.96	44.42	44.48	15771876.0
2008-01-25 13:00:00	QQQ	ETF	44.48	44.58	44.11	44.17	26043771.0
2008-01-25 14:00:00	QQQ	ETF	44.17	44.4	44.02	44.16	22733808.0
2008-01-25 15:00:00	QQQ	ETF	44.16	44.46	43.94	43.99	33601721.0
2008-01-25 16:00:00	QQQ	ETF	43.99	44.0	43.89	43.94	1733454.0
2008-01-25 17:00:00	QQQ	ETF	43.93	44.05	43.93	43.96	283358.0
2008-01-25 18:00:00	QQQ	ETF	44.0	44.04	43.91	43.91	7203.0
2008-01-25 19:00:00	QQQ	ETF	43.96	43.96	43.93	43.93	30435.0
2008-01-25 07:00:00	IWM	ETF	69.58	69.65	69.58	69.65	17500.0
2008-01-25 08:00:00	IWM	ETF	69.65	69.84	69.65	69.84	336800.0
2008-01-25 09:00:00	IWM	ETF	69.84	70.22	69.74	69.81	9087778.0
2008-01-25 10:00:00	IWM	ETF	69.81	69.83	69.29	69.43	16325518.0
2008-01-25 11:00:00	IWM	ETF	69.44	69.88	69.25	69.88	13383040.0
2008-01-25 12:00:00	IWM	ETF	69.89	69.93	68.92	69.14	16779240.0
2008-01-25 13:00:00	IWM	ETF	69.15	69.3	68.29	68.57	13127023.0
2008-01-25 14:00:00	IWM	ETF	68.57	68.81	68.08	68.33	11771649.0
2008-01-25 15:00:00	IWM	ETF	68.33	68.78	68.18	68.54	11168710.0
2008-01-25 16:00:00	IWM	ETF	68.54	68.97	67.98	68.05	7168003.0
2008-01-25 17:00:00	IWM	ETF	68.07	68.47	68.0	68.47	11400.0
2008-01-25 18:00:00	IWM	ETF	68.24	68.25	68.24	68.25	1000.0
2008-01-25 19:00:00	IWM	ETF	68.25	68.25	68.19	68.25	400.0
2008-01-25 07:00:00	DIA	ETF	124.27	124.29	124.22	124.22	1500.0
2008-01-25 08:00:00	DIA	ETF	124.25	124.45	124.15	124.38	41400.0
2008-01-25 09:00:00	DIA	ETF	124.41	124.71	124.2	124.29	1974937.0
2008-01-25 10:00:00	DIA	ETF	124.3	124.43	123.36	123.45	4440260.0
2008-01-25 11:00:00	DIA	ETF	123.46	123.9	123.07	123.81	2787694.0

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

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