PREVIEW / etf_1hour / 2008-03-12

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-03-12.parquet
  size:    101 KB
  rows:    3,390

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-12 04:00:00	SPY	ETF	132.41	132.41	132.41	132.41	200.0
2008-03-12 05:00:00	SPY	ETF	133.03	133.04	133.03	133.04	6300.0
2008-03-12 06:00:00	SPY	ETF	133.18	133.36	132.84	132.85	145100.0
2008-03-12 07:00:00	SPY	ETF	132.82	133.03	132.51	132.72	955000.0
2008-03-12 08:00:00	SPY	ETF	132.7	132.97	132.33	132.49	4268000.0
2008-03-12 09:00:00	SPY	ETF	132.48	132.98	132.15	132.4	22696009.0
2008-03-12 10:00:00	SPY	ETF	132.4	133.35	131.93	132.89	33909248.0
2008-03-12 11:00:00	SPY	ETF	132.89	133.77	132.88	132.98	39258507.0
2008-03-12 12:00:00	SPY	ETF	132.99	133.15	132.41	132.64	21247036.0
2008-03-12 13:00:00	SPY	ETF	132.64	132.95	132.13	132.28	21918142.0
2008-03-12 14:00:00	SPY	ETF	132.27	132.74	132.02	132.31	26216955.0
2008-03-12 15:00:00	SPY	ETF	132.31	132.74	131.16	131.31	46703515.0
2008-03-12 16:00:00	SPY	ETF	131.3499	133.0	131.19	131.35	5322000.0
2008-03-12 17:00:00	SPY	ETF	131.35	131.37	131.13	131.21	2085000.0
2008-03-12 18:00:00	SPY	ETF	131.18	131.18	130.84	130.87	182400.0
2008-03-12 19:00:00	SPY	ETF	130.87	130.93	130.86	130.89	52300.0
2008-03-12 04:00:00	QQQ	ETF	42.9	42.9	42.9	42.9	8000.0
2008-03-12 06:00:00	QQQ	ETF	43.25	43.25	43.11	43.11	1500.0
2008-03-12 07:00:00	QQQ	ETF	43.06	43.11	42.95	43.07	545728.0
2008-03-12 08:00:00	QQQ	ETF	43.01	43.06	42.9	42.95	2939699.0
2008-03-12 09:00:00	QQQ	ETF	42.94	43.05	42.77	42.8704	15332238.0
2008-03-12 10:00:00	QQQ	ETF	42.873	43.22	42.73	43.14	26719009.0
2008-03-12 11:00:00	QQQ	ETF	43.13	43.44	43.08	43.1315	24079908.0
2008-03-12 12:00:00	QQQ	ETF	43.14	43.27	43.08	43.14	11787109.0
2008-03-12 13:00:00	QQQ	ETF	43.15	43.29	43.05	43.09	13340694.0
2008-03-12 14:00:00	QQQ	ETF	43.09	43.23	42.97	43.15	15245547.0
2008-03-12 15:00:00	QQQ	ETF	43.15	43.17	42.6	42.69	37282618.0
2008-03-12 16:00:00	QQQ	ETF	42.691	42.8481	42.66	42.8481	8039400.0
2008-03-12 17:00:00	QQQ	ETF	42.71	42.71	42.67	42.68	53282.0
2008-03-12 18:00:00	QQQ	ETF	42.68	42.68	42.58	42.61	63149.0
2008-03-12 19:00:00	QQQ	ETF	42.6	42.62	42.57	42.6	138648.0
2008-03-12 05:00:00	IWM	ETF	67.5	67.5	67.5	67.5	500.0
2008-03-12 07:00:00	IWM	ETF	67.58	67.58	67.4	67.5	81800.0
2008-03-12 08:00:00	IWM	ETF	67.49	67.53	67.09	67.11	430000.0
2008-03-12 09:00:00	IWM	ETF	67.07	67.51	66.78	66.99	7750419.0
2008-03-12 10:00:00	IWM	ETF	66.99	67.48	66.55	67.45	17683708.0
2008-03-12 11:00:00	IWM	ETF	67.45	68.04	67.45	67.76	15501723.0
2008-03-12 12:00:00	IWM	ETF	67.77	67.81	67.41	67.54	6030885.0
2008-03-12 13:00:00	IWM	ETF	67.54	67.84	67.34	67.44	10493234.0
2008-03-12 14:00:00	IWM	ETF	67.43	67.64	67.24	67.4	11004730.0
2008-03-12 15:00:00	IWM	ETF	67.4	67.41	66.5	66.62	20420416.0
2008-03-12 16:00:00	IWM	ETF	66.62	67.28	65.65	66.66	3201600.0
2008-03-12 18:00:00	IWM	ETF	66.59	66.59	66.44	66.44	1300.0
2008-03-12 19:00:00	IWM	ETF	66.42	66.46	66.4	66.46	3500.0
2008-03-12 07:00:00	DIA	ETF	122.08	122.08	121.96	121.96	23400.0
2008-03-12 08:00:00	DIA	ETF	122.04	122.05	121.68	121.85	72500.0
2008-03-12 09:00:00	DIA	ETF	121.8	122.4	121.7	121.84	1901020.0
2008-03-12 10:00:00	DIA	ETF	121.85	122.48	121.55	122.44	2111411.0
2008-03-12 11:00:00	DIA	ETF	122.45	123.21	122.45	122.56	2415280.0
2008-03-12 12:00:00	DIA	ETF	122.59	122.64	122.16	122.35	1367550.0

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

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