PREVIEW / etf_1hour / 2009-11-09

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-11-09.parquet
  size:    149 KB
  rows:    4,568

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-11-09 04:00:00	SPY	ETF	107.83	108.1	107.81	108.08	14428.0
2009-11-09 05:00:00	SPY	ETF	108.02	108.02	107.97	107.97	1100.0
2009-11-09 06:00:00	SPY	ETF	108.14	108.3	108.05	108.11	21367.0
2009-11-09 07:00:00	SPY	ETF	108.1	108.23	108.04	108.17	332482.0
2009-11-09 08:00:00	SPY	ETF	108.16	108.16	107.0	108.02	1040385.0
2009-11-09 09:00:00	SPY	ETF	108.03	108.33	107.87	108.26	24784553.0
2009-11-09 10:00:00	SPY	ETF	108.27	108.7	108.255	108.65	25041815.0
2009-11-09 11:00:00	SPY	ETF	108.65	108.91	108.52	108.795	19668886.0
2009-11-09 12:00:00	SPY	ETF	108.8	108.99	108.75	108.99	9826711.0
2009-11-09 13:00:00	SPY	ETF	108.98	109.22	108.88	109.17	13406718.0
2009-11-09 14:00:00	SPY	ETF	109.16	109.41	109.08	109.35	15629615.0
2009-11-09 15:00:00	SPY	ETF	109.36	109.62	109.19	109.58	31864688.0
2009-11-09 16:00:00	SPY	ETF	109.58	109.68	107.1653	109.59	9917422.0
2009-11-09 17:00:00	SPY	ETF	107.1653	109.6	107.1653	109.55	7411944.0
2009-11-09 18:00:00	SPY	ETF	109.56	109.62	109.55	109.58	155031.0
2009-11-09 19:00:00	SPY	ETF	109.58	109.64	109.58	109.64	10655.0
2009-11-09 04:00:00	QQQ	ETF	42.9	42.94	42.9	42.94	200.0
2009-11-09 05:00:00	QQQ	ETF	42.89	42.89	42.89	42.89	100.0
2009-11-09 06:00:00	QQQ	ETF	42.97	43.02	42.97	43.01	25465.0
2009-11-09 07:00:00	QQQ	ETF	42.99	43.02	42.96	43.0	125868.0
2009-11-09 08:00:00	QQQ	ETF	43.0	43.02	41.5	42.99	747557.0
2009-11-09 09:00:00	QQQ	ETF	42.99	43.15	42.88	43.115	16072298.0
2009-11-09 10:00:00	QQQ	ETF	43.11	43.29	43.11	43.2682	16605111.0
2009-11-09 11:00:00	QQQ	ETF	43.27	43.33	43.16	43.27	13132829.0
2009-11-09 12:00:00	QQQ	ETF	43.2717	43.34	43.25	43.31	5428577.0
2009-11-09 13:00:00	QQQ	ETF	43.31	43.42	43.28	43.35	5504795.0
2009-11-09 14:00:00	QQQ	ETF	43.35	43.45	43.31	43.43	5737703.0
2009-11-09 15:00:00	QQQ	ETF	43.43	43.52	43.35	43.51	13957370.0
2009-11-09 16:00:00	QQQ	ETF	43.5	43.53	42.5891	43.5	13378914.0
2009-11-09 17:00:00	QQQ	ETF	43.5	43.5	43.47	43.49	85642.0
2009-11-09 18:00:00	QQQ	ETF	43.48	43.51	43.48	43.49	40823.0
2009-11-09 19:00:00	QQQ	ETF	43.49	43.51	43.48	43.5	20909.0
2009-11-09 20:00:00	QQQ	ETF	43.48	43.48	43.48	43.48	554.0
2009-11-09 06:00:00	IWM	ETF	58.39	58.84	58.39	58.84	3301.0
2009-11-09 07:00:00	IWM	ETF	58.7	58.8	58.7	58.73	28550.0
2009-11-09 08:00:00	IWM	ETF	58.73	58.85	58.09	58.74	113861.0
2009-11-09 09:00:00	IWM	ETF	58.74	59.07	58.09	58.93	11990863.0
2009-11-09 10:00:00	IWM	ETF	58.93	59.23	58.925	59.1699	6637422.0
2009-11-09 11:00:00	IWM	ETF	59.17	59.18	58.8999	58.98	7229512.0
2009-11-09 12:00:00	IWM	ETF	58.97	59.08	58.931	59.08	2365021.0
2009-11-09 13:00:00	IWM	ETF	59.08	59.19	59.0	59.11	2755486.0
2009-11-09 14:00:00	IWM	ETF	59.11	59.27	59.055	59.22	3261995.0
2009-11-09 15:00:00	IWM	ETF	59.2175	59.26	58.98	59.23	7146032.0
2009-11-09 16:00:00	IWM	ETF	59.24	59.24	58.0968	59.06	3412272.0
2009-11-09 17:00:00	IWM	ETF	59.04	59.13	59.03	59.07	16704.0
2009-11-09 18:00:00	IWM	ETF	59.08	59.15	59.03	59.15	3700.0
2009-11-09 19:00:00	IWM	ETF	59.15	59.19	59.15	59.17	6963.0
2009-11-09 05:00:00	DIA	ETF	101.0	101.1	101.0	101.1	200.0
2009-11-09 06:00:00	DIA	ETF	100.1	101.0	100.1	101.0	200.0
2009-11-09 07:00:00	DIA	ETF	101.25	101.27	101.17	101.17	11098.0

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

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