PREVIEW / etf_1hour / 2010-10-19

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-10-19.parquet
  size:    173 KB
  rows:    5,336

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
2010-10-19 04:00:00	SPY	ETF	117.88	118.0	117.88	117.9	21067.0
2010-10-19 05:00:00	SPY	ETF	118.07	118.07	118.0	118.05	10020.0
2010-10-19 06:00:00	SPY	ETF	118.03	118.24	117.98	118.06	54200.0
2010-10-19 07:00:00	SPY	ETF	118.04	118.09	117.36	117.59	2030675.0
2010-10-19 08:00:00	SPY	ETF	117.62	117.8	117.38	117.4	6189851.0
2010-10-19 09:00:00	SPY	ETF	117.41	117.49	116.76	116.97	31445101.0
2010-10-19 10:00:00	SPY	ETF	116.97	117.72	116.87	117.5	36083030.0
2010-10-19 11:00:00	SPY	ETF	117.5	117.83	117.25	117.77	24851325.0
2010-10-19 12:00:00	SPY	ETF	117.77	117.85	117.43	117.63	12487565.0
2010-10-19 13:00:00	SPY	ETF	117.63	117.63	116.77	116.86	27023599.0
2010-10-19 14:00:00	SPY	ETF	116.87	116.88	116.2	116.58	57563459.0
2010-10-19 15:00:00	SPY	ETF	116.58	116.75	116.02	116.7065	51708787.0
2010-10-19 16:00:00	SPY	ETF	116.75	118.5588	116.295	116.77	17213948.0
2010-10-19 17:00:00	SPY	ETF	116.76	116.85	116.75	116.78	197603.0
2010-10-19 18:00:00	SPY	ETF	116.77	116.79	116.66	116.66	138872.0
2010-10-19 19:00:00	SPY	ETF	116.65	116.67	116.54	116.55	138595.0
2010-10-19 04:00:00	QQQ	ETF	50.89	50.92	50.89	50.92	5450.0
2010-10-19 05:00:00	QQQ	ETF	50.95	50.95	50.95	50.95	100.0
2010-10-19 06:00:00	QQQ	ETF	50.97	51.05	50.97	50.97	6100.0
2010-10-19 07:00:00	QQQ	ETF	50.99	51.0	50.78	50.86	392153.0
2010-10-19 08:00:00	QQQ	ETF	50.87	51.0	50.78	50.84	1846271.0
2010-10-19 09:00:00	QQQ	ETF	50.82	50.92	50.42	50.61	15757632.0
2010-10-19 10:00:00	QQQ	ETF	50.6	51.18	50.52	51.06	19766703.0
2010-10-19 11:00:00	QQQ	ETF	51.065	51.22	50.89	51.19	10146336.0
2010-10-19 12:00:00	QQQ	ETF	51.18	51.24	51.06	51.19	6008992.0
2010-10-19 13:00:00	QQQ	ETF	51.18	51.18	50.78	50.82	8039481.0
2010-10-19 14:00:00	QQQ	ETF	50.82	50.8299	50.52	50.72	17087458.0
2010-10-19 15:00:00	QQQ	ETF	50.73	50.84	50.43	50.83	18978569.0
2010-10-19 16:00:00	QQQ	ETF	50.83	50.91	50.6791	50.77	3339027.0
2010-10-19 17:00:00	QQQ	ETF	50.78	50.8	50.77	50.8	632423.0
2010-10-19 18:00:00	QQQ	ETF	50.79	50.8	50.77	50.77	46397.0
2010-10-19 19:00:00	QQQ	ETF	50.76	50.77	50.68	50.68	33205.0
2010-10-19 06:00:00	IWM	ETF	70.65	70.75	70.65	70.75	200.0
2010-10-19 07:00:00	IWM	ETF	70.39	70.5	70.28	70.28	49699.0
2010-10-19 08:00:00	IWM	ETF	70.45	70.47	70.19	70.27	1187082.0
2010-10-19 09:00:00	IWM	ETF	70.24	70.24	69.68	69.84	9848822.0
2010-10-19 10:00:00	IWM	ETF	69.84	70.72	69.73	70.49	8035944.0
2010-10-19 11:00:00	IWM	ETF	70.49	70.76	70.34	70.69	5951242.0
2010-10-19 12:00:00	IWM	ETF	70.7	70.76	70.33	70.52	2220626.0
2010-10-19 13:00:00	IWM	ETF	70.52	70.53	69.72	69.8	4375139.0
2010-10-19 14:00:00	IWM	ETF	69.8	69.8	69.28	69.3599	12934926.0
2010-10-19 15:00:00	IWM	ETF	69.35	69.52	68.95	69.49	15077652.0
2010-10-19 16:00:00	IWM	ETF	69.49	71.0197	69.1199	69.5	3496510.0
2010-10-19 17:00:00	IWM	ETF	69.54	69.57	69.54	69.56	19652.0
2010-10-19 18:00:00	IWM	ETF	69.52	69.52	69.51	69.51	900.0
2010-10-19 19:00:00	IWM	ETF	69.51	69.51	69.41	69.41	1900.0
2010-10-19 06:00:00	DIA	ETF	110.93	111.01	110.93	111.01	1100.0
2010-10-19 07:00:00	DIA	ETF	110.75	110.75	110.55	110.63	62100.0
2010-10-19 08:00:00	DIA	ETF	110.69	110.7	110.45	110.48	160750.0
2010-10-19 09:00:00	DIA	ETF	110.49	110.49	109.78	110.0	1123126.0

> showing 50 of 5,336 rows — these rows as CSV

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