PREVIEW / etf_1hour / 2009-08-24

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-08-24.parquet
  size:    145 KB
  rows:    4,430

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
2009-08-24 04:00:00	SPY	ETF	103.45	103.55	103.34	103.36	5250.0
2009-08-24 05:00:00	SPY	ETF	103.26	103.35	103.25	103.33	4100.0
2009-08-24 06:00:00	SPY	ETF	103.3	103.36	103.15	103.2	24300.0
2009-08-24 07:00:00	SPY	ETF	103.2	103.36	103.1	103.21	430231.0
2009-08-24 08:00:00	SPY	ETF	103.58	103.58	103.2	103.37	1129411.0
2009-08-24 09:00:00	SPY	ETF	103.38	103.71	103.21	103.57	30443574.0
2009-08-24 10:00:00	SPY	ETF	103.56	103.89	103.54	103.85	23200429.0
2009-08-24 11:00:00	SPY	ETF	103.84	103.95	103.6	103.6	14922024.0
2009-08-24 12:00:00	SPY	ETF	103.61	103.69	103.45	103.45	12069330.0
2009-08-24 13:00:00	SPY	ETF	103.47	103.47	102.78	103.048	28641285.0
2009-08-24 14:00:00	SPY	ETF	103.04	103.21	102.92	102.98	17909396.0
2009-08-24 15:00:00	SPY	ETF	102.99	103.75	102.59	102.94	45298461.0
2009-08-24 16:00:00	SPY	ETF	102.94	103.5	102.82	102.84	13373327.0
2009-08-24 17:00:00	SPY	ETF	102.86	102.87	102.75	102.82	204932.0
2009-08-24 18:00:00	SPY	ETF	102.82	102.96	102.74	102.77	141231.0
2009-08-24 19:00:00	SPY	ETF	102.73	102.76	102.63	102.69	51376.0
2009-08-24 04:00:00	QQQ	ETF	40.47	40.47	40.47	40.47	500.0
2009-08-24 05:00:00	QQQ	ETF	40.34	40.38	40.34	40.38	7200.0
2009-08-24 06:00:00	QQQ	ETF	40.36	40.36	40.3	40.3	6488.0
2009-08-24 07:00:00	QQQ	ETF	40.28	40.34	40.26	40.32	224949.0
2009-08-24 08:00:00	QQQ	ETF	40.3	40.49	40.28	40.35	1310565.0
2009-08-24 09:00:00	QQQ	ETF	40.35	40.5	40.27	40.4195	24194465.0
2009-08-24 10:00:00	QQQ	ETF	40.42	40.57	40.41	40.54	12265250.0
2009-08-24 11:00:00	QQQ	ETF	40.54	40.57	40.4	40.4	10524357.0
2009-08-24 12:00:00	QQQ	ETF	40.4	40.45	40.36	40.37	6288121.0
2009-08-24 13:00:00	QQQ	ETF	40.37	40.37	40.15	40.28	14094890.0
2009-08-24 14:00:00	QQQ	ETF	40.28	40.37	40.25	40.28	5007591.0
2009-08-24 15:00:00	QQQ	ETF	40.27	40.33	40.1	40.24	25109163.0
2009-08-24 16:00:00	QQQ	ETF	40.25	40.4461	40.16	40.2	3331425.0
2009-08-24 17:00:00	QQQ	ETF	40.2	40.21	40.16	40.16	12900.0
2009-08-24 18:00:00	QQQ	ETF	40.17	40.24	40.14	40.14	75894.0
2009-08-24 19:00:00	QQQ	ETF	40.16	40.16	40.12	40.14	10540.0
2009-08-24 07:00:00	IWM	ETF	58.33	58.42	58.27	58.35	20114.0
2009-08-24 08:00:00	IWM	ETF	58.35	58.41	58.32	58.4	228998.0
2009-08-24 09:00:00	IWM	ETF	58.39	58.77	58.24	58.49	5002433.0
2009-08-24 10:00:00	IWM	ETF	58.49	58.71	58.44	58.65	5881326.0
2009-08-24 11:00:00	IWM	ETF	58.66	58.72	58.46	58.48	2758947.0
2009-08-24 12:00:00	IWM	ETF	58.47	58.54	58.39	58.42	3112474.0
2009-08-24 13:00:00	IWM	ETF	58.42	58.42	57.94	58.15	4555938.0
2009-08-24 14:00:00	IWM	ETF	58.15	58.29	58.1	58.16	1779796.0
2009-08-24 15:00:00	IWM	ETF	58.15	58.19	57.84	58.07	6565365.0
2009-08-24 16:00:00	IWM	ETF	58.08	58.25	58.06	58.12	3306914.0
2009-08-24 17:00:00	IWM	ETF	58.11	58.11	58.08	58.11	2212.0
2009-08-24 18:00:00	IWM	ETF	58.11	58.11	58.01	58.01	4276.0
2009-08-24 19:00:00	IWM	ETF	58.01	58.03	57.92	57.92	3700.0
2009-08-24 04:00:00	DIA	ETF	95.47	95.47	95.47	95.47	122.0
2009-08-24 07:00:00	DIA	ETF	95.23	95.42	95.23	95.37	8115.0
2009-08-24 08:00:00	DIA	ETF	95.34	95.4	95.26	95.38	42555.0
2009-08-24 09:00:00	DIA	ETF	95.37	95.69	95.28	95.58	1801586.0
2009-08-24 10:00:00	DIA	ETF	95.58	95.8209	95.56	95.8165	1903950.0

> showing 50 of 4,430 rows — these rows as CSV

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