PREVIEW / etf_1hour / 2008-07-02

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-07-02.parquet
  size:    111 KB
  rows:    3,525

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-07-02 04:00:00	SPY	ETF	128.67	128.67	128.67	128.67	1000.0
2008-07-02 05:00:00	SPY	ETF	128.73	129.0	128.71	129.0	2300.0
2008-07-02 06:00:00	SPY	ETF	129.04	129.21	128.84	129.14	295000.0
2008-07-02 07:00:00	SPY	ETF	129.11	129.28	129.1	129.16	1221325.0
2008-07-02 08:00:00	SPY	ETF	129.16	129.28	127.98	128.65	5203839.0
2008-07-02 09:00:00	SPY	ETF	128.66	129.08	128.63	128.94	24400962.0
2008-07-02 10:00:00	SPY	ETF	128.94	129.16	128.5	128.87	41720581.0
2008-07-02 11:00:00	SPY	ETF	128.88	128.88	127.72	127.83	43154555.0
2008-07-02 12:00:00	SPY	ETF	127.82	128.18	127.49	127.86	29730830.0
2008-07-02 13:00:00	SPY	ETF	127.862	128.4	127.51	128.3	27834324.0
2008-07-02 14:00:00	SPY	ETF	128.3	128.41	127.16	127.3	46909075.0
2008-07-02 15:00:00	SPY	ETF	127.29	127.37	126.04	126.07	58891341.0
2008-07-02 16:00:00	SPY	ETF	126.06	126.26	125.96	126.18	5093776.0
2008-07-02 17:00:00	SPY	ETF	126.18	126.19	125.98	126.01	501859.0
2008-07-02 18:00:00	SPY	ETF	126.01	126.18	126.01	126.16	3091232.0
2008-07-02 19:00:00	SPY	ETF	126.16	126.22	126.14	126.18	24732.0
2008-07-02 05:00:00	QQQ	ETF	46.0	46.03	46.0	46.03	600.0
2008-07-02 06:00:00	QQQ	ETF	46.08	46.18	46.05	46.16	58600.0
2008-07-02 07:00:00	QQQ	ETF	46.15	46.25	46.13	46.21	208753.0
2008-07-02 08:00:00	QQQ	ETF	46.2	46.21	45.81	46.02	2807198.0
2008-07-02 09:00:00	QQQ	ETF	46.02	46.13	45.77	45.85	21072252.0
2008-07-02 10:00:00	QQQ	ETF	45.85	46.0	45.59	45.8401	27536809.0
2008-07-02 11:00:00	QQQ	ETF	45.8401	45.8401	45.23	45.32	27218561.0
2008-07-02 12:00:00	QQQ	ETF	45.31	45.5	45.13	45.27	24479511.0
2008-07-02 13:00:00	QQQ	ETF	45.27	45.62	45.15	45.57	20459736.0
2008-07-02 14:00:00	QQQ	ETF	45.5721	45.6	45.09	45.19	20983505.0
2008-07-02 15:00:00	QQQ	ETF	45.19	45.26	44.64	44.68	36887538.0
2008-07-02 16:00:00	QQQ	ETF	44.68	45.3815	44.65	44.66	6203069.0
2008-07-02 17:00:00	QQQ	ETF	44.66	44.68	44.42	44.5	1889113.0
2008-07-02 18:00:00	QQQ	ETF	44.47	44.57	44.47	44.52	57415.0
2008-07-02 19:00:00	QQQ	ETF	44.52	44.55	44.5	44.52	49709.0
2008-07-02 06:00:00	IWM	ETF	69.26	69.28	69.21	69.25	22000.0
2008-07-02 07:00:00	IWM	ETF	69.2	69.4	69.2	69.36	547698.0
2008-07-02 08:00:00	IWM	ETF	69.36	69.37	69.01	69.03	2403351.0
2008-07-02 09:00:00	IWM	ETF	69.0	69.18	68.61	68.82	20153545.0
2008-07-02 10:00:00	IWM	ETF	68.82	68.93	68.23	68.44	20023473.0
2008-07-02 11:00:00	IWM	ETF	68.43	68.44	67.46	67.57	18909029.0
2008-07-02 12:00:00	IWM	ETF	67.57	67.86	67.44	67.73	13784575.0
2008-07-02 13:00:00	IWM	ETF	67.73	68.16	67.52	68.1	10231689.0
2008-07-02 14:00:00	IWM	ETF	68.11	68.14	67.43	67.5	13407095.0
2008-07-02 15:00:00	IWM	ETF	67.5	68.15	66.86	66.86	22602373.0
2008-07-02 16:00:00	IWM	ETF	66.86	68.93	66.76	66.89	14746398.0
2008-07-02 17:00:00	IWM	ETF	66.91	66.91	66.73	66.9	31500.0
2008-07-02 18:00:00	IWM	ETF	66.73	66.92	66.71	66.91	29738.0
2008-07-02 19:00:00	IWM	ETF	66.91	66.91	66.85	66.88	2105.0
2008-07-02 05:00:00	DIA	ETF	114.0	114.01	114.0	114.01	300.0
2008-07-02 06:00:00	DIA	ETF	114.26	114.31	114.26	114.3	4500.0
2008-07-02 07:00:00	DIA	ETF	114.31	114.39	114.3	114.33	12787.0
2008-07-02 08:00:00	DIA	ETF	114.28	114.3	113.7	113.7	119441.0
2008-07-02 09:00:00	DIA	ETF	113.71	114.08	113.71	113.99	2378477.0

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

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