PREVIEW / etf_1hour / 2009-01-08

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-01-08.parquet
  size:    125 KB
  rows:    3,839

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
2009-01-08 04:00:00	SPY	ETF	90.85	90.94	90.68	90.68	13000.0
2009-01-08 05:00:00	SPY	ETF	90.58	90.58	90.2	90.32	3260.0
2009-01-08 06:00:00	SPY	ETF	90.38	90.74	90.37	90.66	14367.0
2009-01-08 07:00:00	SPY	ETF	90.67	90.93	89.73	89.82	1649281.0
2009-01-08 08:00:00	SPY	ETF	89.83	90.77	89.52	90.06	4705848.0
2009-01-08 09:00:00	SPY	ETF	90.05	90.39	89.7	89.89	25932314.0
2009-01-08 10:00:00	SPY	ETF	89.89	90.68	89.67	90.5	42566338.0
2009-01-08 11:00:00	SPY	ETF	90.51	90.8	89.88	90.01	35190403.0
2009-01-08 12:00:00	SPY	ETF	90.02	90.53	89.97	90.21	18269930.0
2009-01-08 13:00:00	SPY	ETF	90.21	90.21	89.75	90.08	25929077.0
2009-01-08 14:00:00	SPY	ETF	90.08	90.85	89.99	90.7	35211893.0
2009-01-08 15:00:00	SPY	ETF	90.7	91.09	89.78	91.08	55505158.0
2009-01-08 16:00:00	SPY	ETF	91.04	91.06	90.1101	90.95	10120131.0
2009-01-08 17:00:00	SPY	ETF	90.94	91.06	90.93	90.97	136258.0
2009-01-08 18:00:00	SPY	ETF	90.97	91.31	90.94	91.14	171642.0
2009-01-08 19:00:00	SPY	ETF	91.14	91.21	91.1	91.1	39877.0
2009-01-08 04:00:00	QQQ	ETF	30.56	30.56	30.56	30.56	100.0
2009-01-08 05:00:00	QQQ	ETF	30.45	30.45	30.45	30.45	100.0
2009-01-08 06:00:00	QQQ	ETF	30.5	30.5	30.5	30.5	100.0
2009-01-08 07:00:00	QQQ	ETF	30.56	30.65	30.26	30.28	760076.0
2009-01-08 08:00:00	QQQ	ETF	30.3	30.39	30.14	30.33	3863703.0
2009-01-08 09:00:00	QQQ	ETF	30.33	30.44	30.11	30.18	14571922.0
2009-01-08 10:00:00	QQQ	ETF	30.18	30.5	30.08	30.41	18819881.0
2009-01-08 11:00:00	QQQ	ETF	30.42	30.52	30.19	30.25	14265868.0
2009-01-08 12:00:00	QQQ	ETF	30.25	30.42	30.24	30.309	7026946.0
2009-01-08 13:00:00	QQQ	ETF	30.31	30.36	30.16	30.33	8396230.0
2009-01-08 14:00:00	QQQ	ETF	30.33	30.74	30.3101	30.7	22215772.0
2009-01-08 15:00:00	QQQ	ETF	30.691	30.8	30.53	30.7701	29835158.0
2009-01-08 16:00:00	QQQ	ETF	30.78	30.8	30.69	30.71	2042259.0
2009-01-08 17:00:00	QQQ	ETF	30.71	30.76	30.4477	30.74	8870749.0
2009-01-08 18:00:00	QQQ	ETF	30.74	30.78	30.69	30.78	60294.0
2009-01-08 19:00:00	QQQ	ETF	30.78	30.78	30.72	30.74	39290.0
2009-01-08 06:00:00	IWM	ETF	49.76	49.76	49.76	49.76	200.0
2009-01-08 07:00:00	IWM	ETF	49.66	49.87	49.04	49.15	216219.0
2009-01-08 08:00:00	IWM	ETF	49.5	49.5	49.02	49.37	997184.0
2009-01-08 09:00:00	IWM	ETF	49.37	49.7	49.19	49.35	6773190.0
2009-01-08 10:00:00	IWM	ETF	49.35	49.96	49.17	49.87	10651201.0
2009-01-08 11:00:00	IWM	ETF	49.88	50.15	49.48	49.55	7110984.0
2009-01-08 12:00:00	IWM	ETF	49.56	49.81	49.43	49.53	3464618.0
2009-01-08 13:00:00	IWM	ETF	49.53	49.57	49.27	49.52	4672716.0
2009-01-08 14:00:00	IWM	ETF	49.51	49.98	49.36	49.87	6679161.0
2009-01-08 15:00:00	IWM	ETF	49.87	50.14	49.628	50.14	10581940.0
2009-01-08 16:00:00	IWM	ETF	50.14	50.15	49.2226	50.02	5029506.0
2009-01-08 17:00:00	IWM	ETF	49.98	50.06	49.98	50.06	2073.0
2009-01-08 18:00:00	IWM	ETF	50.0	50.05	50.0	50.05	700.0
2009-01-08 19:00:00	IWM	ETF	50.05	50.15	50.05	50.15	1100.0
2009-01-08 06:00:00	DIA	ETF	87.44	87.67	87.44	87.58	300.0
2009-01-08 07:00:00	DIA	ETF	87.66	87.75	86.74	86.74	33972.0
2009-01-08 08:00:00	DIA	ETF	86.85	87.05	86.52	86.99	242469.0
2009-01-08 09:00:00	DIA	ETF	87.01	87.21	86.57	86.74	2940937.0

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

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