PREVIEW / etf_1hour / 2009-04-17

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-04-17.parquet
  size:    132 KB
  rows:    4,134

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-04-17 04:00:00	SPY	ETF	86.1	86.18	86.1	86.18	1100.0
2009-04-17 05:00:00	SPY	ETF	86.05	86.53	85.98	86.42	20101.0
2009-04-17 06:00:00	SPY	ETF	86.29	86.84	86.29	86.75	262019.0
2009-04-17 07:00:00	SPY	ETF	86.8	87.05	86.51	86.88	685892.0
2009-04-17 08:00:00	SPY	ETF	86.87	86.96	85.9	86.39	3409563.0
2009-04-17 09:00:00	SPY	ETF	86.4	87.1	86.31	86.58	37986225.0
2009-04-17 10:00:00	SPY	ETF	86.59	86.88	86.14	86.39	30264844.0
2009-04-17 11:00:00	SPY	ETF	86.38	86.9	86.21	86.74	24662218.0
2009-04-17 12:00:00	SPY	ETF	86.74	86.96	86.56	86.93	19971861.0
2009-04-17 13:00:00	SPY	ETF	86.93	87.46	86.88	87.38	24130458.0
2009-04-17 14:00:00	SPY	ETF	87.38	87.63	87.05	87.12	28068730.0
2009-04-17 15:00:00	SPY	ETF	87.11	87.65	86.95	87.13	61141324.0
2009-04-17 16:00:00	SPY	ETF	87.09	87.45	86.6185	87.1	15431035.0
2009-04-17 17:00:00	SPY	ETF	87.1	87.2	87.08	87.17	2270216.0
2009-04-17 18:00:00	SPY	ETF	87.16	87.2	86.6185	87.17	4019335.0
2009-04-17 19:00:00	SPY	ETF	87.14	87.25	87.11	87.25	48244.0
2009-04-17 04:00:00	QQQ	ETF	32.96	32.97	32.96	32.97	425.0
2009-04-17 05:00:00	QQQ	ETF	32.99	32.99	32.99	32.99	2000.0
2009-04-17 06:00:00	QQQ	ETF	33.08	33.2	33.04	33.16	31300.0
2009-04-17 07:00:00	QQQ	ETF	33.18	33.24	33.07	33.24	330433.0
2009-04-17 08:00:00	QQQ	ETF	33.24	33.27	32.97	33.05	467489.0
2009-04-17 09:00:00	QQQ	ETF	33.05	33.2	32.95	33.1199	25638932.0
2009-04-17 10:00:00	QQQ	ETF	33.1199	33.22	32.93	32.97	17449151.0
2009-04-17 11:00:00	QQQ	ETF	32.97	33.12	32.93	33.07	9110992.0
2009-04-17 12:00:00	QQQ	ETF	33.08	33.19	32.99	33.18	9113741.0
2009-04-17 13:00:00	QQQ	ETF	33.18	33.41	33.17	33.4	19360046.0
2009-04-17 14:00:00	QQQ	ETF	33.41	33.5	33.11	33.294	14515566.0
2009-04-17 15:00:00	QQQ	ETF	33.29	33.45	33.2675	33.31	20862005.0
2009-04-17 16:00:00	QQQ	ETF	33.3	33.39	33.1	33.38	3214452.0
2009-04-17 17:00:00	QQQ	ETF	33.38	33.4	33.2799	33.35	653280.0
2009-04-17 18:00:00	QQQ	ETF	33.38	33.38	33.35	33.37	24026.0
2009-04-17 19:00:00	QQQ	ETF	33.35	33.39	33.35	33.37	14320.0
2009-04-17 06:00:00	IWM	ETF	47.21	47.21	47.2	47.2	1500.0
2009-04-17 07:00:00	IWM	ETF	47.32	47.39	47.16	47.39	31900.0
2009-04-17 08:00:00	IWM	ETF	47.36	47.5	46.8	47.15	162695.0
2009-04-17 09:00:00	IWM	ETF	47.19	47.5	46.92	47.19	7717530.0
2009-04-17 10:00:00	IWM	ETF	47.19	47.52	47.1	47.24	7567959.0
2009-04-17 11:00:00	IWM	ETF	47.24	47.54	47.14	47.45	4398012.0
2009-04-17 12:00:00	IWM	ETF	47.45	47.69	47.3207	47.62	2698944.0
2009-04-17 13:00:00	IWM	ETF	47.62	48.15	47.0	48.09	4350741.0
2009-04-17 14:00:00	IWM	ETF	48.09	48.27	47.78	47.81	6884258.0
2009-04-17 15:00:00	IWM	ETF	47.81	48.15	47.79	47.84	11461358.0
2009-04-17 16:00:00	IWM	ETF	47.83	48.1	47.62	47.67	2611443.0
2009-04-17 17:00:00	IWM	ETF	47.67	47.73	47.3735	47.65	1012348.0
2009-04-17 19:00:00	IWM	ETF	47.72	47.72	47.63	47.63	800.0
2009-04-17 05:00:00	DIA	ETF	80.44	80.44	80.44	80.44	500.0
2009-04-17 06:00:00	DIA	ETF	80.93	81.33	80.93	81.2	10500.0
2009-04-17 07:00:00	DIA	ETF	81.34	81.45	81.09	81.43	47099.0
2009-04-17 08:00:00	DIA	ETF	81.39	81.45	81.0	81.0	48616.0
2009-04-17 09:00:00	DIA	ETF	81.0	81.56	81.0	81.31	2678236.0

> showing 50 of 4,134 rows — these rows as CSV

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