PREVIEW / etf_1hour / 2008-02-06

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-02-06.parquet
  size:    101 KB
  rows:    3,327

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-06 04:00:00	SPY	ETF	134.49	134.49	134.49	134.49	200.0
2008-02-06 05:00:00	SPY	ETF	134.41	134.8	134.41	134.77	66700.0
2008-02-06 06:00:00	SPY	ETF	134.48	135.04	134.48	134.71	123400.0
2008-02-06 07:00:00	SPY	ETF	134.67	134.89	134.64	134.83	586800.0
2008-02-06 08:00:00	SPY	ETF	134.81	135.0	134.0	134.76	4647900.0
2008-02-06 09:00:00	SPY	ETF	134.78	134.81	133.45	133.9	25250682.0
2008-02-06 10:00:00	SPY	ETF	133.9101	134.89	133.9101	134.7	45792169.0
2008-02-06 11:00:00	SPY	ETF	134.69	135.25	134.56	134.9199	25311153.0
2008-02-06 12:00:00	SPY	ETF	134.92	135.03	134.16	134.34	19766732.0
2008-02-06 13:00:00	SPY	ETF	134.34	134.5854	133.57	133.63	19700944.0
2008-02-06 14:00:00	SPY	ETF	133.64	133.89	133.1	133.64	32200354.0
2008-02-06 15:00:00	SPY	ETF	133.63	133.81	132.41	132.72	56508742.0
2008-02-06 16:00:00	SPY	ETF	132.76	133.74	132.46	132.46	10402324.0
2008-02-06 17:00:00	SPY	ETF	132.5	132.74	132.0	132.09	3107100.0
2008-02-06 18:00:00	SPY	ETF	132.09	132.28	132.01	132.25	230900.0
2008-02-06 19:00:00	SPY	ETF	132.29	132.32	132.15	132.15	52700.0
2008-02-06 04:00:00	QQQ	ETF	43.81	43.81	43.81	43.81	300.0
2008-02-06 05:00:00	QQQ	ETF	43.95	43.96	43.95	43.96	1100.0
2008-02-06 07:00:00	QQQ	ETF	43.92	44.02	43.88	43.97	209759.0
2008-02-06 08:00:00	QQQ	ETF	43.97	43.99	43.83	43.92	1134901.0
2008-02-06 09:00:00	QQQ	ETF	43.93	43.94	43.62	43.79	14028505.0
2008-02-06 10:00:00	QQQ	ETF	43.8	44.1	43.73	43.98	37767429.0
2008-02-06 11:00:00	QQQ	ETF	43.98	44.17	43.92	44.0	17248379.0
2008-02-06 12:00:00	QQQ	ETF	44.0	44.04	43.74	43.8	9188974.0
2008-02-06 13:00:00	QQQ	ETF	43.81	43.83	43.33	43.36	11631395.0
2008-02-06 14:00:00	QQQ	ETF	43.359	43.44	43.06	43.3101	27311259.0
2008-02-06 15:00:00	QQQ	ETF	43.32	43.39	42.77	42.85	36075978.0
2008-02-06 16:00:00	QQQ	ETF	42.8401	44.12	42.12	42.42	18869257.0
2008-02-06 17:00:00	QQQ	ETF	42.42	42.52	42.13	42.24	4613686.0
2008-02-06 18:00:00	QQQ	ETF	42.23	42.29	42.22	42.28	502777.0
2008-02-06 19:00:00	QQQ	ETF	42.28	42.29	42.23	42.27	105263.0
2008-02-06 05:00:00	IWM	ETF	70.48	70.48	70.48	70.48	100.0
2008-02-06 07:00:00	IWM	ETF	70.55	70.69	70.49	70.62	90100.0
2008-02-06 08:00:00	IWM	ETF	70.6	70.7	70.42	70.65	701200.0
2008-02-06 09:00:00	IWM	ETF	70.68	70.69	69.55	69.75	13256462.0
2008-02-06 10:00:00	IWM	ETF	69.75	70.53	69.75	70.42	16507499.0
2008-02-06 11:00:00	IWM	ETF	70.39	70.83	70.31	70.8	8910159.0
2008-02-06 12:00:00	IWM	ETF	70.8	70.88	70.19	70.25	6394607.0
2008-02-06 13:00:00	IWM	ETF	70.28	70.41	69.71	69.78	8643450.0
2008-02-06 14:00:00	IWM	ETF	69.8	69.97	69.48	69.76	8421973.0
2008-02-06 15:00:00	IWM	ETF	69.76	70.8	68.84	68.89	26592246.0
2008-02-06 16:00:00	IWM	ETF	68.88	70.09	68.87	68.94	8078581.0
2008-02-06 17:00:00	IWM	ETF	68.86	68.88	68.5	68.6	616900.0
2008-02-06 18:00:00	IWM	ETF	68.6	68.76	68.6	68.76	95600.0
2008-02-06 19:00:00	IWM	ETF	68.72	68.72	68.72	68.72	200.0
2008-02-06 07:00:00	DIA	ETF	123.41	123.6	123.4	123.6	5800.0
2008-02-06 08:00:00	DIA	ETF	123.51	123.62	123.23	123.48	30700.0
2008-02-06 09:00:00	DIA	ETF	123.48	123.48	122.51	122.84	1604870.0
2008-02-06 10:00:00	DIA	ETF	122.85	123.67	122.85	123.51	3038595.0
2008-02-06 11:00:00	DIA	ETF	123.5	123.92	123.39	123.64	1727420.0

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

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