PREVIEW / etf_1hour / 2008-05-05

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-05-05.parquet
  size:    102 KB
  rows:    3,330

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-05 04:00:00	SPY	ETF	141.0	141.0	141.0	141.0	1000.0
2008-05-05 05:00:00	SPY	ETF	140.94	140.97	140.94	140.97	500.0
2008-05-05 06:00:00	SPY	ETF	140.88	140.88	140.8	140.85	76000.0
2008-05-05 07:00:00	SPY	ETF	140.83	141.05	140.81	140.94	508999.0
2008-05-05 08:00:00	SPY	ETF	141.2	141.2	140.74	140.9	1027101.0
2008-05-05 09:00:00	SPY	ETF	140.92	141.35	140.78	141.2	12111024.0
2008-05-05 10:00:00	SPY	ETF	141.2	141.61	140.5	140.51	31890542.0
2008-05-05 11:00:00	SPY	ETF	140.51	140.95	140.41	140.84	18897549.0
2008-05-05 12:00:00	SPY	ETF	140.84	140.94	140.54	140.86	12331938.0
2008-05-05 13:00:00	SPY	ETF	140.86	140.9	140.44	140.52	10021643.0
2008-05-05 14:00:00	SPY	ETF	140.53	140.85	140.42	140.69	11495122.0
2008-05-05 15:00:00	SPY	ETF	140.68	140.9	140.63	140.71	16528790.0
2008-05-05 16:00:00	SPY	ETF	140.7	141.43	140.6798	140.83	1544990.0
2008-05-05 17:00:00	SPY	ETF	140.82	140.89	140.82	140.87	98357.0
2008-05-05 18:00:00	SPY	ETF	140.87	140.94	140.82	140.82	17566.0
2008-05-05 19:00:00	SPY	ETF	140.87	140.88	140.87	140.88	3400.0
2008-05-05 04:00:00	QQQ	ETF	48.57	48.57	48.57	48.57	100.0
2008-05-05 06:00:00	QQQ	ETF	48.59	48.64	48.59	48.63	600.0
2008-05-05 07:00:00	QQQ	ETF	48.63	48.71	48.6	48.69	295100.0
2008-05-05 08:00:00	QQQ	ETF	48.69	48.7	48.62	48.67	796528.0
2008-05-05 09:00:00	QQQ	ETF	48.67	48.87	48.57	48.7801	11484701.0
2008-05-05 10:00:00	QQQ	ETF	48.78	49.03	48.55	48.57	19178669.0
2008-05-05 11:00:00	QQQ	ETF	48.58	48.85	48.52	48.67	11144571.0
2008-05-05 12:00:00	QQQ	ETF	48.668	48.72	48.55	48.68	5400570.0
2008-05-05 13:00:00	QQQ	ETF	48.69	48.7	48.4	48.45	6556721.0
2008-05-05 14:00:00	QQQ	ETF	48.45	48.63	48.41	48.53	7535838.0
2008-05-05 15:00:00	QQQ	ETF	48.52	48.63	48.51	48.62	8548769.0
2008-05-05 16:00:00	QQQ	ETF	48.6199	48.6577	48.59	48.64	2860732.0
2008-05-05 17:00:00	QQQ	ETF	48.63	48.64	48.62	48.63	7072.0
2008-05-05 18:00:00	QQQ	ETF	48.63	48.65	48.62	48.62	37138.0
2008-05-05 19:00:00	QQQ	ETF	48.64	48.64	48.63	48.63	8400.0
2008-05-05 07:00:00	IWM	ETF	72.27	72.29	72.27	72.27	80500.0
2008-05-05 08:00:00	IWM	ETF	72.4	72.4	72.15	72.15	104740.0
2008-05-05 09:00:00	IWM	ETF	72.16	72.37	71.96	72.3	4354852.0
2008-05-05 10:00:00	IWM	ETF	72.31	72.7	71.98	71.98	8696702.0
2008-05-05 11:00:00	IWM	ETF	71.98	72.35	71.94	72.21	5226501.0
2008-05-05 12:00:00	IWM	ETF	72.21	72.31	72.07	72.23	2743131.0
2008-05-05 13:00:00	IWM	ETF	72.23	72.27	71.88	71.94	4622014.0
2008-05-05 14:00:00	IWM	ETF	71.94	72.21	71.9	72.12	5982505.0
2008-05-05 15:00:00	IWM	ETF	72.12	72.33	72.12	72.25	4796044.0
2008-05-05 16:00:00	IWM	ETF	72.26	72.4	72.18	72.4	2633745.0
2008-05-05 17:00:00	IWM	ETF	72.29	72.29	72.29	72.29	530.0
2008-05-05 07:00:00	DIA	ETF	130.27	130.27	130.27	130.27	100.0
2008-05-05 08:00:00	DIA	ETF	130.22	130.25	130.13	130.18	20492.0
2008-05-05 09:00:00	DIA	ETF	130.16	130.5	129.82	130.02	1341859.0
2008-05-05 10:00:00	DIA	ETF	130.04	130.31	129.46	129.46	2442168.0
2008-05-05 11:00:00	DIA	ETF	129.46	129.8	129.42	129.77	1065446.0
2008-05-05 12:00:00	DIA	ETF	129.77	129.86	129.53	129.77	596459.0
2008-05-05 13:00:00	DIA	ETF	129.78	129.81	129.33	129.38	951909.0
2008-05-05 14:00:00	DIA	ETF	129.41	129.73	129.33	129.58	704808.0

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

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