PREVIEW / etf_1hour / 2008-01-22

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-01-22.parquet
  size:    108 KB
  rows:    3,591

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-01-22 04:00:00	SPY	ETF	125.74	125.99	125.15	125.97	123700.0
2008-01-22 05:00:00	SPY	ETF	125.9	125.96	125.0	125.78	57300.0
2008-01-22 06:00:00	SPY	ETF	125.86	126.87	125.83	126.5	1059000.0
2008-01-22 07:00:00	SPY	ETF	126.5	126.55	125.29	125.73	6220200.0
2008-01-22 08:00:00	SPY	ETF	125.71	131.3	125.36	126.64	35485018.0
2008-01-22 09:00:00	SPY	ETF	126.57	129.86	126.0	128.53	61224812.0
2008-01-22 10:00:00	SPY	ETF	128.54	132.4266	128.37	130.44	83815166.0
2008-01-22 11:00:00	SPY	ETF	130.403	132.25	129.9	130.13	57998041.0
2008-01-22 12:00:00	SPY	ETF	130.13	131.28	129.98	131.14	26206090.0
2008-01-22 13:00:00	SPY	ETF	131.15	132.4266	130.3	130.75	52515974.0
2008-01-22 14:00:00	SPY	ETF	130.76	131.59	130.07	130.84	34590730.0
2008-01-22 15:00:00	SPY	ETF	130.85	132.4266	130.6	131.02	59457701.0
2008-01-22 16:00:00	SPY	ETF	130.97	131.75	129.2396	129.89	9372700.0
2008-01-22 17:00:00	SPY	ETF	129.84	131.04	129.73	129.88	590600.0
2008-01-22 18:00:00	SPY	ETF	129.88	130.72	129.82	130.35	131700.0
2008-01-22 19:00:00	SPY	ETF	130.35	130.52	130.24	130.42	52300.0
2008-01-22 04:00:00	QQQ	ETF	43.04	43.11	42.77	43.1	143875.0
2008-01-22 05:00:00	QQQ	ETF	43.17	43.25	42.89	43.02	32900.0
2008-01-22 06:00:00	QQQ	ETF	43.18	43.66	43.18	43.48	210737.0
2008-01-22 07:00:00	QQQ	ETF	43.5	43.53	43.11	43.29	2292700.0
2008-01-22 08:00:00	QQQ	ETF	43.32	44.58	43.0	43.31	18782055.0
2008-01-22 09:00:00	QQQ	ETF	43.3	45.5	42.73	43.82	56953267.0
2008-01-22 10:00:00	QQQ	ETF	43.82	44.45	43.7	44.09	57066086.0
2008-01-22 11:00:00	QQQ	ETF	44.1	44.67	43.9	44.01	46636531.0
2008-01-22 12:00:00	QQQ	ETF	44.01	44.45	43.95	44.3399	29249837.0
2008-01-22 13:00:00	QQQ	ETF	44.34	44.65	44.15	44.29	32403601.0
2008-01-22 14:00:00	QQQ	ETF	44.28	44.44	44.05	44.31	20825405.0
2008-01-22 15:00:00	QQQ	ETF	44.31	44.77	44.12	44.21	41595339.0
2008-01-22 16:00:00	QQQ	ETF	44.21	45.3386	43.28	43.46	17067717.0
2008-01-22 17:00:00	QQQ	ETF	43.45	45.3386	43.43	43.53	2861010.0
2008-01-22 18:00:00	QQQ	ETF	43.54	44.42	42.93	43.67	219455.0
2008-01-22 19:00:00	QQQ	ETF	43.67	43.72	43.62	43.67	110411.0
2008-01-22 20:00:00	QQQ	ETF	44.18	44.18	44.18	44.18	43583.0
2008-01-22 04:00:00	IWM	ETF	63.39	63.39	63.39	63.39	100.0
2008-01-22 05:00:00	IWM	ETF	63.39	63.39	63.39	63.39	400.0
2008-01-22 06:00:00	IWM	ETF	64.2	64.2	64.15	64.15	153500.0
2008-01-22 07:00:00	IWM	ETF	64.2	64.26	63.7	63.92	530000.0
2008-01-22 08:00:00	IWM	ETF	63.89	66.79	63.7	64.5	4356121.0
2008-01-22 09:00:00	IWM	ETF	64.55	66.76	64.19	65.81	24205334.0
2008-01-22 10:00:00	IWM	ETF	65.81	67.21	65.07	66.93	31257372.0
2008-01-22 11:00:00	IWM	ETF	66.94	68.13	66.61	66.89	24426970.0
2008-01-22 12:00:00	IWM	ETF	66.89	67.62	66.83	67.15	10107605.0
2008-01-22 13:00:00	IWM	ETF	67.15	67.69	66.81	67.05	18163885.0
2008-01-22 14:00:00	IWM	ETF	67.04	67.58	66.59	66.95	8969886.0
2008-01-22 15:00:00	IWM	ETF	66.95	67.75	66.74	66.95	20765006.0
2008-01-22 16:00:00	IWM	ETF	66.95	67.3	66.12	66.22	4040200.0
2008-01-22 17:00:00	IWM	ETF	66.16	67.03	66.15	66.29	4067800.0
2008-01-22 18:00:00	IWM	ETF	66.31	66.41	66.31	66.41	2700.0
2008-01-22 19:00:00	IWM	ETF	66.47	66.47	66.41	66.45	11600.0
2008-01-22 20:00:00	IWM	ETF	66.96	66.96	66.96	66.96	5400.0

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

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