PREVIEW / etf_1hour / 2009-02-24

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-02-24.parquet
  size:    131 KB
  rows:    4,042

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-24 04:00:00	SPY	ETF	75.68	75.8	75.2	75.2	14300.0
2009-02-24 05:00:00	SPY	ETF	75.3	75.59	75.25	75.5	3100.0
2009-02-24 06:00:00	SPY	ETF	75.51	75.86	75.36	75.36	36800.0
2009-02-24 07:00:00	SPY	ETF	75.38	75.75	75.35	75.65	693102.0
2009-02-24 08:00:00	SPY	ETF	75.65	75.76	75.01	75.1	3476646.0
2009-02-24 09:00:00	SPY	ETF	75.11	75.84	75.1	75.38	40918952.0
2009-02-24 10:00:00	SPY	ETF	75.38	76.24	74.84	75.85	77049730.0
2009-02-24 11:00:00	SPY	ETF	75.84	76.01	75.26	75.37	39859657.0
2009-02-24 12:00:00	SPY	ETF	75.38	75.96	75.09	75.84	39012403.0
2009-02-24 13:00:00	SPY	ETF	75.84	77.0	75.55	76.918	62152946.0
2009-02-24 14:00:00	SPY	ETF	76.92	77.4	76.67	77.27	58434501.0
2009-02-24 15:00:00	SPY	ETF	77.26	77.95	76.56	77.57	80024118.0
2009-02-24 16:00:00	SPY	ETF	77.58	77.75	74.7003	77.41	18590896.0
2009-02-24 17:00:00	SPY	ETF	77.4	77.62	77.36	77.6	593600.0
2009-02-24 18:00:00	SPY	ETF	77.57	77.69	77.51	77.59	174930.0
2009-02-24 19:00:00	SPY	ETF	77.64	77.66	77.39	77.4	67583.0
2009-02-24 04:00:00	QQQ	ETF	28.09	28.1	28.0	28.0	2120.0
2009-02-24 06:00:00	QQQ	ETF	28.04	28.19	28.03	28.19	20100.0
2009-02-24 07:00:00	QQQ	ETF	28.09	28.16	28.06	28.1	32975.0
2009-02-24 08:00:00	QQQ	ETF	28.11	28.11	27.98	28.01	442516.0
2009-02-24 09:00:00	QQQ	ETF	28.05	28.35	27.96	28.15	23901511.0
2009-02-24 10:00:00	QQQ	ETF	28.15	28.53	27.97	28.33	27954475.0
2009-02-24 11:00:00	QQQ	ETF	28.3205	28.4	28.05	28.131	13763821.0
2009-02-24 12:00:00	QQQ	ETF	28.13	28.28	28.02	28.19	14952996.0
2009-02-24 13:00:00	QQQ	ETF	28.2	28.54	28.05	28.5	24751904.0
2009-02-24 14:00:00	QQQ	ETF	28.5	28.75	28.43	28.7	22601922.0
2009-02-24 15:00:00	QQQ	ETF	28.7	28.98	28.67	28.78	42194372.0
2009-02-24 16:00:00	QQQ	ETF	28.78	28.8511	28.64	28.71	5947050.0
2009-02-24 17:00:00	QQQ	ETF	28.69	28.73	28.66	28.73	169471.0
2009-02-24 18:00:00	QQQ	ETF	28.71	28.79	28.71	28.74	35162.0
2009-02-24 19:00:00	QQQ	ETF	28.74	28.78	28.7	28.7	29110.0
2009-02-24 06:00:00	IWM	ETF	40.32	40.32	40.17	40.17	560.0
2009-02-24 07:00:00	IWM	ETF	40.14	40.31	40.13	40.21	66332.0
2009-02-24 08:00:00	IWM	ETF	40.21	40.26	39.88	39.93	268582.0
2009-02-24 09:00:00	IWM	ETF	39.95	40.39	39.89	40.0	7022949.0
2009-02-24 10:00:00	IWM	ETF	40.0	40.4	39.6	40.1716	13537827.0
2009-02-24 11:00:00	IWM	ETF	40.17	40.31	39.86	39.92	7523326.0
2009-02-24 12:00:00	IWM	ETF	39.92	40.18	39.76	40.11	7829707.0
2009-02-24 13:00:00	IWM	ETF	40.11	40.8	39.96	40.748	12880083.0
2009-02-24 14:00:00	IWM	ETF	40.75	41.08	40.64	41.0	8096732.0
2009-02-24 15:00:00	IWM	ETF	41.0	41.37	40.965	41.08	18111565.0
2009-02-24 16:00:00	IWM	ETF	41.08	41.18	39.4592	41.04	3474001.0
2009-02-24 17:00:00	IWM	ETF	41.04	41.04	41.0	41.0	6994.0
2009-02-24 18:00:00	IWM	ETF	40.95	40.95	40.95	40.95	400.0
2009-02-24 19:00:00	IWM	ETF	41.79	41.79	40.93	40.93	1250.0
2009-02-24 04:00:00	DIA	ETF	71.78	71.78	71.78	71.78	102.0
2009-02-24 06:00:00	DIA	ETF	71.88	71.95	71.68	71.68	1400.0
2009-02-24 07:00:00	DIA	ETF	71.66	71.93	71.66	71.88	8700.0
2009-02-24 08:00:00	DIA	ETF	71.85	71.91	71.42	71.5	94849.0
2009-02-24 09:00:00	DIA	ETF	71.54	72.03	71.46	71.59	3424660.0

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

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