PREVIEW / etf_1hour / 2008-04-11

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-04-11.parquet
  size:    99 KB
  rows:    3,341

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-04-11 04:00:00	SPY	ETF	136.52	136.52	136.52	136.52	1000.0
2008-04-11 05:00:00	SPY	ETF	136.43	136.45	136.36	136.41	5500.0
2008-04-11 06:00:00	SPY	ETF	136.43	136.49	135.2	135.28	725100.0
2008-04-11 07:00:00	SPY	ETF	135.35	135.35	134.65	134.96	2486700.0
2008-04-11 08:00:00	SPY	ETF	134.96	135.73	134.36	134.55	7878006.0
2008-04-11 09:00:00	SPY	ETF	134.56	134.7	134.29	134.4	29174018.0
2008-04-11 10:00:00	SPY	ETF	134.41	135.12	134.151	134.74	41216956.0
2008-04-11 11:00:00	SPY	ETF	134.748	134.77	134.37	134.63	22009866.0
2008-04-11 12:00:00	SPY	ETF	134.63	134.65	133.91	134.16	21206310.0
2008-04-11 13:00:00	SPY	ETF	134.15	134.28	133.65	133.86	20228129.0
2008-04-11 14:00:00	SPY	ETF	133.87	133.9	133.36	133.6	22584380.0
2008-04-11 15:00:00	SPY	ETF	133.6	135.9837	133.01	133.28	39732195.0
2008-04-11 16:00:00	SPY	ETF	133.35	133.4	133.15	133.22	12617300.0
2008-04-11 17:00:00	SPY	ETF	133.22	133.3	133.17	133.21	23800.0
2008-04-11 18:00:00	SPY	ETF	133.29	133.9	133.22	133.28	71500.0
2008-04-11 19:00:00	SPY	ETF	133.25	133.31	133.22	133.31	10600.0
2008-04-11 04:00:00	QQQ	ETF	45.78	45.78	45.78	45.78	200.0
2008-04-11 06:00:00	QQQ	ETF	45.8	45.8	45.29	45.29	8268.0
2008-04-11 07:00:00	QQQ	ETF	45.37	45.38	45.19	45.38	781764.0
2008-04-11 08:00:00	QQQ	ETF	45.37	45.4	44.95	45.0	3736147.0
2008-04-11 09:00:00	QQQ	ETF	45.01	45.1	44.94	44.97	16982133.0
2008-04-11 10:00:00	QQQ	ETF	44.96	45.02	44.75	44.89	21901286.0
2008-04-11 11:00:00	QQQ	ETF	44.89	44.94	44.78	44.91	10905687.0
2008-04-11 12:00:00	QQQ	ETF	44.91	44.92	44.6	44.69	11587772.0
2008-04-11 13:00:00	QQQ	ETF	44.6801	44.7395	44.4	44.4799	12240596.0
2008-04-11 14:00:00	QQQ	ETF	44.48	44.5	44.24	44.32	13263063.0
2008-04-11 15:00:00	QQQ	ETF	44.32	44.35	44.12	44.28	22167180.0
2008-04-11 16:00:00	QQQ	ETF	44.279	45.572	44.1302	44.27	6165959.0
2008-04-11 17:00:00	QQQ	ETF	44.28	44.28	44.25	44.25	18550.0
2008-04-11 18:00:00	QQQ	ETF	44.26	44.29	44.26	44.29	32756.0
2008-04-11 19:00:00	QQQ	ETF	44.26	44.28	44.23	44.24	15644.0
2008-04-11 06:00:00	IWM	ETF	70.7	70.7	70.2	70.2	14900.0
2008-04-11 07:00:00	IWM	ETF	70.17	70.17	69.98	69.98	249300.0
2008-04-11 08:00:00	IWM	ETF	70.02	70.05	69.65	69.7	405339.0
2008-04-11 09:00:00	IWM	ETF	69.74	69.78	69.41	69.55	7255217.0
2008-04-11 10:00:00	IWM	ETF	69.56	69.74	69.24	69.63	12260884.0
2008-04-11 11:00:00	IWM	ETF	69.62	69.77	69.5	69.65	10306631.0
2008-04-11 12:00:00	IWM	ETF	69.66	69.66	69.22	69.4	5596166.0
2008-04-11 13:00:00	IWM	ETF	69.39	69.45	68.95	69.01	6948858.0
2008-04-11 14:00:00	IWM	ETF	69.01	69.05	68.77	68.88	9504595.0
2008-04-11 15:00:00	IWM	ETF	68.88	68.9	68.42	68.73	17093075.0
2008-04-11 16:00:00	IWM	ETF	68.73	70.54	68.58	68.69	8520200.0
2008-04-11 17:00:00	IWM	ETF	68.71	68.77	68.64	68.74	8800.0
2008-04-11 19:00:00	IWM	ETF	68.64	68.72	68.64	68.72	3500.0
2008-04-11 07:00:00	DIA	ETF	125.28	125.33	124.93	125.13	24300.0
2008-04-11 08:00:00	DIA	ETF	125.13	125.13	124.57	124.7	374998.0
2008-04-11 09:00:00	DIA	ETF	124.71	124.78	124.33	124.49	2931752.0
2008-04-11 10:00:00	DIA	ETF	124.49	124.64	124.04	124.51	3764246.0
2008-04-11 11:00:00	DIA	ETF	124.49	124.59	124.21	124.5	1223780.0
2008-04-11 12:00:00	DIA	ETF	124.5	124.52	123.93	124.09	1415597.0

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

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