PREVIEW / etf_1hour / 2008-03-31

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-03-31.parquet
  size:    99 KB
  rows:    3,345

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-03-31 04:00:00	SPY	ETF	130.76	130.82	130.76	130.79	3800.0
2008-03-31 05:00:00	SPY	ETF	131.1	131.1	131.1	131.1	500.0
2008-03-31 06:00:00	SPY	ETF	131.2	131.54	131.2	131.42	56200.0
2008-03-31 07:00:00	SPY	ETF	131.48	131.7	131.3	131.69	203700.0
2008-03-31 08:00:00	SPY	ETF	131.69	131.79	130.68	131.28	2110200.0
2008-03-31 09:00:00	SPY	ETF	131.31	132.05	131.09	131.89	23529641.0
2008-03-31 10:00:00	SPY	ETF	131.88	131.92	131.36	131.85	20652314.0
2008-03-31 11:00:00	SPY	ETF	131.85	132.35	131.62	132.21	16257111.0
2008-03-31 12:00:00	SPY	ETF	132.2	132.42	131.91	132.415	10098766.0
2008-03-31 13:00:00	SPY	ETF	132.4	132.73	132.34	132.36	15304273.0
2008-03-31 14:00:00	SPY	ETF	132.35	132.44	131.78	132.05	17364102.0
2008-03-31 15:00:00	SPY	ETF	132.04	132.57	131.83	131.94	34328993.0
2008-03-31 16:00:00	SPY	ETF	131.96	132.5047	131.14	132.0	15728700.0
2008-03-31 17:00:00	SPY	ETF	132.0	132.03	131.9	131.95	396500.0
2008-03-31 18:00:00	SPY	ETF	131.95	132.0	131.82	132.0	141800.0
2008-03-31 19:00:00	SPY	ETF	132.03	132.03	131.86	131.86	23700.0
2008-03-31 04:00:00	QQQ	ETF	43.41	43.41	43.41	43.41	2000.0
2008-03-31 05:00:00	QQQ	ETF	43.49	43.53	43.49	43.53	3000.0
2008-03-31 06:00:00	QQQ	ETF	43.61	43.61	43.61	43.61	2700.0
2008-03-31 07:00:00	QQQ	ETF	43.67	43.8	43.63	43.8	304357.0
2008-03-31 08:00:00	QQQ	ETF	43.79	43.8	43.37	43.65	2107264.0
2008-03-31 09:00:00	QQQ	ETF	43.64	43.95	43.55	43.9	20664354.0
2008-03-31 10:00:00	QQQ	ETF	43.9	43.9	43.45	43.65	21366871.0
2008-03-31 11:00:00	QQQ	ETF	43.65	43.86	43.54	43.75	10897242.0
2008-03-31 12:00:00	QQQ	ETF	43.75	43.87	43.63	43.8501	7762626.0
2008-03-31 13:00:00	QQQ	ETF	43.85	44.02	43.83	43.8999	9120016.0
2008-03-31 14:00:00	QQQ	ETF	43.89	43.93	43.64	43.75	10352838.0
2008-03-31 15:00:00	QQQ	ETF	43.74	43.93	43.65	43.78	19139677.0
2008-03-31 16:00:00	QQQ	ETF	43.77	43.7997	43.67	43.78	9595492.0
2008-03-31 17:00:00	QQQ	ETF	43.78	43.78	43.73	43.74	426117.0
2008-03-31 18:00:00	QQQ	ETF	43.74	43.81	43.71	43.78	44511.0
2008-03-31 19:00:00	QQQ	ETF	43.76	43.78	43.74	43.74	16734.0
2008-03-31 07:00:00	IWM	ETF	68.29	68.36	68.29	68.36	900.0
2008-03-31 08:00:00	IWM	ETF	67.8	68.41	67.8	68.25	70400.0
2008-03-31 09:00:00	IWM	ETF	68.2	68.65	67.81	68.55	7140840.0
2008-03-31 10:00:00	IWM	ETF	68.54	68.54	67.94	68.35	6771266.0
2008-03-31 11:00:00	IWM	ETF	68.34	68.74	68.18	68.59	4410457.0
2008-03-31 12:00:00	IWM	ETF	68.58	68.97	68.4	68.95	4843142.0
2008-03-31 13:00:00	IWM	ETF	68.94	69.22	68.86	68.87	7967460.0
2008-03-31 14:00:00	IWM	ETF	68.87	68.99	68.47	68.66	7458315.0
2008-03-31 15:00:00	IWM	ETF	68.65	68.85	68.44	68.54	16981006.0
2008-03-31 16:00:00	IWM	ETF	68.51	68.6	68.17	68.48	6217210.0
2008-03-31 17:00:00	IWM	ETF	68.43	68.48	68.43	68.48	3500.0
2008-03-31 19:00:00	IWM	ETF	68.44	68.49	68.44	68.47	3300.0
2008-03-31 07:00:00	DIA	ETF	121.94	122.18	121.94	122.18	3600.0
2008-03-31 08:00:00	DIA	ETF	122.17	122.17	121.81	121.89	21700.0
2008-03-31 09:00:00	DIA	ETF	121.9	122.42	121.68	122.26	1761219.0
2008-03-31 10:00:00	DIA	ETF	122.25	122.25	121.75	122.22	1303320.0
2008-03-31 11:00:00	DIA	ETF	122.21	122.79	122.11	122.66	1512769.0
2008-03-31 12:00:00	DIA	ETF	122.66	122.87	122.47	122.87	658629.0

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

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