PREVIEW / etf_1hour / 2008-09-05

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-09-05.parquet
  size:    116 KB
  rows:    3,713

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-09-05 04:00:00	SPY	ETF	123.24	123.24	123.22	123.22	300.0
2008-09-05 05:00:00	SPY	ETF	123.26	123.52	123.25	123.42	5000.0
2008-09-05 06:00:00	SPY	ETF	123.41	123.47	123.33	123.4	190450.0
2008-09-05 07:00:00	SPY	ETF	123.37	123.85	123.3	123.82	1173317.0
2008-09-05 08:00:00	SPY	ETF	123.83	123.85	122.46	122.8	15584051.0
2008-09-05 09:00:00	SPY	ETF	122.8	123.84	122.78	123.3	35059443.0
2008-09-05 10:00:00	SPY	ETF	123.305	123.57	122.0	122.33	48825318.0
2008-09-05 11:00:00	SPY	ETF	122.33	123.67	122.11	123.395	46810724.0
2008-09-05 12:00:00	SPY	ETF	123.39	123.87	123.09	123.61	30026827.0
2008-09-05 13:00:00	SPY	ETF	123.61	124.09	123.46	123.87	26382165.0
2008-09-05 14:00:00	SPY	ETF	123.86	124.71	123.54	124.51	27699405.0
2008-09-05 15:00:00	SPY	ETF	124.5	124.95	124.07	124.64	43784794.0
2008-09-05 16:00:00	SPY	ETF	124.7	126.2	124.28	126.09	9061774.0
2008-09-05 17:00:00	SPY	ETF	126.11	126.4	125.75	126.0	1712593.0
2008-09-05 18:00:00	SPY	ETF	126.02	126.13	125.87	125.9	483576.0
2008-09-05 19:00:00	SPY	ETF	125.9	126.01	125.82	125.85	70282.0
2008-09-05 04:00:00	QQQ	ETF	43.63	43.63	43.63	43.63	300.0
2008-09-05 05:00:00	QQQ	ETF	43.53	43.53	43.52	43.52	3000.0
2008-09-05 06:00:00	QQQ	ETF	43.51	43.55	43.5	43.5	30300.0
2008-09-05 07:00:00	QQQ	ETF	43.5	43.72	43.5	43.69	572734.0
2008-09-05 08:00:00	QQQ	ETF	43.69	43.7	43.03	43.14	8620879.0
2008-09-05 09:00:00	QQQ	ETF	43.13	43.55	43.13	43.47	40520462.0
2008-09-05 10:00:00	QQQ	ETF	43.47	43.6005	42.93	42.96	46478907.0
2008-09-05 11:00:00	QQQ	ETF	42.97	43.41	42.81	43.3	32816732.0
2008-09-05 12:00:00	QQQ	ETF	43.3	43.56	43.23	43.45	22874209.0
2008-09-05 13:00:00	QQQ	ETF	43.4499	43.72	43.32	43.5	18714319.0
2008-09-05 14:00:00	QQQ	ETF	43.5	43.78	43.32	43.69	27966025.0
2008-09-05 15:00:00	QQQ	ETF	43.68	43.71	43.43	43.5	35408507.0
2008-09-05 16:00:00	QQQ	ETF	43.5	44.08	43.44	44.08	5098461.0
2008-09-05 17:00:00	QQQ	ETF	44.08	44.1	43.9	43.98	528151.0
2008-09-05 18:00:00	QQQ	ETF	43.98	44.03	43.93	43.99	101544.0
2008-09-05 19:00:00	QQQ	ETF	43.97	44.06	43.94	43.97	115855.0
2008-09-05 06:00:00	IWM	ETF	71.53	71.53	71.5	71.5	25000.0
2008-09-05 07:00:00	IWM	ETF	71.5	71.91	71.5	71.87	255108.0
2008-09-05 08:00:00	IWM	ETF	71.87	72.0	71.04	71.18	2384818.0
2008-09-05 09:00:00	IWM	ETF	71.18	71.65	71.12	71.29	14087148.0
2008-09-05 10:00:00	IWM	ETF	71.29	71.46	70.36	70.4	21702162.0
2008-09-05 11:00:00	IWM	ETF	70.4	71.09	70.14	70.89	18290103.0
2008-09-05 12:00:00	IWM	ETF	70.89	71.07	70.56	70.85	12903590.0
2008-09-05 13:00:00	IWM	ETF	70.84	71.28	70.75	71.11	10170871.0
2008-09-05 14:00:00	IWM	ETF	71.11	72.0	70.85	71.85	16780992.0
2008-09-05 15:00:00	IWM	ETF	71.85	72.11	71.44	71.7	18272099.0
2008-09-05 16:00:00	IWM	ETF	71.69	72.6	71.58	72.6	3780975.0
2008-09-05 17:00:00	IWM	ETF	72.5	72.85	72.45	72.72	214684.0
2008-09-05 18:00:00	IWM	ETF	72.6	72.82	72.42	72.43	6755.0
2008-09-05 19:00:00	IWM	ETF	72.43	72.46	72.43	72.45	1256.0
2008-09-05 06:00:00	DIA	ETF	111.69	111.69	111.56	111.56	200.0
2008-09-05 07:00:00	DIA	ETF	111.55	112.01	111.5	111.94	8663.0
2008-09-05 08:00:00	DIA	ETF	111.97	112.05	110.85	111.17	658427.0
2008-09-05 09:00:00	DIA	ETF	111.13	111.94	111.1	111.41	3860697.0

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

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