PREVIEW / etf_1hour / 2008-10-15

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-10-15.parquet
  size:    115 KB
  rows:    3,762

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-15 04:00:00	SPY	ETF	99.0	99.16	98.5	98.5	400.0
2008-10-15 05:00:00	SPY	ETF	98.77	98.85	98.0	98.23	11850.0
2008-10-15 06:00:00	SPY	ETF	99.0	99.86	98.7	99.45	97700.0
2008-10-15 07:00:00	SPY	ETF	99.43	99.61	98.21	98.21	904216.0
2008-10-15 08:00:00	SPY	ETF	98.22	99.526	96.86	97.35	7636893.0
2008-10-15 09:00:00	SPY	ETF	97.36	97.8	96.32	97.0	52395538.0
2008-10-15 10:00:00	SPY	ETF	97.02	97.02	95.05	95.13	74692670.0
2008-10-15 11:00:00	SPY	ETF	95.087	95.84	94.83	95.55	53878470.0
2008-10-15 12:00:00	SPY	ETF	95.54	95.98	94.56	95.568	37959089.0
2008-10-15 13:00:00	SPY	ETF	95.57	95.6475	93.02	93.21	57316774.0
2008-10-15 14:00:00	SPY	ETF	93.22	94.32	92.5	93.49	66811588.0
2008-10-15 15:00:00	SPY	ETF	93.48	94.75	90.5	90.71	103008151.0
2008-10-15 16:00:00	SPY	ETF	90.72	99.824	89.68	89.92	25072292.0
2008-10-15 17:00:00	SPY	ETF	89.94	99.824	88.55	88.74	2479511.0
2008-10-15 18:00:00	SPY	ETF	88.78	89.42	88.34	89.07	614442.0
2008-10-15 19:00:00	SPY	ETF	89.07	89.26	88.75	88.9	87337.0
2008-10-15 04:00:00	QQQ	ETF	33.61	33.61	33.4	33.4	200.0
2008-10-15 05:00:00	QQQ	ETF	33.6	33.6	33.4	33.45	3200.0
2008-10-15 06:00:00	QQQ	ETF	33.5	33.78	33.5	33.78	11200.0
2008-10-15 07:00:00	QQQ	ETF	33.7	33.7	33.3	33.4	506458.0
2008-10-15 08:00:00	QQQ	ETF	33.37	33.48	32.86	33.05	3145603.0
2008-10-15 09:00:00	QQQ	ETF	33.06	33.35	32.7	33.14	43507359.0
2008-10-15 10:00:00	QQQ	ETF	33.14	33.18	32.42	32.49	46613882.0
2008-10-15 11:00:00	QQQ	ETF	32.48	32.69	32.36	32.532	28509125.0
2008-10-15 12:00:00	QQQ	ETF	32.53	32.7	32.2	32.39	23742707.0
2008-10-15 13:00:00	QQQ	ETF	32.407	32.407	31.47	31.5505	40188105.0
2008-10-15 14:00:00	QQQ	ETF	31.56	32.09	31.27	31.69	42317187.0
2008-10-15 15:00:00	QQQ	ETF	31.69	32.05	30.54	30.6099	60011177.0
2008-10-15 16:00:00	QQQ	ETF	30.6	33.5491	30.17	30.24	13763979.0
2008-10-15 17:00:00	QQQ	ETF	30.26	30.56	29.95	30.07	4359754.0
2008-10-15 18:00:00	QQQ	ETF	30.06	30.18	29.95	30.1	222832.0
2008-10-15 19:00:00	QQQ	ETF	30.09	30.12	30.01	30.06	100775.0
2008-10-15 06:00:00	IWM	ETF	55.21	55.21	55.21	55.21	100.0
2008-10-15 07:00:00	IWM	ETF	55.28	55.34	54.71	54.74	168800.0
2008-10-15 08:00:00	IWM	ETF	54.74	55.01	54.12	54.45	1628269.0
2008-10-15 09:00:00	IWM	ETF	54.45	55.38	53.52	53.88	16355837.0
2008-10-15 10:00:00	IWM	ETF	53.88	53.91	52.77	52.87	17566450.0
2008-10-15 11:00:00	IWM	ETF	52.88	53.46	52.84	53.13	9605711.0
2008-10-15 12:00:00	IWM	ETF	53.13	53.36	52.54	52.91	9062228.0
2008-10-15 13:00:00	IWM	ETF	52.91	52.91	51.79	51.85	9154832.0
2008-10-15 14:00:00	IWM	ETF	51.85	52.73	51.35	52.17	13888415.0
2008-10-15 15:00:00	IWM	ETF	52.16	52.78	50.05	50.17	22962849.0
2008-10-15 16:00:00	IWM	ETF	50.18	54.0	49.5	49.6	6470760.0
2008-10-15 17:00:00	IWM	ETF	49.71	49.81	49.3	49.6	120440.0
2008-10-15 18:00:00	IWM	ETF	49.45	49.6	49.45	49.6	1600.0
2008-10-15 19:00:00	IWM	ETF	49.5	49.55	49.5	49.55	700.0
2008-10-15 07:00:00	DIA	ETF	93.33	93.33	92.14	92.14	16100.0
2008-10-15 08:00:00	DIA	ETF	92.14	92.53	91.14	91.6	105429.0
2008-10-15 09:00:00	DIA	ETF	91.41	92.16	90.44	91.03	4588906.0
2008-10-15 10:00:00	DIA	ETF	91.03	91.04	89.42	89.49	5978936.0

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

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