PREVIEW / etf_1hour / 2009-11-05

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-11-05.parquet
  size:    144 KB
  rows:    4,510

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-11-05 04:00:00	SPY	ETF	105.05	105.17	105.03	105.12	1200.0
2009-11-05 05:00:00	SPY	ETF	105.05	105.05	105.05	105.05	100.0
2009-11-05 06:00:00	SPY	ETF	105.2	105.25	105.1	105.2	52300.0
2009-11-05 07:00:00	SPY	ETF	105.12	105.46	105.09	105.4	1156661.0
2009-11-05 08:00:00	SPY	ETF	105.18	105.76	104.91	105.6	6516389.0
2009-11-05 09:00:00	SPY	ETF	105.6	106.15	104.91	106.09	29963292.0
2009-11-05 10:00:00	SPY	ETF	106.1	106.66	105.96	106.5925	31724155.0
2009-11-05 11:00:00	SPY	ETF	106.59	106.67	106.07	106.11	21737883.0
2009-11-05 12:00:00	SPY	ETF	106.11	106.58	106.07	106.57	15110576.0
2009-11-05 13:00:00	SPY	ETF	106.57	106.77	106.43	106.4601	13268221.0
2009-11-05 14:00:00	SPY	ETF	106.46	106.75	106.31	106.68	14917997.0
2009-11-05 15:00:00	SPY	ETF	106.68	106.88	106.51	106.86	32998398.0
2009-11-05 16:00:00	SPY	ETF	106.85	106.9	104.8463	106.86	11704270.0
2009-11-05 17:00:00	SPY	ETF	106.86	106.93	106.16	106.84	218445.0
2009-11-05 18:00:00	SPY	ETF	106.86	106.88	106.12	106.8	141291.0
2009-11-05 19:00:00	SPY	ETF	106.76	106.85	106.75	106.78	63179.0
2009-11-05 04:00:00	QQQ	ETF	41.27	41.4	41.27	41.4	800.0
2009-11-05 07:00:00	QQQ	ETF	41.44	41.73	41.44	41.69	1184496.0
2009-11-05 08:00:00	QQQ	ETF	41.69	41.84	41.48	41.79	7539300.0
2009-11-05 09:00:00	QQQ	ETF	41.78	42.13	41.78	42.0999	18009009.0
2009-11-05 10:00:00	QQQ	ETF	42.1	42.4	42.07	42.335	21785096.0
2009-11-05 11:00:00	QQQ	ETF	42.35	42.38	42.15	42.15	10398366.0
2009-11-05 12:00:00	QQQ	ETF	42.158	42.31	42.15	42.3	7016350.0
2009-11-05 13:00:00	QQQ	ETF	42.2991	42.37	42.21	42.26	5536587.0
2009-11-05 14:00:00	QQQ	ETF	42.26	42.35	42.22	42.32	9244238.0
2009-11-05 15:00:00	QQQ	ETF	42.32	42.36	42.2	42.35	11528382.0
2009-11-05 16:00:00	QQQ	ETF	42.35	42.36	41.3536	42.36	9608960.0
2009-11-05 17:00:00	QQQ	ETF	42.35	42.36	42.34	42.34	84650.0
2009-11-05 18:00:00	QQQ	ETF	42.35	42.35	42.32	42.32	107124.0
2009-11-05 19:00:00	QQQ	ETF	42.32	42.35	42.31	42.34	33078.0
2009-11-05 07:00:00	IWM	ETF	56.75	56.85	56.75	56.85	100692.0
2009-11-05 08:00:00	IWM	ETF	56.85	56.99	56.25	56.84	668573.0
2009-11-05 09:00:00	IWM	ETF	56.84	57.51	56.25	57.4	13005024.0
2009-11-05 10:00:00	IWM	ETF	57.41	57.91	57.32	57.79	11134755.0
2009-11-05 11:00:00	IWM	ETF	57.785	57.84	57.42	57.43	7301025.0
2009-11-05 12:00:00	IWM	ETF	57.43	57.96	57.43	57.96	7534603.0
2009-11-05 13:00:00	IWM	ETF	57.95	58.11	57.78	57.89	6437680.0
2009-11-05 14:00:00	IWM	ETF	57.89	58.16	57.76	58.06	6720558.0
2009-11-05 15:00:00	IWM	ETF	58.06	58.15	57.93	58.05	10990241.0
2009-11-05 16:00:00	IWM	ETF	58.06	58.1737	57.8537	58.11	1547107.0
2009-11-05 17:00:00	IWM	ETF	58.09	58.13	57.47	58.06	26062.0
2009-11-05 18:00:00	IWM	ETF	58.07	58.07	58.01	58.02	6869.0
2009-11-05 19:00:00	IWM	ETF	58.08	58.09	57.97	58.0	2350.0
2009-11-05 08:00:00	DIA	ETF	98.45	98.92	98.45	98.78	72150.0
2009-11-05 09:00:00	DIA	ETF	98.85	99.43	98.81	99.3695	1320244.0
2009-11-05 10:00:00	DIA	ETF	99.4	99.99	99.35	99.93	1981360.0
2009-11-05 11:00:00	DIA	ETF	99.94	100.0	99.56	99.619	1023074.0
2009-11-05 12:00:00	DIA	ETF	99.62	99.92	99.572	99.92	1020278.0
2009-11-05 13:00:00	DIA	ETF	99.9141	100.0274	99.77	99.79	601625.0
2009-11-05 14:00:00	DIA	ETF	99.79	100.1	99.66	100.07	1557306.0

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

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