PREVIEW / etf_1hour / 2008-09-25

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-09-25.parquet
  size:    113 KB
  rows:    3,646

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-25 04:00:00	SPY	ETF	118.95	119.24	118.95	119.24	200.0
2008-09-25 05:00:00	SPY	ETF	119.71	119.77	119.65	119.65	3600.0
2008-09-25 06:00:00	SPY	ETF	119.76	119.78	119.11	119.11	196190.0
2008-09-25 07:00:00	SPY	ETF	119.14	119.23	118.6	119.2	1440431.0
2008-09-25 08:00:00	SPY	ETF	119.17	120.37	118.84	119.59	12306872.0
2008-09-25 09:00:00	SPY	ETF	119.59	120.52	119.07	120.35	32983399.0
2008-09-25 10:00:00	SPY	ETF	120.38	121.17	119.96	120.36	51743572.0
2008-09-25 11:00:00	SPY	ETF	120.36	121.25	120.26	120.74	33597792.0
2008-09-25 12:00:00	SPY	ETF	120.74	121.62	120.68	121.38	25420287.0
2008-09-25 13:00:00	SPY	ETF	121.38	121.91	121.1	121.529	38138992.0
2008-09-25 14:00:00	SPY	ETF	121.53	121.6	118.4369	121.09	47247031.0
2008-09-25 15:00:00	SPY	ETF	121.09	121.71	120.23	121.01	49101409.0
2008-09-25 16:00:00	SPY	ETF	121.01	121.27	118.4369	120.47	30828334.0
2008-09-25 17:00:00	SPY	ETF	120.47	120.87	120.09	120.42	2171651.0
2008-09-25 18:00:00	SPY	ETF	120.5	120.81	120.17	120.45	1283025.0
2008-09-25 19:00:00	SPY	ETF	120.36	120.52	119.55	119.67	364787.0
2008-09-25 04:00:00	QQQ	ETF	41.2	41.28	41.2	41.28	1500.0
2008-09-25 05:00:00	QQQ	ETF	41.43	41.5	41.43	41.45	2000.0
2008-09-25 06:00:00	QQQ	ETF	41.45	41.5	41.18	41.24	80800.0
2008-09-25 07:00:00	QQQ	ETF	41.25	41.25	40.98	41.15	519021.0
2008-09-25 08:00:00	QQQ	ETF	41.14	41.52	41.12	41.32	4200834.0
2008-09-25 09:00:00	QQQ	ETF	41.32	41.45	41.03	41.31	16228355.0
2008-09-25 10:00:00	QQQ	ETF	41.31	41.82	41.29	41.48	21851618.0
2008-09-25 11:00:00	QQQ	ETF	41.49	41.72	41.43	41.55	13768305.0
2008-09-25 12:00:00	QQQ	ETF	41.56	41.82	41.49	41.77	9378765.0
2008-09-25 13:00:00	QQQ	ETF	41.77	42.02	41.67	41.852	15813252.0
2008-09-25 14:00:00	QQQ	ETF	41.86	41.87	41.36	41.55	21787189.0
2008-09-25 15:00:00	QQQ	ETF	41.55	41.83	41.35	41.48	30506849.0
2008-09-25 16:00:00	QQQ	ETF	41.48	41.57	40.8452	41.0	9502407.0
2008-09-25 17:00:00	QQQ	ETF	40.99	41.1	40.95	40.98	795979.0
2008-09-25 18:00:00	QQQ	ETF	40.99	41.03	40.93	40.99	220961.0
2008-09-25 19:00:00	QQQ	ETF	41.0	41.0	40.73	40.74	154201.0
2008-09-25 07:00:00	IWM	ETF	70.0	70.1	69.82	69.98	17269.0
2008-09-25 08:00:00	IWM	ETF	70.01	74.75	70.01	70.23	795916.0
2008-09-25 09:00:00	IWM	ETF	70.21	70.7	69.85	70.56	13524919.0
2008-09-25 10:00:00	IWM	ETF	70.54	70.85	70.34	70.59	21278985.0
2008-09-25 11:00:00	IWM	ETF	70.6	70.8	70.4	70.67	12937902.0
2008-09-25 12:00:00	IWM	ETF	70.65	71.08	70.59	71.0	10791796.0
2008-09-25 13:00:00	IWM	ETF	71.0	71.26	70.71	71.0	13164670.0
2008-09-25 14:00:00	IWM	ETF	71.0	71.02	70.24	70.62	16337203.0
2008-09-25 15:00:00	IWM	ETF	70.62	70.82	69.95	70.43	18045181.0
2008-09-25 16:00:00	IWM	ETF	70.41	70.68	69.59	70.33	4185415.0
2008-09-25 17:00:00	IWM	ETF	70.1	70.4	69.59	70.3	1816929.0
2008-09-25 19:00:00	IWM	ETF	70.35	70.35	69.6	69.6	3694.0
2008-09-25 05:00:00	DIA	ETF	108.41	108.66	108.41	108.66	200.0
2008-09-25 07:00:00	DIA	ETF	108.88	108.88	108.38	108.63	6600.0
2008-09-25 08:00:00	DIA	ETF	108.7	109.59	108.7	109.03	182530.0
2008-09-25 09:00:00	DIA	ETF	109.03	109.9	108.71	109.82	3334911.0
2008-09-25 10:00:00	DIA	ETF	109.82	110.74	109.54	110.1	5182785.0
2008-09-25 11:00:00	DIA	ETF	110.12	110.7	109.97	110.35	3560303.0

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

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