PREVIEW / etf_1hour / 2008-10-20

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-10-20.parquet
  size:    110 KB
  rows:    3,640

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-10-20 04:00:00	SPY	ETF	95.85	96.0	95.58	96.0	8800.0
2008-10-20 05:00:00	SPY	ETF	96.0	96.2	95.44	95.44	29400.0
2008-10-20 06:00:00	SPY	ETF	95.61	96.1	95.4	95.85	95526.0
2008-10-20 07:00:00	SPY	ETF	95.85	95.85	94.4	94.9	1820676.0
2008-10-20 08:00:00	SPY	ETF	94.89	95.86	94.76	95.26	3192255.0
2008-10-20 09:00:00	SPY	ETF	95.26	96.45	94.77	96.31	41830581.0
2008-10-20 10:00:00	SPY	ETF	96.34	97.04	95.12	95.54	52452123.0
2008-10-20 11:00:00	SPY	ETF	95.54	96.27	94.35	96.0	36679082.0
2008-10-20 12:00:00	SPY	ETF	96.0	96.57	95.67	96.0	26513755.0
2008-10-20 13:00:00	SPY	ETF	95.99	96.81	95.54	96.46	31386393.0
2008-10-20 14:00:00	SPY	ETF	96.45	97.18	96.05	96.94	39407522.0
2008-10-20 15:00:00	SPY	ETF	96.94	98.55	95.1	98.47	64201100.0
2008-10-20 16:00:00	SPY	ETF	98.47	99.24	94.0	98.62	17099973.0
2008-10-20 17:00:00	SPY	ETF	98.65	98.81	98.6	98.62	447378.0
2008-10-20 18:00:00	SPY	ETF	98.62	98.8	98.6	98.61	94340.0
2008-10-20 19:00:00	SPY	ETF	98.62	98.74	98.49	98.69	124228.0
2008-10-20 04:00:00	QQQ	ETF	32.89	33.01	32.89	33.01	600.0
2008-10-20 05:00:00	QQQ	ETF	33.08	33.2	33.03	33.03	1300.0
2008-10-20 06:00:00	QQQ	ETF	32.91	33.0	32.9	33.0	600.0
2008-10-20 07:00:00	QQQ	ETF	33.08	33.08	32.6	32.74	188585.0
2008-10-20 08:00:00	QQQ	ETF	32.69	32.97	32.69	32.79	416221.0
2008-10-20 09:00:00	QQQ	ETF	32.79	32.87	32.34	32.74	29333973.0
2008-10-20 10:00:00	QQQ	ETF	32.74	32.95	32.0	32.17	38188883.0
2008-10-20 11:00:00	QQQ	ETF	32.17	32.49	31.7	32.37	35596906.0
2008-10-20 12:00:00	QQQ	ETF	32.38	32.63	32.08	32.32	20571192.0
2008-10-20 13:00:00	QQQ	ETF	32.32	32.7	32.17	32.56	25166215.0
2008-10-20 14:00:00	QQQ	ETF	32.57	32.88	32.41	32.74	21082043.0
2008-10-20 15:00:00	QQQ	ETF	32.72	33.26	32.08	33.25	40276385.0
2008-10-20 16:00:00	QQQ	ETF	33.25	33.44	31.87	33.15	8828978.0
2008-10-20 17:00:00	QQQ	ETF	33.15	33.22	32.2482	33.22	2141950.0
2008-10-20 18:00:00	QQQ	ETF	33.2	33.25	33.15	33.15	151108.0
2008-10-20 19:00:00	QQQ	ETF	33.15	33.23	33.15	33.22	58900.0
2008-10-20 05:00:00	IWM	ETF	53.01	53.01	53.01	53.01	200.0
2008-10-20 07:00:00	IWM	ETF	53.25	53.25	52.99	53.1	9298.0
2008-10-20 08:00:00	IWM	ETF	53.1	53.7	53.07	53.07	158567.0
2008-10-20 09:00:00	IWM	ETF	53.11	53.61	52.86	53.49	11199266.0
2008-10-20 10:00:00	IWM	ETF	53.5	54.0	52.96	53.23	11190677.0
2008-10-20 11:00:00	IWM	ETF	53.23	53.5	52.46	53.28	9032976.0
2008-10-20 12:00:00	IWM	ETF	53.28	53.56	52.85	53.04	6325701.0
2008-10-20 13:00:00	IWM	ETF	53.02	53.76	52.73	53.41	11366742.0
2008-10-20 14:00:00	IWM	ETF	53.41	54.06	53.18	53.69	10136507.0
2008-10-20 15:00:00	IWM	ETF	53.68	54.71	53.37	54.69	16407064.0
2008-10-20 16:00:00	IWM	ETF	54.7	55.01	53.8	54.83	3365551.0
2008-10-20 17:00:00	IWM	ETF	54.8	54.8	54.8	54.8	181000.0
2008-10-20 18:00:00	IWM	ETF	55.15	55.15	54.85	54.85	200.0
2008-10-20 19:00:00	IWM	ETF	54.59	54.59	54.59	54.59	400.0
2008-10-20 07:00:00	DIA	ETF	89.3	89.3	88.85	88.98	4480.0
2008-10-20 08:00:00	DIA	ETF	89.04	89.69	89.0	89.38	82704.0
2008-10-20 09:00:00	DIA	ETF	89.32	90.39	88.87	90.32	5480465.0
2008-10-20 10:00:00	DIA	ETF	90.34	91.0	89.48	89.89	7124509.0

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

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