PREVIEW / etf_1hour / 2009-11-10

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-11-10.parquet
  size:    144 KB
  rows:    4,461

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-10 04:00:00	SPY	ETF	109.42	109.42	109.37	109.4	2600.0
2009-11-10 05:00:00	SPY	ETF	109.34	109.44	109.17	109.44	20300.0
2009-11-10 06:00:00	SPY	ETF	109.43	109.49	109.35	109.35	4208.0
2009-11-10 07:00:00	SPY	ETF	109.36	109.4	109.23	109.36	217008.0
2009-11-10 08:00:00	SPY	ETF	109.38	109.4	109.22	109.27	1274480.0
2009-11-10 09:00:00	SPY	ETF	109.27	109.82	109.15	109.6	20879711.0
2009-11-10 10:00:00	SPY	ETF	109.6	109.93	109.29	109.33	30351397.0
2009-11-10 11:00:00	SPY	ETF	109.33	109.55	109.13	109.32	28254208.0
2009-11-10 12:00:00	SPY	ETF	109.32	109.37	108.97	109.33	18604357.0
2009-11-10 13:00:00	SPY	ETF	109.33	109.38	109.12	109.33	11758790.0
2009-11-10 14:00:00	SPY	ETF	109.3225	109.66	109.25	109.59	13892958.0
2009-11-10 15:00:00	SPY	ETF	109.5925	109.8	109.4	109.58	25095065.0
2009-11-10 16:00:00	SPY	ETF	109.59	109.84	109.01	109.83	18914449.0
2009-11-10 17:00:00	SPY	ETF	109.82	109.89	109.77	109.85	74303.0
2009-11-10 18:00:00	SPY	ETF	109.83	109.9	109.8	109.88	66929.0
2009-11-10 19:00:00	SPY	ETF	109.9	110.14	109.9	110.05	191412.0
2009-11-10 05:00:00	QQQ	ETF	43.48	43.48	43.48	43.48	100.0
2009-11-10 06:00:00	QQQ	ETF	43.47	43.47	43.47	43.47	100.0
2009-11-10 07:00:00	QQQ	ETF	43.45	43.49	43.39	43.45	70245.0
2009-11-10 08:00:00	QQQ	ETF	43.45	43.46	43.41	43.43	480763.0
2009-11-10 09:00:00	QQQ	ETF	43.42	43.75	43.4	43.6799	12655316.0
2009-11-10 10:00:00	QQQ	ETF	43.68	43.7714	43.46	43.47	13980387.0
2009-11-10 11:00:00	QQQ	ETF	43.4701	43.57	43.4	43.492	8500784.0
2009-11-10 12:00:00	QQQ	ETF	43.492	43.575	43.41	43.5699	7150139.0
2009-11-10 13:00:00	QQQ	ETF	43.57	43.59	43.48	43.5699	6903599.0
2009-11-10 14:00:00	QQQ	ETF	43.57	43.7	43.54	43.68	8842476.0
2009-11-10 15:00:00	QQQ	ETF	43.67	43.7452	43.56	43.61	10518279.0
2009-11-10 16:00:00	QQQ	ETF	43.61	43.68	43.57	43.68	1969035.0
2009-11-10 17:00:00	QQQ	ETF	43.68	43.7	43.67	43.67	76100.0
2009-11-10 18:00:00	QQQ	ETF	43.7	43.72	43.69	43.72	26502.0
2009-11-10 19:00:00	QQQ	ETF	43.72	43.77	43.72	43.77	36430.0
2009-11-10 07:00:00	IWM	ETF	58.98	59.0	58.93	58.99	4300.0
2009-11-10 08:00:00	IWM	ETF	59.03	59.03	58.92	58.97	200121.0
2009-11-10 09:00:00	IWM	ETF	58.96	59.51	58.9	59.31	5720384.0
2009-11-10 10:00:00	IWM	ETF	59.3	59.41	58.78	58.82	10958667.0
2009-11-10 11:00:00	IWM	ETF	58.82	58.9	58.54	58.5803	6709537.0
2009-11-10 12:00:00	IWM	ETF	58.58	58.6795	58.37	58.67	5770415.0
2009-11-10 13:00:00	IWM	ETF	58.67	58.7	58.43	58.54	5739371.0
2009-11-10 14:00:00	IWM	ETF	58.53	58.95	58.48	58.845	6686092.0
2009-11-10 15:00:00	IWM	ETF	58.845	58.94	58.67	58.8	9872338.0
2009-11-10 16:00:00	IWM	ETF	58.8	58.96	58.76	58.94	638058.0
2009-11-10 17:00:00	IWM	ETF	58.9	58.98	58.89	58.94	10399.0
2009-11-10 18:00:00	IWM	ETF	58.95	58.95	58.93	58.93	1398.0
2009-11-10 19:00:00	IWM	ETF	58.97	59.05	58.97	59.05	7100.0
2009-11-10 07:00:00	DIA	ETF	102.28	102.29	102.28	102.28	3200.0
2009-11-10 08:00:00	DIA	ETF	102.24	102.24	102.14	102.2	13600.0
2009-11-10 09:00:00	DIA	ETF	102.2	102.6899	102.09	102.531	1961748.0
2009-11-10 10:00:00	DIA	ETF	102.52	102.8	102.35	102.37	1750247.0
2009-11-10 11:00:00	DIA	ETF	102.36	102.62	102.235	102.4201	1111005.0
2009-11-10 12:00:00	DIA	ETF	102.43	102.4697	102.15	102.395	938412.0

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

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