PREVIEW / etf_1hour / 2008-09-09

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-09-09.parquet
  size:    114 KB
  rows:    3,672

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-09 04:00:00	SPY	ETF	127.58	127.58	127.5	127.5	300.0
2008-09-09 05:00:00	SPY	ETF	127.44	127.44	127.44	127.44	3000.0
2008-09-09 06:00:00	SPY	ETF	127.68	127.75	127.49	127.54	182000.0
2008-09-09 07:00:00	SPY	ETF	127.51	127.92	127.51	127.76	1039514.0
2008-09-09 08:00:00	SPY	ETF	127.77	127.82	126.72	127.09	5330446.0
2008-09-09 09:00:00	SPY	ETF	127.09	127.32	126.28	127.13	43927663.0
2008-09-09 10:00:00	SPY	ETF	127.23	127.36	125.25	125.43	67717779.0
2008-09-09 11:00:00	SPY	ETF	125.42	125.87	124.99	125.3501	42962032.0
2008-09-09 12:00:00	SPY	ETF	125.36	125.81	125.09	125.49	26141113.0
2008-09-09 13:00:00	SPY	ETF	125.5	125.87	124.65	124.8	40292735.0
2008-09-09 14:00:00	SPY	ETF	124.79	124.91	123.91	124.02	49544111.0
2008-09-09 15:00:00	SPY	ETF	124.0225	124.3	122.92	122.94	70226819.0
2008-09-09 16:00:00	SPY	ETF	122.9	127.2127	122.8	122.99	16498949.0
2008-09-09 17:00:00	SPY	ETF	122.99	127.2127	122.8	123.03	5095900.0
2008-09-09 18:00:00	SPY	ETF	123.15	123.39	123.11	123.39	122593.0
2008-09-09 19:00:00	SPY	ETF	123.39	123.45	123.26	123.29	251522.0
2008-09-09 04:00:00	QQQ	ETF	43.44	43.45	43.44	43.45	500.0
2008-09-09 05:00:00	QQQ	ETF	43.5	43.56	43.5	43.54	3800.0
2008-09-09 06:00:00	QQQ	ETF	43.6	43.65	43.6	43.6	76100.0
2008-09-09 07:00:00	QQQ	ETF	43.57	43.72	43.57	43.6	552807.0
2008-09-09 08:00:00	QQQ	ETF	43.6	43.64	43.36	43.37	2185829.0
2008-09-09 09:00:00	QQQ	ETF	43.37	43.79	43.29	43.71	29203045.0
2008-09-09 10:00:00	QQQ	ETF	43.71	43.72	43.14	43.2201	33654149.0
2008-09-09 11:00:00	QQQ	ETF	43.23	43.4	43.0	43.1605	22964637.0
2008-09-09 12:00:00	QQQ	ETF	43.16	43.29	42.98	43.18	16630938.0
2008-09-09 13:00:00	QQQ	ETF	43.17	43.42	42.8	42.85	30671663.0
2008-09-09 14:00:00	QQQ	ETF	42.85	42.92	42.57	42.65	25962460.0
2008-09-09 15:00:00	QQQ	ETF	42.65	42.75	42.36	42.38	35434100.0
2008-09-09 16:00:00	QQQ	ETF	42.37	43.22	42.32	42.55	9122903.0
2008-09-09 17:00:00	QQQ	ETF	42.56	43.3792	42.54	42.56	4264572.0
2008-09-09 18:00:00	QQQ	ETF	42.6	42.69	42.6	42.68	55459.0
2008-09-09 19:00:00	QQQ	ETF	42.7	42.71	42.65	42.65	48011.0
2008-09-09 05:00:00	IWM	ETF	73.58	73.58	73.5	73.5	50000.0
2008-09-09 06:00:00	IWM	ETF	73.78	73.78	73.75	73.75	25000.0
2008-09-09 07:00:00	IWM	ETF	73.7	73.89	73.7	73.75	190683.0
2008-09-09 08:00:00	IWM	ETF	73.07	73.76	73.07	73.26	366637.0
2008-09-09 09:00:00	IWM	ETF	73.26	73.85	72.77	73.75	19565973.0
2008-09-09 10:00:00	IWM	ETF	73.75	73.75	72.45	72.59	20949034.0
2008-09-09 11:00:00	IWM	ETF	72.58	72.85	72.0	72.4	12203792.0
2008-09-09 12:00:00	IWM	ETF	72.4	72.63	72.18	72.32	9532691.0
2008-09-09 13:00:00	IWM	ETF	72.31	72.54	71.95	71.98	8621322.0
2008-09-09 14:00:00	IWM	ETF	71.98	72.23	71.2	71.36	17394987.0
2008-09-09 15:00:00	IWM	ETF	71.36	71.53	70.56	70.58	31930938.0
2008-09-09 16:00:00	IWM	ETF	70.58	72.13	70.56	70.88	6114152.0
2008-09-09 17:00:00	IWM	ETF	70.97	71.05	70.57	70.88	2333950.0
2008-09-09 18:00:00	IWM	ETF	71.0	71.17	70.98	71.17	115138.0
2008-09-09 19:00:00	IWM	ETF	71.18	71.2	71.07	71.07	13553.0
2008-09-09 06:00:00	DIA	ETF	115.58	115.58	115.58	115.58	100.0
2008-09-09 07:00:00	DIA	ETF	115.73	115.73	115.61	115.69	6335.0
2008-09-09 08:00:00	DIA	ETF	115.69	115.7	115.19	115.2	88372.0

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

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