PREVIEW / etf_1hour / 2008-03-27

all etf 1-hour files

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

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-27 04:00:00	SPY	ETF	133.27	133.27	133.27	133.27	100.0
2008-03-27 05:00:00	SPY	ETF	133.52	134.1	133.52	133.95	7600.0
2008-03-27 06:00:00	SPY	ETF	133.95	134.1	133.95	134.05	78400.0
2008-03-27 07:00:00	SPY	ETF	134.02	134.05	133.47	133.75	1428000.0
2008-03-27 08:00:00	SPY	ETF	133.71	134.43	133.47	134.34	7758200.0
2008-03-27 09:00:00	SPY	ETF	134.33	134.34	133.71	134.06	20442692.0
2008-03-27 10:00:00	SPY	ETF	134.06	134.14	132.75	133.22	43478882.0
2008-03-27 11:00:00	SPY	ETF	133.21	133.91	133.03	133.68	25314430.0
2008-03-27 12:00:00	SPY	ETF	133.68	134.44	133.55	133.981	24274783.0
2008-03-27 13:00:00	SPY	ETF	133.98	134.31	133.1	133.31	24844859.0
2008-03-27 14:00:00	SPY	ETF	133.3	134.05	132.95	133.44	28786829.0
2008-03-27 15:00:00	SPY	ETF	133.44	133.9	132.36	132.45	40949677.0
2008-03-27 16:00:00	SPY	ETF	132.56	137.77	132.52	132.85	4526400.0
2008-03-27 17:00:00	SPY	ETF	132.83	132.83	132.73	132.74	131300.0
2008-03-27 18:00:00	SPY	ETF	132.74	132.83	132.68	132.81	24300.0
2008-03-27 19:00:00	SPY	ETF	132.8	132.83	132.64	132.83	15900.0
2008-03-27 05:00:00	QQQ	ETF	44.48	44.6	44.48	44.6	17200.0
2008-03-27 06:00:00	QQQ	ETF	44.56	44.61	44.53	44.56	63223.0
2008-03-27 07:00:00	QQQ	ETF	44.56	44.57	44.27	44.29	2740136.0
2008-03-27 08:00:00	QQQ	ETF	44.29	44.57	44.24	44.51	6165783.0
2008-03-27 09:00:00	QQQ	ETF	44.51	44.51	44.25	44.4025	13361897.0
2008-03-27 10:00:00	QQQ	ETF	44.4	44.41	43.96	44.1	23379817.0
2008-03-27 11:00:00	QQQ	ETF	44.0995	44.41	44.01	44.31	15575651.0
2008-03-27 12:00:00	QQQ	ETF	44.31	44.51	44.25	44.32	14894158.0
2008-03-27 13:00:00	QQQ	ETF	44.32	44.42	44.04	44.12	11167438.0
2008-03-27 14:00:00	QQQ	ETF	44.12	44.25	43.95	44.11	20380640.0
2008-03-27 15:00:00	QQQ	ETF	44.11	44.18	43.71	43.72	24570963.0
2008-03-27 16:00:00	QQQ	ETF	43.72	43.96	43.7	43.95	8218629.0
2008-03-27 17:00:00	QQQ	ETF	43.95	43.95	43.92	43.92	2059769.0
2008-03-27 18:00:00	QQQ	ETF	43.92	43.94	43.89	43.94	115817.0
2008-03-27 19:00:00	QQQ	ETF	43.93	43.95	43.9	43.95	14936.0
2008-03-27 05:00:00	IWM	ETF	70.0	70.16	70.0	70.16	200.0
2008-03-27 06:00:00	IWM	ETF	70.06	70.06	70.06	70.06	500.0
2008-03-27 07:00:00	IWM	ETF	70.0	70.02	69.77	69.9	92300.0
2008-03-27 08:00:00	IWM	ETF	69.83	70.3	69.69	70.19	2135200.0
2008-03-27 09:00:00	IWM	ETF	70.12	70.16	69.36	69.67	6076667.0
2008-03-27 10:00:00	IWM	ETF	69.67	69.74	69.03	69.4	10719837.0
2008-03-27 11:00:00	IWM	ETF	69.41	69.88	69.2	69.7	4887981.0
2008-03-27 12:00:00	IWM	ETF	69.69	70.26	69.6	69.94	8155891.0
2008-03-27 13:00:00	IWM	ETF	69.94	70.09	69.51	69.63	4141019.0
2008-03-27 14:00:00	IWM	ETF	69.62	69.98	69.47	69.68	6114311.0
2008-03-27 15:00:00	IWM	ETF	69.68	69.81	68.97	69.05	11509487.0
2008-03-27 16:00:00	IWM	ETF	69.06	69.99	68.97	69.2	2586300.0
2008-03-27 17:00:00	IWM	ETF	69.08	69.98	69.06	69.12	2887000.0
2008-03-27 19:00:00	IWM	ETF	69.07	69.07	69.01	69.01	13600.0
2008-03-27 07:00:00	DIA	ETF	124.27	124.27	124.07	124.12	12900.0
2008-03-27 08:00:00	DIA	ETF	124.15	124.77	124.08	124.7	69600.0
2008-03-27 09:00:00	DIA	ETF	124.64	124.7	124.17	124.38	2734660.0
2008-03-27 10:00:00	DIA	ETF	124.4	124.47	123.25	123.62	2636525.0
2008-03-27 11:00:00	DIA	ETF	123.61	124.1	123.42	123.87	1421726.0

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

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