PREVIEW / etf_1hour / 2009-02-17

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-02-17.parquet
  size:    129 KB
  rows:    4,074

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-02-17 04:00:00	SPY	ETF	82.33	82.45	80.69	81.04	23976.0
2009-02-17 05:00:00	SPY	ETF	81.03	81.12	80.97	81.0	9389.0
2009-02-17 06:00:00	SPY	ETF	80.98	81.08	80.57	80.68	42200.0
2009-02-17 07:00:00	SPY	ETF	80.63	81.05	80.63	81.03	1968951.0
2009-02-17 08:00:00	SPY	ETF	80.82	82.15	79.74	79.81	7683389.0
2009-02-17 09:00:00	SPY	ETF	79.83	80.62	79.17	79.6601	65136569.0
2009-02-17 10:00:00	SPY	ETF	79.67	80.24	79.51	80.05	62710585.0
2009-02-17 11:00:00	SPY	ETF	80.05	80.11	79.4	79.55	42021118.0
2009-02-17 12:00:00	SPY	ETF	79.54	79.98	79.3	79.76	36437435.0
2009-02-17 13:00:00	SPY	ETF	79.76	80.05	79.25	79.65	53078871.0
2009-02-17 14:00:00	SPY	ETF	79.6584	80.17	79.4666	79.66	50433893.0
2009-02-17 15:00:00	SPY	ETF	79.66	82.958	79.17	79.22	109013559.0
2009-02-17 16:00:00	SPY	ETF	79.3	82.958	79.04	79.09	21022181.0
2009-02-17 17:00:00	SPY	ETF	79.09	82.958	79.02	79.27	1597691.0
2009-02-17 18:00:00	SPY	ETF	79.27	79.28	79.07	79.1	352256.0
2009-02-17 19:00:00	SPY	ETF	79.12	79.38	79.12	79.35	33766.0
2009-02-17 04:00:00	QQQ	ETF	29.72	29.72	29.67	29.67	1400.0
2009-02-17 05:00:00	QQQ	ETF	29.64	29.65	29.62	29.62	1400.0
2009-02-17 06:00:00	QQQ	ETF	29.62	29.62	29.49	29.49	9100.0
2009-02-17 07:00:00	QQQ	ETF	29.51	29.65	29.51	29.65	442202.0
2009-02-17 08:00:00	QQQ	ETF	29.65	29.76	29.4	29.43	2799118.0
2009-02-17 09:00:00	QQQ	ETF	29.42	29.6	29.06	29.3	30099067.0
2009-02-17 10:00:00	QQQ	ETF	29.31	29.55	29.24	29.46	22370281.0
2009-02-17 11:00:00	QQQ	ETF	29.46	29.462	29.19	29.24	15657237.0
2009-02-17 12:00:00	QQQ	ETF	29.25	29.36	29.17	29.3	10890033.0
2009-02-17 13:00:00	QQQ	ETF	29.31	29.45	29.15	29.3	12414469.0
2009-02-17 14:00:00	QQQ	ETF	29.3	29.54	29.24	29.39	14302778.0
2009-02-17 15:00:00	QQQ	ETF	29.38	29.67	29.24	29.25	36524970.0
2009-02-17 16:00:00	QQQ	ETF	29.25	29.28	29.12	29.22	8418387.0
2009-02-17 17:00:00	QQQ	ETF	29.22	29.27	29.22	29.24	183854.0
2009-02-17 18:00:00	QQQ	ETF	29.24	29.25	29.24	29.25	6132.0
2009-02-17 19:00:00	QQQ	ETF	29.25	29.32	29.25	29.3	30800.0
2009-02-17 06:00:00	IWM	ETF	43.54	43.57	43.37	43.37	15450.0
2009-02-17 07:00:00	IWM	ETF	43.34	43.45	43.22	43.32	72400.0
2009-02-17 08:00:00	IWM	ETF	42.98	43.42	42.71	42.77	506210.0
2009-02-17 09:00:00	IWM	ETF	42.75	43.54	42.75	43.13	11136273.0
2009-02-17 10:00:00	IWM	ETF	43.11	43.52	43.05	43.38	10528325.0
2009-02-17 11:00:00	IWM	ETF	43.38	43.39	42.96	43.07	8390452.0
2009-02-17 12:00:00	IWM	ETF	43.07	43.25	42.95	43.16	7751291.0
2009-02-17 13:00:00	IWM	ETF	43.16	43.35	42.89	43.11	10355315.0
2009-02-17 14:00:00	IWM	ETF	43.1	43.38	43.02	43.12	8245918.0
2009-02-17 15:00:00	IWM	ETF	43.11	43.62	42.89	42.93	17245662.0
2009-02-17 16:00:00	IWM	ETF	42.93	44.8132	42.6	44.8132	5502666.0
2009-02-17 17:00:00	IWM	ETF	42.89	42.92	42.72	42.76	148895.0
2009-02-17 18:00:00	IWM	ETF	42.81	42.81	42.7	42.7	600.0
2009-02-17 19:00:00	IWM	ETF	42.7	42.75	42.7	42.75	650.0
2009-02-17 04:00:00	DIA	ETF	77.5	77.5	77.29	77.29	200.0
2009-02-17 06:00:00	DIA	ETF	77.09	77.09	76.76	76.82	1900.0
2009-02-17 07:00:00	DIA	ETF	76.81	77.12	76.79	77.08	28317.0
2009-02-17 08:00:00	DIA	ETF	77.15	77.24	76.31	76.36	265231.0

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

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