PREVIEW / etf_1hour / 2009-09-04

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-09-04.parquet
  size:    138 KB
  rows:    4,256

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-04 04:00:00	SPY	ETF	100.94	101.08	100.94	101.08	2400.0
2009-09-04 05:00:00	SPY	ETF	101.1	101.16	101.0	101.0	2390.0
2009-09-04 06:00:00	SPY	ETF	100.9	100.91	100.9	100.91	11050.0
2009-09-04 07:00:00	SPY	ETF	100.93	101.12	100.93	101.06	405349.0
2009-09-04 08:00:00	SPY	ETF	100.41	101.43	100.41	100.85	13193411.0
2009-09-04 09:00:00	SPY	ETF	100.83	101.14	100.55	100.66	22885780.0
2009-09-04 10:00:00	SPY	ETF	100.67	101.28	100.65	101.22	18021630.0
2009-09-04 11:00:00	SPY	ETF	101.22	101.33	100.88	101.33	10368270.0
2009-09-04 12:00:00	SPY	ETF	101.34	101.84	101.31	101.8	18392656.0
2009-09-04 13:00:00	SPY	ETF	101.8	102.05	101.71	101.72	13186065.0
2009-09-04 14:00:00	SPY	ETF	101.74	101.96	101.62	101.94	11448584.0
2009-09-04 15:00:00	SPY	ETF	101.93	102.09	101.72	102.07	27183569.0
2009-09-04 16:00:00	SPY	ETF	102.07	102.2215	100.69	101.9	7010276.0
2009-09-04 17:00:00	SPY	ETF	101.9	101.95	101.85	101.9	100522.0
2009-09-04 18:00:00	SPY	ETF	101.9	102.01	101.9	102.0	49800.0
2009-09-04 19:00:00	SPY	ETF	102.0	102.02	101.96	102.02	27083.0
2009-09-04 04:00:00	QQQ	ETF	39.69	39.69	39.68	39.68	467.0
2009-09-04 07:00:00	QQQ	ETF	39.67	39.72	39.64	39.68	43401.0
2009-09-04 08:00:00	QQQ	ETF	39.69	39.82	39.28	39.59	4853256.0
2009-09-04 09:00:00	QQQ	ETF	39.58	39.81	39.52	39.56	10896377.0
2009-09-04 10:00:00	QQQ	ETF	39.56	39.92	39.55	39.9	8066874.0
2009-09-04 11:00:00	QQQ	ETF	39.91	40.01	39.76	40.0	4758832.0
2009-09-04 12:00:00	QQQ	ETF	40.0	40.3	39.99	40.27	11491368.0
2009-09-04 13:00:00	QQQ	ETF	40.28	40.38	40.19	40.19	7240505.0
2009-09-04 14:00:00	QQQ	ETF	40.19	40.28	40.14	40.28	5979053.0
2009-09-04 15:00:00	QQQ	ETF	40.27	40.35	40.17	40.34	12230683.0
2009-09-04 16:00:00	QQQ	ETF	40.34	40.36	39.5422	40.32	5990617.0
2009-09-04 17:00:00	QQQ	ETF	40.3	40.32	40.24	40.32	17699.0
2009-09-04 18:00:00	QQQ	ETF	40.33	40.33	40.29	40.32	28874.0
2009-09-04 19:00:00	QQQ	ETF	40.32	40.35	40.22	40.24	49954.0
2009-09-04 06:00:00	IWM	ETF	56.33	56.33	56.32	56.32	40000.0
2009-09-04 07:00:00	IWM	ETF	56.32	56.44	56.31	56.44	103394.0
2009-09-04 08:00:00	IWM	ETF	56.44	56.68	56.09	56.25	2121040.0
2009-09-04 09:00:00	IWM	ETF	56.24	56.42	55.87	55.93	5982455.0
2009-09-04 10:00:00	IWM	ETF	55.93	56.34	55.92	56.25	4512422.0
2009-09-04 11:00:00	IWM	ETF	56.25	56.4	56.01	56.4	5216336.0
2009-09-04 12:00:00	IWM	ETF	56.4	56.78	56.38	56.77	3592042.0
2009-09-04 13:00:00	IWM	ETF	56.77	57.11	56.69	56.76	3466732.0
2009-09-04 14:00:00	IWM	ETF	56.76	56.84	56.57	56.79	1987623.0
2009-09-04 15:00:00	IWM	ETF	56.79	57.08	56.64	57.02	6031099.0
2009-09-04 16:00:00	IWM	ETF	57.03	57.1242	56.88	57.02	3267737.0
2009-09-04 17:00:00	IWM	ETF	56.93	57.04	56.93	56.99	3111.0
2009-09-04 18:00:00	IWM	ETF	56.99	57.05	56.95	57.03	1527.0
2009-09-04 19:00:00	IWM	ETF	57.02	57.04	57.02	57.04	400.0
2009-09-04 06:00:00	DIA	ETF	93.69	93.69	93.69	93.69	2000.0
2009-09-04 07:00:00	DIA	ETF	93.73	93.8	93.69	93.69	3100.0
2009-09-04 08:00:00	DIA	ETF	93.81	94.08	93.29	93.66	111490.0
2009-09-04 09:00:00	DIA	ETF	93.63	93.86	93.3	93.4099	1052798.0
2009-09-04 10:00:00	DIA	ETF	93.41	93.98	93.4	93.87	1029958.0
2009-09-04 11:00:00	DIA	ETF	93.87	93.94	93.57	93.94	757129.0

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

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