PREVIEW / etf_1hour / 2008-04-01

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-04-01.parquet
  size:    104 KB
  rows:    3,471

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-04-01 04:00:00	SPY	ETF	132.52	132.66	132.52	132.66	1500.0
2008-04-01 05:00:00	SPY	ETF	132.63	133.0	132.63	133.0	21600.0
2008-04-01 06:00:00	SPY	ETF	132.94	133.11	132.94	133.0	69300.0
2008-04-01 07:00:00	SPY	ETF	133.06	133.18	132.85	133.07	1321800.0
2008-04-01 08:00:00	SPY	ETF	133.05	133.62	131.97	133.49	3774907.0
2008-04-01 09:00:00	SPY	ETF	133.5	134.19	131.28	134.03	23680775.0
2008-04-01 10:00:00	SPY	ETF	134.06	135.1	134.03	135.04	40257242.0
2008-04-01 11:00:00	SPY	ETF	135.04	135.26	134.81	135.2	19911574.0
2008-04-01 12:00:00	SPY	ETF	135.2	135.7	134.85	135.4	24644642.0
2008-04-01 13:00:00	SPY	ETF	135.39	135.93	135.3	135.56	26395398.0
2008-04-01 14:00:00	SPY	ETF	135.56	136.5	135.35	136.02	38626343.0
2008-04-01 15:00:00	SPY	ETF	136.02	136.84	135.81	136.81	50419630.0
2008-04-01 16:00:00	SPY	ETF	136.781	136.85	133.61	136.7	12794244.0
2008-04-01 17:00:00	SPY	ETF	136.7	136.89	136.61	136.83	9362900.0
2008-04-01 18:00:00	SPY	ETF	136.83	136.83	136.62	136.69	77300.0
2008-04-01 19:00:00	SPY	ETF	136.67	136.74	136.48	136.49	80600.0
2008-04-01 04:00:00	QQQ	ETF	44.03	44.14	44.03	44.14	1800.0
2008-04-01 05:00:00	QQQ	ETF	44.16	44.28	44.16	44.28	3800.0
2008-04-01 06:00:00	QQQ	ETF	44.19	44.22	44.19	44.22	1000.0
2008-04-01 07:00:00	QQQ	ETF	44.27	44.33	44.21	44.3	343685.0
2008-04-01 08:00:00	QQQ	ETF	44.27	44.45	44.24	44.44	3200150.0
2008-04-01 09:00:00	QQQ	ETF	44.43	44.65	44.41	44.56	13243115.0
2008-04-01 10:00:00	QQQ	ETF	44.57	44.9	44.568	44.87	20020833.0
2008-04-01 11:00:00	QQQ	ETF	44.86	45.05	44.86	45.03	13123352.0
2008-04-01 12:00:00	QQQ	ETF	45.03	45.21	45.02	45.0708	11842726.0
2008-04-01 13:00:00	QQQ	ETF	45.08	45.34	45.06	45.24	14388545.0
2008-04-01 14:00:00	QQQ	ETF	45.25	45.51	45.19	45.36	20094121.0
2008-04-01 15:00:00	QQQ	ETF	45.36	45.61	45.32	45.58	26299857.0
2008-04-01 16:00:00	QQQ	ETF	45.59	45.64	45.4885	45.55	8100639.0
2008-04-01 17:00:00	QQQ	ETF	45.53	45.61	45.53	45.61	3384077.0
2008-04-01 18:00:00	QQQ	ETF	45.59	45.59	45.47	45.48	81043.0
2008-04-01 19:00:00	QQQ	ETF	45.5	45.5	45.45	45.48	87454.0
2008-04-01 06:00:00	IWM	ETF	69.03	69.03	69.03	69.03	100.0
2008-04-01 07:00:00	IWM	ETF	69.07	69.2	68.96	69.07	184400.0
2008-04-01 08:00:00	IWM	ETF	69.06	69.43	68.59	69.42	2252500.0
2008-04-01 09:00:00	IWM	ETF	69.4	69.65	68.29	69.51	6610175.0
2008-04-01 10:00:00	IWM	ETF	69.54	70.08	69.54	70.05	10713925.0
2008-04-01 11:00:00	IWM	ETF	70.05	70.17	69.84	70.08	5281053.0
2008-04-01 12:00:00	IWM	ETF	70.08	70.28	69.99	70.08	5836429.0
2008-04-01 13:00:00	IWM	ETF	70.08	70.38	70.05	70.16	4784993.0
2008-04-01 14:00:00	IWM	ETF	70.16	70.61	70.0	70.38	9265511.0
2008-04-01 15:00:00	IWM	ETF	70.37	70.82	70.0	70.79	15613207.0
2008-04-01 16:00:00	IWM	ETF	70.77	70.82	68.51	70.77	4438700.0
2008-04-01 17:00:00	IWM	ETF	70.8	70.87	70.8	70.85	30200.0
2008-04-01 18:00:00	IWM	ETF	70.85	70.85	70.77	70.78	16300.0
2008-04-01 19:00:00	IWM	ETF	70.83	70.83	70.67	70.67	5200.0
2008-04-01 07:00:00	DIA	ETF	123.22	123.35	123.21	123.32	3500.0
2008-04-01 08:00:00	DIA	ETF	123.3	123.78	123.26	123.73	76800.0
2008-04-01 09:00:00	DIA	ETF	123.73	124.42	123.71	124.38	1542229.0
2008-04-01 10:00:00	DIA	ETF	124.39	125.26	124.39	125.21	3962882.0

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

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