PREVIEW / etf_1hour / 2009-10-07

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-10-07.parquet
  size:    142 KB
  rows:    4,381

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-10-07 04:00:00	SPY	ETF	105.49	105.69	105.49	105.69	5400.0
2009-10-07 05:00:00	SPY	ETF	105.8	105.8	105.68	105.68	5500.0
2009-10-07 06:00:00	SPY	ETF	105.75	105.75	105.45	105.46	4300.0
2009-10-07 07:00:00	SPY	ETF	105.42	105.57	105.33	105.44	81951.0
2009-10-07 08:00:00	SPY	ETF	105.41	105.49	104.99	105.06	3317175.0
2009-10-07 09:00:00	SPY	ETF	105.06	105.66	105.04	105.44	25725117.0
2009-10-07 10:00:00	SPY	ETF	105.44	105.78	105.28	105.59	32419953.0
2009-10-07 11:00:00	SPY	ETF	105.6	105.91	105.24	105.24	19733307.0
2009-10-07 12:00:00	SPY	ETF	105.25	105.58	105.23	105.57	12077396.0
2009-10-07 13:00:00	SPY	ETF	105.57	105.62	105.34	105.5	9443034.0
2009-10-07 14:00:00	SPY	ETF	105.4901	105.6017	105.21	105.5491	15369230.0
2009-10-07 15:00:00	SPY	ETF	105.54	105.87	105.33	105.8	30649704.0
2009-10-07 16:00:00	SPY	ETF	105.8	106.25	105.29	106.17	9321936.0
2009-10-07 17:00:00	SPY	ETF	106.17	106.23	106.06	106.17	213485.0
2009-10-07 18:00:00	SPY	ETF	106.17	106.24	106.13	106.15	130457.0
2009-10-07 19:00:00	SPY	ETF	106.15	106.42	106.12	106.36	141301.0
2009-10-07 06:00:00	QQQ	ETF	42.06	42.06	41.96	42.02	44500.0
2009-10-07 07:00:00	QQQ	ETF	41.92	41.99	41.91	41.97	50613.0
2009-10-07 08:00:00	QQQ	ETF	41.95	41.95	41.77	41.78	769390.0
2009-10-07 09:00:00	QQQ	ETF	41.8	42.02	41.77	41.89	14391325.0
2009-10-07 10:00:00	QQQ	ETF	41.9	42.08	41.82	41.98	25621495.0
2009-10-07 11:00:00	QQQ	ETF	41.97	42.07	41.85	41.85	7536047.0
2009-10-07 12:00:00	QQQ	ETF	41.85	42.01	41.84	41.98	6212926.0
2009-10-07 13:00:00	QQQ	ETF	41.989	41.999	41.88	41.92	4111358.0
2009-10-07 14:00:00	QQQ	ETF	41.93	41.98	41.8	41.9599	6890857.0
2009-10-07 15:00:00	QQQ	ETF	41.96	42.08	41.9	42.06	15634832.0
2009-10-07 16:00:00	QQQ	ETF	42.06	42.22	42.03	42.14	3993062.0
2009-10-07 17:00:00	QQQ	ETF	42.15	42.22	42.11	42.22	102635.0
2009-10-07 18:00:00	QQQ	ETF	42.19	42.2	42.15	42.17	21000.0
2009-10-07 19:00:00	QQQ	ETF	42.18	42.27	42.17	42.25	35710.0
2009-10-07 07:00:00	IWM	ETF	60.14	60.17	60.0	60.1	28400.0
2009-10-07 08:00:00	IWM	ETF	60.1	60.1	59.8	59.85	225161.0
2009-10-07 09:00:00	IWM	ETF	59.85	60.3401	59.82	60.12	6679370.0
2009-10-07 10:00:00	IWM	ETF	60.13	60.41	59.99	60.131	8474631.0
2009-10-07 11:00:00	IWM	ETF	60.125	60.36	59.94	59.97	4455825.0
2009-10-07 12:00:00	IWM	ETF	59.97	60.2	59.96	60.18	2317675.0
2009-10-07 13:00:00	IWM	ETF	60.19	60.2	59.99	60.08	1736267.0
2009-10-07 14:00:00	IWM	ETF	60.065	60.09	59.87	60.0475	3389431.0
2009-10-07 15:00:00	IWM	ETF	60.05	60.24	59.94	60.2	6113377.0
2009-10-07 16:00:00	IWM	ETF	60.2	60.56	60.13	60.49	1998549.0
2009-10-07 17:00:00	IWM	ETF	60.51	60.58	60.45	60.56	58386.0
2009-10-07 18:00:00	IWM	ETF	60.47	60.55	60.47	60.55	2000.0
2009-10-07 19:00:00	IWM	ETF	60.55	60.74	60.52	60.73	16964.0
2009-10-07 07:00:00	DIA	ETF	97.28	97.34	97.25	97.25	2200.0
2009-10-07 08:00:00	DIA	ETF	97.3	97.3	97.0	97.0	21750.0
2009-10-07 09:00:00	DIA	ETF	97.05	97.41	96.91	97.14	2114127.0
2009-10-07 10:00:00	DIA	ETF	97.14	97.38	96.96	97.26	2702881.0
2009-10-07 11:00:00	DIA	ETF	97.26	97.48	96.88	96.88	1129110.0
2009-10-07 12:00:00	DIA	ETF	96.88	97.17	96.85	97.1644	713422.0
2009-10-07 13:00:00	DIA	ETF	97.18	97.2	96.96	97.07	359133.0

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

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