PREVIEW / etf_1hour / 2008-05-02

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-05-02.parquet
  size:    107 KB
  rows:    3,393

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
2008-05-02 05:00:00	SPY	ETF	141.07	141.11	141.05	141.07	16200.0
2008-05-02 06:00:00	SPY	ETF	141.12	141.24	141.05	141.16	130100.0
2008-05-02 07:00:00	SPY	ETF	141.17	141.4	141.13	141.26	1038121.0
2008-05-02 08:00:00	SPY	ETF	141.26	142.6	141.0	142.29	18045959.0
2008-05-02 09:00:00	SPY	ETF	142.25	142.41	141.67	142.01	25553575.0
2008-05-02 10:00:00	SPY	ETF	142.01	142.3	141.27	141.37	27765091.0
2008-05-02 11:00:00	SPY	ETF	141.3785	141.9	141.37	141.49	19398630.0
2008-05-02 12:00:00	SPY	ETF	141.49	141.49	140.97	141.13	19539311.0
2008-05-02 13:00:00	SPY	ETF	141.14	141.27	140.62	141.03	20370039.0
2008-05-02 14:00:00	SPY	ETF	141.03	141.4	140.56	140.8	21875742.0
2008-05-02 15:00:00	SPY	ETF	140.81	141.43	140.75	141.34	23156336.0
2008-05-02 16:00:00	SPY	ETF	141.35	142.124	140.83	141.67	3108281.0
2008-05-02 17:00:00	SPY	ETF	141.68	141.72	141.58	141.58	67551.0
2008-05-02 18:00:00	SPY	ETF	141.6	141.72	141.6	141.72	4700.0
2008-05-02 19:00:00	SPY	ETF	141.68	141.73	141.61	141.65	19412.0
2008-05-02 04:00:00	QQQ	ETF	48.59	48.59	48.59	48.59	200.0
2008-05-02 06:00:00	QQQ	ETF	48.72	48.74	48.69	48.74	7000.0
2008-05-02 07:00:00	QQQ	ETF	48.71	48.77	48.69	48.72	151483.0
2008-05-02 08:00:00	QQQ	ETF	48.71	49.27	48.57	49.18	9094258.0
2008-05-02 09:00:00	QQQ	ETF	49.18	49.22	48.77	48.9	20607079.0
2008-05-02 10:00:00	QQQ	ETF	48.9	49.1	48.51	48.55	27852359.0
2008-05-02 11:00:00	QQQ	ETF	48.55	48.78	48.55	48.592	11402190.0
2008-05-02 12:00:00	QQQ	ETF	48.59	48.62	48.47	48.55	12058363.0
2008-05-02 13:00:00	QQQ	ETF	48.56	48.6	48.34	48.5	10433582.0
2008-05-02 14:00:00	QQQ	ETF	48.5	48.59	48.36	48.4	11903912.0
2008-05-02 15:00:00	QQQ	ETF	48.4	48.75	48.37	48.74	14955941.0
2008-05-02 16:00:00	QQQ	ETF	48.74	48.96	48.72	48.9	2811167.0
2008-05-02 17:00:00	QQQ	ETF	48.89	48.93	48.87	48.91	23951.0
2008-05-02 18:00:00	QQQ	ETF	48.88	48.93	48.87	48.93	13500.0
2008-05-02 19:00:00	QQQ	ETF	48.92	48.93	48.91	48.91	13100.0
2008-05-02 07:00:00	IWM	ETF	72.92	73.01	72.92	72.96	37100.0
2008-05-02 08:00:00	IWM	ETF	72.93	73.7	72.83	73.45	1758113.0
2008-05-02 09:00:00	IWM	ETF	73.43	73.51	72.91	73.15	7805886.0
2008-05-02 10:00:00	IWM	ETF	73.16	73.5	72.79	72.87	10359269.0
2008-05-02 11:00:00	IWM	ETF	72.87	73.11	72.8	72.85	4211160.0
2008-05-02 12:00:00	IWM	ETF	72.84	72.87	72.38	72.51	8914635.0
2008-05-02 13:00:00	IWM	ETF	72.52	72.63	72.24	72.52	5953633.0
2008-05-02 14:00:00	IWM	ETF	72.51	72.64	72.26	72.41	6297953.0
2008-05-02 15:00:00	IWM	ETF	72.41	72.7	72.38	72.47	10116595.0
2008-05-02 16:00:00	IWM	ETF	72.48	72.78	72.4	72.69	2170183.0
2008-05-02 06:00:00	DIA	ETF	130.14	130.15	130.06	130.06	3400.0
2008-05-02 08:00:00	DIA	ETF	130.21	131.37	130.16	131.24	473536.0
2008-05-02 09:00:00	DIA	ETF	131.19	131.34	130.61	131.02	2211139.0
2008-05-02 10:00:00	DIA	ETF	131.02	131.24	130.3	130.38	2460740.0
2008-05-02 11:00:00	DIA	ETF	130.38	130.76	130.38	130.5	1449703.0
2008-05-02 12:00:00	DIA	ETF	130.5	130.5	130.07	130.22	1447838.0
2008-05-02 13:00:00	DIA	ETF	130.22	130.37	129.8	130.16	1030708.0
2008-05-02 14:00:00	DIA	ETF	130.16	130.34	129.73	129.98	1824876.0
2008-05-02 15:00:00	DIA	ETF	129.97	130.56	129.92	130.47	1453354.0
2008-05-02 16:00:00	DIA	ETF	130.47	130.76	130.47	130.76	159154.0

> showing 50 of 3,393 rows — these rows as CSV

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