PREVIEW / etf_1hour / 2008-02-15

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-02-15.parquet
  size:    96 KB
  rows:    3,228

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-02-15 04:00:00	SPY	ETF	135.51	135.56	135.51	135.56	12800.0
2008-02-15 05:00:00	SPY	ETF	135.34	135.34	135.22	135.22	14000.0
2008-02-15 06:00:00	SPY	ETF	135.26	135.26	134.99	134.99	15100.0
2008-02-15 07:00:00	SPY	ETF	135.06	135.07	134.18	134.27	1444600.0
2008-02-15 08:00:00	SPY	ETF	134.29	134.57	133.77	134.24	4850700.0
2008-02-15 09:00:00	SPY	ETF	134.22	135.64	133.36	134.13	25836311.0
2008-02-15 10:00:00	SPY	ETF	134.13	135.0	134.06	134.48	26774444.0
2008-02-15 11:00:00	SPY	ETF	134.48	134.66	134.03	134.2	18011824.0
2008-02-15 12:00:00	SPY	ETF	134.2	134.58	133.91	134.14	13764150.0
2008-02-15 13:00:00	SPY	ETF	134.14	134.64	133.92	134.56	10326016.0
2008-02-15 14:00:00	SPY	ETF	134.56	134.6	134.18	134.44	11665194.0
2008-02-15 15:00:00	SPY	ETF	134.43	136.1	134.35	135.06	28214578.0
2008-02-15 16:00:00	SPY	ETF	135.06	135.22	135.0	135.13	9459800.0
2008-02-15 17:00:00	SPY	ETF	135.06	135.25	135.0	135.18	417400.0
2008-02-15 18:00:00	SPY	ETF	135.18	135.3	135.1	135.22	169400.0
2008-02-15 19:00:00	SPY	ETF	135.21	135.22	135.15	135.15	1800.0
2008-02-15 04:00:00	QQQ	ETF	44.08	44.17	44.08	44.17	2200.0
2008-02-15 06:00:00	QQQ	ETF	43.98	44.01	43.97	43.97	10400.0
2008-02-15 07:00:00	QQQ	ETF	43.93	43.93	43.72	43.73	280323.0
2008-02-15 08:00:00	QQQ	ETF	43.73	43.75	43.51	43.7	1656739.0
2008-02-15 09:00:00	QQQ	ETF	43.71	43.92	43.62	43.7	19525493.0
2008-02-15 10:00:00	QQQ	ETF	43.69	43.98	43.67	43.75	16550900.0
2008-02-15 11:00:00	QQQ	ETF	43.75	43.8	43.56	43.66	9315363.0
2008-02-15 12:00:00	QQQ	ETF	43.65	43.76	43.5	43.56	11701736.0
2008-02-15 13:00:00	QQQ	ETF	43.56	43.68	43.45	43.65	7925164.0
2008-02-15 14:00:00	QQQ	ETF	43.6425	43.66	43.5	43.58	7396291.0
2008-02-15 15:00:00	QQQ	ETF	43.57	43.82	43.52	43.82	16264599.0
2008-02-15 16:00:00	QQQ	ETF	43.81	43.969	43.51	43.76	8736762.0
2008-02-15 17:00:00	QQQ	ETF	43.78	43.9	43.72	43.89	658892.0
2008-02-15 18:00:00	QQQ	ETF	43.89	43.89	43.82	43.86	18368.0
2008-02-15 19:00:00	QQQ	ETF	43.87	43.88	43.86	43.88	12100.0
2008-02-15 05:00:00	IWM	ETF	70.21	70.21	70.2	70.2	10000.0
2008-02-15 07:00:00	IWM	ETF	70.05	70.06	69.02	69.55	750000.0
2008-02-15 08:00:00	IWM	ETF	69.55	69.66	69.21	69.5	654900.0
2008-02-15 09:00:00	IWM	ETF	69.55	70.0	69.3	69.46	9705773.0
2008-02-15 10:00:00	IWM	ETF	69.45	69.95	69.36	69.59	9538705.0
2008-02-15 11:00:00	IWM	ETF	69.59	69.64	69.19	69.43	9005197.0
2008-02-15 12:00:00	IWM	ETF	69.42	69.6	69.17	69.29	5209276.0
2008-02-15 13:00:00	IWM	ETF	69.3	69.7	69.15	69.54	5187789.0
2008-02-15 14:00:00	IWM	ETF	69.53	69.6	69.28	69.47	7630065.0
2008-02-15 15:00:00	IWM	ETF	69.47	70.09	68.0	70.08	13526207.0
2008-02-15 16:00:00	IWM	ETF	70.08	70.09	69.59	69.86	3756200.0
2008-02-15 17:00:00	IWM	ETF	69.9	69.9	69.8	69.8	500.0
2008-02-15 18:00:00	IWM	ETF	69.8	69.8	69.8	69.8	200.0
2008-02-15 07:00:00	DIA	ETF	123.78	123.84	123.14	123.18	106700.0
2008-02-15 08:00:00	DIA	ETF	123.22	123.29	122.79	123.01	114300.0
2008-02-15 09:00:00	DIA	ETF	123.01	123.44	122.81	122.96	1828284.0
2008-02-15 10:00:00	DIA	ETF	122.96	123.57	122.88	123.16	2047594.0
2008-02-15 11:00:00	DIA	ETF	123.15	123.26	122.86	122.99	1055500.0
2008-02-15 12:00:00	DIA	ETF	123.01	123.28	122.71	122.86	1237594.0

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

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