PREVIEW / etf_1hour / 2008-09-10

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-09-10.parquet
  size:    111 KB
  rows:    3,567

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-10 04:00:00	SPY	ETF	124.11	124.42	124.11	124.42	2300.0
2008-09-10 05:00:00	SPY	ETF	123.79	123.79	123.68	123.68	6200.0
2008-09-10 06:00:00	SPY	ETF	123.64	124.16	123.64	123.84	186800.0
2008-09-10 07:00:00	SPY	ETF	123.83	124.4	122.58	122.68	7450014.0
2008-09-10 08:00:00	SPY	ETF	122.67	124.13	122.47	123.9	11836774.0
2008-09-10 09:00:00	SPY	ETF	123.89	124.19	123.18	123.9	37423236.0
2008-09-10 10:00:00	SPY	ETF	123.9	124.1	122.84	122.99	50180919.0
2008-09-10 11:00:00	SPY	ETF	123.0	123.79	122.55	123.46	43901440.0
2008-09-10 12:00:00	SPY	ETF	123.46	124.01	123.35	123.62	26921058.0
2008-09-10 13:00:00	SPY	ETF	123.62	124.08	123.4	123.58	19981291.0
2008-09-10 14:00:00	SPY	ETF	123.58	124.825	123.52	124.29	42430750.0
2008-09-10 15:00:00	SPY	ETF	124.29	124.9	123.43	123.6	48274877.0
2008-09-10 16:00:00	SPY	ETF	123.6183	123.87	123.53	123.84	5529654.0
2008-09-10 17:00:00	SPY	ETF	123.83	123.86	123.78	123.84	244153.0
2008-09-10 18:00:00	SPY	ETF	123.83	123.89	123.8	123.86	56581.0
2008-09-10 19:00:00	SPY	ETF	123.86	123.86	123.54	123.54	28492.0
2008-09-10 04:00:00	QQQ	ETF	42.88	43.0	42.88	43.0	3500.0
2008-09-10 05:00:00	QQQ	ETF	43.0	43.0	42.88	42.88	2400.0
2008-09-10 06:00:00	QQQ	ETF	42.85	42.96	42.85	42.85	160100.0
2008-09-10 07:00:00	QQQ	ETF	42.86	42.94	42.67	42.69	1954917.0
2008-09-10 08:00:00	QQQ	ETF	42.69	42.95	42.68	42.94	5255002.0
2008-09-10 09:00:00	QQQ	ETF	42.95	42.95	42.54	42.7	22879988.0
2008-09-10 10:00:00	QQQ	ETF	42.69	42.89	42.52	42.56	23450541.0
2008-09-10 11:00:00	QQQ	ETF	42.56	42.89	42.45	42.79	19673147.0
2008-09-10 12:00:00	QQQ	ETF	42.8	43.02	42.75	42.9	15589330.0
2008-09-10 13:00:00	QQQ	ETF	42.91	42.97	42.69	42.7	11388525.0
2008-09-10 14:00:00	QQQ	ETF	42.71	43.18	42.69	42.97	20542489.0
2008-09-10 15:00:00	QQQ	ETF	42.98	43.16	42.72	42.738	23481513.0
2008-09-10 16:00:00	QQQ	ETF	42.73	42.91	42.64	42.74	13478525.0
2008-09-10 17:00:00	QQQ	ETF	42.74	42.77	42.71	42.72	48691.0
2008-09-10 18:00:00	QQQ	ETF	42.73	42.74	42.72	42.74	1300.0
2008-09-10 19:00:00	QQQ	ETF	42.72	42.74	42.64	42.65	31414.0
2008-09-10 06:00:00	IWM	ETF	71.28	71.38	71.28	71.38	200.0
2008-09-10 07:00:00	IWM	ETF	71.35	71.7	70.82	70.89	870529.0
2008-09-10 08:00:00	IWM	ETF	71.54	71.54	70.84	71.54	3373463.0
2008-09-10 09:00:00	IWM	ETF	71.55	71.73	70.97	71.54	14860808.0
2008-09-10 10:00:00	IWM	ETF	71.49	71.74	70.83	70.92	18380616.0
2008-09-10 11:00:00	IWM	ETF	70.92	71.36	70.43	71.19	21009458.0
2008-09-10 12:00:00	IWM	ETF	71.2	71.66	71.06	71.41	12704119.0
2008-09-10 13:00:00	IWM	ETF	71.4	71.65	71.16	71.27	7857520.0
2008-09-10 14:00:00	IWM	ETF	71.28	72.18	71.26	71.8	15826679.0
2008-09-10 15:00:00	IWM	ETF	71.8	72.07	70.55	71.42	23516649.0
2008-09-10 16:00:00	IWM	ETF	71.43	71.58	70.65	71.57	2737528.0
2008-09-10 17:00:00	IWM	ETF	71.61	71.63	71.53	71.63	30932.0
2008-09-10 18:00:00	IWM	ETF	71.59	71.64	71.59	71.62	24000.0
2008-09-10 04:00:00	DIA	ETF	113.01	113.01	113.01	113.01	100.0
2008-09-10 06:00:00	DIA	ETF	113.38	113.38	113.11	113.11	300.0
2008-09-10 07:00:00	DIA	ETF	113.3	113.62	112.33	112.35	40809.0
2008-09-10 08:00:00	DIA	ETF	112.39	113.09	112.1	113.03	299936.0
2008-09-10 09:00:00	DIA	ETF	113.08	113.51	112.62	113.27	3039508.0

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

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