PREVIEW / etf_1hour / 2010-01-22

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-01-22.parquet
  size:    161 KB
  rows:    4,909

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
2010-01-22 04:00:00	SPY	ETF	111.85	111.96	111.85	111.88	4850.0
2010-01-22 05:00:00	SPY	ETF	111.92	111.92	111.64	111.64	14100.0
2010-01-22 06:00:00	SPY	ETF	111.74	111.74	110.98	111.1	128400.0
2010-01-22 07:00:00	SPY	ETF	111.15	111.46	111.14	111.35	875507.0
2010-01-22 08:00:00	SPY	ETF	111.34	111.54	111.1	111.11	4376493.0
2010-01-22 09:00:00	SPY	ETF	111.11	111.62	111.01	111.33	43682464.0
2010-01-22 10:00:00	SPY	ETF	111.33	111.43	110.55	111.35	55489025.0
2010-01-22 11:00:00	SPY	ETF	111.36	111.61	110.9333	111.19	34623362.0
2010-01-22 12:00:00	SPY	ETF	111.18	111.44	111.0	111.08	22329200.0
2010-01-22 13:00:00	SPY	ETF	111.0897	111.13	110.59	110.74	25768065.0
2010-01-22 14:00:00	SPY	ETF	110.7495	110.88	109.5	110.05	36881581.0
2010-01-22 15:00:00	SPY	ETF	110.05	110.28	109.09	109.22	95848701.0
2010-01-22 16:00:00	SPY	ETF	109.23	111.7416	109.16	109.45	22591901.0
2010-01-22 17:00:00	SPY	ETF	109.45	109.45	109.13	109.26	898366.0
2010-01-22 18:00:00	SPY	ETF	109.26	109.47	109.22	109.37	269161.0
2010-01-22 19:00:00	SPY	ETF	109.32	109.38	109.22	109.27	45959.0
2010-01-22 04:00:00	QQQ	ETF	45.41	45.45	45.41	45.45	715.0
2010-01-22 05:00:00	QQQ	ETF	45.41	45.43	45.35	45.37	6555.0
2010-01-22 06:00:00	QQQ	ETF	45.39	45.39	45.17	45.22	70125.0
2010-01-22 07:00:00	QQQ	ETF	45.26	45.37	45.25	45.33	160483.0
2010-01-22 08:00:00	QQQ	ETF	45.34	45.48	45.3	45.35	998246.0
2010-01-22 09:00:00	QQQ	ETF	45.35	45.48	45.18	45.32	20447902.0
2010-01-22 10:00:00	QQQ	ETF	45.32	45.3299	44.9	45.09	28840073.0
2010-01-22 11:00:00	QQQ	ETF	45.08	45.28	45.04	45.1	18978913.0
2010-01-22 12:00:00	QQQ	ETF	45.09	45.17	45.03	45.05	11059564.0
2010-01-22 13:00:00	QQQ	ETF	45.06	45.07	44.87	44.932	10966920.0
2010-01-22 14:00:00	QQQ	ETF	44.9399	44.99	44.44	44.49	26893235.0
2010-01-22 15:00:00	QQQ	ETF	44.48	44.61	44.04	44.16	43339750.0
2010-01-22 16:00:00	QQQ	ETF	44.16	45.4986	44.09	44.22	5052236.0
2010-01-22 17:00:00	QQQ	ETF	44.2	44.24	44.15	44.18	147188.0
2010-01-22 18:00:00	QQQ	ETF	44.19	44.21	44.14	44.17	64758.0
2010-01-22 19:00:00	QQQ	ETF	44.17	44.17	44.12	44.12	12014.0
2010-01-22 06:00:00	IWM	ETF	62.63	62.63	62.63	62.63	250.0
2010-01-22 07:00:00	IWM	ETF	62.7	62.85	62.66	62.79	43857.0
2010-01-22 08:00:00	IWM	ETF	62.75	62.88	62.62	62.62	979422.0
2010-01-22 09:00:00	IWM	ETF	62.65	62.89	62.49	62.7299	8339677.0
2010-01-22 10:00:00	IWM	ETF	62.72	62.86	62.211	62.77	11840363.0
2010-01-22 11:00:00	IWM	ETF	62.805	63.06	62.69	62.74	7973931.0
2010-01-22 12:00:00	IWM	ETF	62.73	63.0	62.64	62.84	4581149.0
2010-01-22 13:00:00	IWM	ETF	62.84	62.8425	62.501	62.59	5806932.0
2010-01-22 14:00:00	IWM	ETF	62.59	62.65	62.12	62.12	9260408.0
2010-01-22 15:00:00	IWM	ETF	62.13	62.3	61.18	61.63	26995678.0
2010-01-22 16:00:00	IWM	ETF	61.63	62.8168	61.6	61.83	4381194.0
2010-01-22 17:00:00	IWM	ETF	61.81	61.87	61.61	61.66	1251239.0
2010-01-22 18:00:00	IWM	ETF	61.66	61.75	61.64	61.69	7604.0
2010-01-22 19:00:00	IWM	ETF	61.65	61.67	61.64	61.67	3900.0
2010-01-22 07:00:00	DIA	ETF	103.51	103.53	103.51	103.53	1500.0
2010-01-22 08:00:00	DIA	ETF	103.55	103.7	103.33	103.33	52210.0
2010-01-22 09:00:00	DIA	ETF	103.42	103.7	103.09	103.55	5050403.0
2010-01-22 10:00:00	DIA	ETF	103.55	103.72	102.9205	103.65	4618589.0

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

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