PREVIEW / etf_1hour / 2009-10-02

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-10-02.parquet
  size:    145 KB
  rows:    4,465

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-02 04:00:00	SPY	ETF	102.95	103.03	102.86	103.03	9700.0
2009-10-02 05:00:00	SPY	ETF	103.12	103.15	102.85	102.85	6500.0
2009-10-02 06:00:00	SPY	ETF	102.9	102.95	102.85	102.86	23800.0
2009-10-02 07:00:00	SPY	ETF	102.87	103.03	102.81	102.98	324081.0
2009-10-02 08:00:00	SPY	ETF	102.94	103.11	101.75	101.82	14500827.0
2009-10-02 09:00:00	SPY	ETF	101.82	102.58	101.68	102.32	42742679.0
2009-10-02 10:00:00	SPY	ETF	102.32	103.1	102.03	102.59	52136699.0
2009-10-02 11:00:00	SPY	ETF	102.59	102.89	102.34	102.4291	28301635.0
2009-10-02 12:00:00	SPY	ETF	102.42	103.03	102.41	102.7801	18031190.0
2009-10-02 13:00:00	SPY	ETF	102.78	103.08	102.76	102.87	13157337.0
2009-10-02 14:00:00	SPY	ETF	102.87	103.03	102.72	102.8	13272559.0
2009-10-02 15:00:00	SPY	ETF	102.79	102.85	102.36	102.55	27453453.0
2009-10-02 16:00:00	SPY	ETF	102.55	103.2767	102.2	102.68	9120369.0
2009-10-02 17:00:00	SPY	ETF	102.68	102.8	102.62	102.7	174897.0
2009-10-02 18:00:00	SPY	ETF	102.72	102.75	102.7	102.75	7600.0
2009-10-02 19:00:00	SPY	ETF	102.71	102.8	102.7	102.78	34706.0
2009-10-02 04:00:00	QQQ	ETF	41.01	41.01	40.99	41.01	1800.0
2009-10-02 05:00:00	QQQ	ETF	40.98	40.98	40.98	40.98	200.0
2009-10-02 06:00:00	QQQ	ETF	40.99	41.05	40.99	41.05	7200.0
2009-10-02 07:00:00	QQQ	ETF	40.99	41.05	40.96	41.04	49527.0
2009-10-02 08:00:00	QQQ	ETF	41.02	41.03	40.63	40.66	5648855.0
2009-10-02 09:00:00	QQQ	ETF	40.66	41.09	40.64	41.0	32158903.0
2009-10-02 10:00:00	QQQ	ETF	40.99	41.25	40.93	41.008	32831270.0
2009-10-02 11:00:00	QQQ	ETF	41.01	41.09	40.87	40.93	15345565.0
2009-10-02 12:00:00	QQQ	ETF	40.92	41.15	40.92	41.0898	12561474.0
2009-10-02 13:00:00	QQQ	ETF	41.08	41.17	40.9917	41.1	7009829.0
2009-10-02 14:00:00	QQQ	ETF	41.1	41.14	41.01	41.07	7716830.0
2009-10-02 15:00:00	QQQ	ETF	41.0605	41.11	40.86	40.89	20111896.0
2009-10-02 16:00:00	QQQ	ETF	40.89	41.0597	40.88	40.95	3779941.0
2009-10-02 17:00:00	QQQ	ETF	40.94	40.96	40.92	40.96	58365.0
2009-10-02 18:00:00	QQQ	ETF	40.96	40.96	40.93	40.93	2500.0
2009-10-02 19:00:00	QQQ	ETF	40.96	40.97	40.96	40.97	3600.0
2009-10-02 06:00:00	IWM	ETF	58.45	58.45	58.43	58.43	1000.0
2009-10-02 07:00:00	IWM	ETF	58.44	58.5	58.42	58.48	58600.0
2009-10-02 08:00:00	IWM	ETF	58.44	58.48	57.61	57.63	1760090.0
2009-10-02 09:00:00	IWM	ETF	57.62	58.03	57.59	57.73	13126628.0
2009-10-02 10:00:00	IWM	ETF	57.73	58.4	57.53	57.94	15538962.0
2009-10-02 11:00:00	IWM	ETF	57.94	58.23	57.81	57.88	4691104.0
2009-10-02 12:00:00	IWM	ETF	57.882	58.35	57.882	58.322	6101263.0
2009-10-02 13:00:00	IWM	ETF	58.32	58.52	58.26	58.36	6810466.0
2009-10-02 14:00:00	IWM	ETF	58.37	58.52	58.25	58.35	6012607.0
2009-10-02 15:00:00	IWM	ETF	58.35	58.35	57.96	58.03	8892128.0
2009-10-02 16:00:00	IWM	ETF	58.03	58.381	57.94	58.12	2182701.0
2009-10-02 17:00:00	IWM	ETF	58.13	58.15	58.06	58.15	16652.0
2009-10-02 18:00:00	IWM	ETF	58.14	58.2	58.14	58.19	400.0
2009-10-02 19:00:00	IWM	ETF	58.19	58.2	58.13	58.13	1000.0
2009-10-02 06:00:00	DIA	ETF	94.99	94.99	94.99	94.99	200.0
2009-10-02 07:00:00	DIA	ETF	94.97	95.1	94.95	95.03	8200.0
2009-10-02 08:00:00	DIA	ETF	95.06	95.06	94.01	94.13	260755.0
2009-10-02 09:00:00	DIA	ETF	94.04	94.75	94.0	94.55	4621595.0

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

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