PREVIEW / etf_1hour / 2009-09-25

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-09-25.parquet
  size:    143 KB
  rows:    4,404

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-09-25 04:00:00	SPY	ETF	105.09	105.1	105.09	105.1	590.0
2009-09-25 05:00:00	SPY	ETF	105.09	105.09	105.09	105.09	2000.0
2009-09-25 06:00:00	SPY	ETF	105.24	105.34	105.16	105.16	36600.0
2009-09-25 07:00:00	SPY	ETF	105.13	105.31	105.1	105.24	289039.0
2009-09-25 08:00:00	SPY	ETF	105.23	105.25	104.43	104.65	4347295.0
2009-09-25 09:00:00	SPY	ETF	104.65	105.28	104.55	105.01	25596687.0
2009-09-25 10:00:00	SPY	ETF	105.01	105.36	104.69	104.89	32372070.0
2009-09-25 11:00:00	SPY	ETF	104.88	105.05	104.52	104.6	23707533.0
2009-09-25 12:00:00	SPY	ETF	104.6	104.69	104.14	104.23	25192955.0
2009-09-25 13:00:00	SPY	ETF	104.24	104.72	104.09	104.67	26076544.0
2009-09-25 14:00:00	SPY	ETF	104.67	104.93	104.54	104.899	18743481.0
2009-09-25 15:00:00	SPY	ETF	104.89	104.91	104.36	104.47	28827852.0
2009-09-25 16:00:00	SPY	ETF	104.48	105.0717	104.17	104.47	7245745.0
2009-09-25 17:00:00	SPY	ETF	104.46	104.5	104.43	104.5	87445.0
2009-09-25 18:00:00	SPY	ETF	104.5	104.52	104.43	104.49	30620.0
2009-09-25 19:00:00	SPY	ETF	104.48	104.59	104.44	104.57	17267.0
2009-09-25 04:00:00	QQQ	ETF	41.86	41.93	41.86	41.93	5200.0
2009-09-25 05:00:00	QQQ	ETF	41.91	41.91	41.86	41.86	5600.0
2009-09-25 06:00:00	QQQ	ETF	41.95	41.95	41.86	41.86	6100.0
2009-09-25 07:00:00	QQQ	ETF	41.84	41.94	41.84	41.9	78300.0
2009-09-25 08:00:00	QQQ	ETF	41.91	41.92	41.65	41.78	1494212.0
2009-09-25 09:00:00	QQQ	ETF	41.79	42.09	41.75	41.96	18145039.0
2009-09-25 10:00:00	QQQ	ETF	41.96	42.06	41.8	41.87	23034595.0
2009-09-25 11:00:00	QQQ	ETF	41.87	41.93	41.75	41.78	11281257.0
2009-09-25 12:00:00	QQQ	ETF	41.762	41.78	41.6	41.6601	10943185.0
2009-09-25 13:00:00	QQQ	ETF	41.67	41.85	41.58	41.84	6833064.0
2009-09-25 14:00:00	QQQ	ETF	41.85	41.89	41.75	41.871	8046465.0
2009-09-25 15:00:00	QQQ	ETF	41.8704	41.9	41.65	41.7	12273967.0
2009-09-25 16:00:00	QQQ	ETF	41.7	42.0592	41.69	41.76	15645174.0
2009-09-25 17:00:00	QQQ	ETF	41.74	41.76	41.73	41.74	7702.0
2009-09-25 18:00:00	QQQ	ETF	41.74	41.76	41.67	41.76	109291.0
2009-09-25 19:00:00	QQQ	ETF	41.76	41.76	41.74	41.74	8290.0
2009-09-25 06:00:00	IWM	ETF	60.25	60.25	60.25	60.25	4800.0
2009-09-25 07:00:00	IWM	ETF	60.18	60.3	60.15	60.27	113298.0
2009-09-25 08:00:00	IWM	ETF	60.24	60.26	59.74	59.88	642402.0
2009-09-25 09:00:00	IWM	ETF	59.89	60.25	59.82	60.02	6204886.0
2009-09-25 10:00:00	IWM	ETF	60.01	60.34	59.8	59.95	9893730.0
2009-09-25 11:00:00	IWM	ETF	59.96	60.08	59.77	59.84	5520466.0
2009-09-25 12:00:00	IWM	ETF	59.83	59.86	59.51	59.66	6082672.0
2009-09-25 13:00:00	IWM	ETF	59.66	59.93	59.55	59.92	4069008.0
2009-09-25 14:00:00	IWM	ETF	59.91	60.01	59.73	59.95	4430982.0
2009-09-25 15:00:00	IWM	ETF	59.95	59.985	59.66	59.835	7782852.0
2009-09-25 16:00:00	IWM	ETF	59.84	59.95	59.75	59.89	2203902.0
2009-09-25 17:00:00	IWM	ETF	59.9	59.9	59.9	59.9	944.0
2009-09-25 06:00:00	DIA	ETF	97.29	97.29	97.21	97.21	6400.0
2009-09-25 07:00:00	DIA	ETF	97.2	97.2	97.2	97.2	400.0
2009-09-25 08:00:00	DIA	ETF	97.23	97.23	96.63	96.75	3319763.0
2009-09-25 09:00:00	DIA	ETF	96.75	97.29	96.71	97.07	1529311.0
2009-09-25 10:00:00	DIA	ETF	97.07	97.35	96.77	96.97	1981889.0
2009-09-25 11:00:00	DIA	ETF	96.98	97.13	96.68	96.77	1467566.0

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

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