PREVIEW / etf_1hour / 2010-06-24

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-06-24.parquet
  size:    160 KB
  rows:    4,899

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-06-24 04:00:00	SPY	ETF	108.65	108.7	108.2	108.4	22596.0
2010-06-24 05:00:00	SPY	ETF	108.41	108.55	108.41	108.49	15800.0
2010-06-24 06:00:00	SPY	ETF	108.49	108.61	108.49	108.56	19400.0
2010-06-24 07:00:00	SPY	ETF	108.54	108.67	108.26	108.39	655828.0
2010-06-24 08:00:00	SPY	ETF	108.39	108.85	108.21	108.63	5668339.0
2010-06-24 09:00:00	SPY	ETF	108.63	108.83	107.87	108.02	26791245.0
2010-06-24 10:00:00	SPY	ETF	108.02	108.58	107.72	108.01	39905294.0
2010-06-24 11:00:00	SPY	ETF	108.01	108.04	107.44	107.93	36948785.0
2010-06-24 12:00:00	SPY	ETF	107.93	108.25	107.67	108.01	19529895.0
2010-06-24 13:00:00	SPY	ETF	108.0001	108.65	107.86	108.57	20257289.0
2010-06-24 14:00:00	SPY	ETF	108.58	108.61	107.57	107.7	25618025.0
2010-06-24 15:00:00	SPY	ETF	107.71	107.9	107.14	107.44	71905630.0
2010-06-24 16:00:00	SPY	ETF	107.44	109.23	107.197	107.78	9831866.0
2010-06-24 17:00:00	SPY	ETF	107.78	109.2206	107.39	107.8	2471459.0
2010-06-24 18:00:00	SPY	ETF	107.8	107.81	107.47	107.68	325776.0
2010-06-24 19:00:00	SPY	ETF	107.68	107.77	107.65	107.76	102848.0
2010-06-24 04:00:00	QQQ	ETF	45.75	45.75	45.6	45.6	400.0
2010-06-24 05:00:00	QQQ	ETF	45.71	45.71	45.71	45.71	500.0
2010-06-24 06:00:00	QQQ	ETF	45.75	45.75	45.7	45.7	44000.0
2010-06-24 07:00:00	QQQ	ETF	45.7	45.74	45.62	45.64	196167.0
2010-06-24 08:00:00	QQQ	ETF	45.66	45.88	45.64	45.8	1600347.0
2010-06-24 09:00:00	QQQ	ETF	45.81	46.05	45.47	45.52	12934828.0
2010-06-24 10:00:00	QQQ	ETF	45.52	45.84	45.42	45.56	17004604.0
2010-06-24 11:00:00	QQQ	ETF	45.56	45.63	45.31	45.561	10430823.0
2010-06-24 12:00:00	QQQ	ETF	45.57	45.7	45.42	45.56	7815703.0
2010-06-24 13:00:00	QQQ	ETF	45.56	45.95	45.5	45.91	15152237.0
2010-06-24 14:00:00	QQQ	ETF	45.91	45.92	45.43	45.485	12710535.0
2010-06-24 15:00:00	QQQ	ETF	45.48	45.56	45.2	45.34	23757972.0
2010-06-24 16:00:00	QQQ	ETF	45.35	46.0743	45.3	45.47	5139021.0
2010-06-24 17:00:00	QQQ	ETF	45.49	45.54	45.47	45.51	39648.0
2010-06-24 18:00:00	QQQ	ETF	45.48	45.5	45.46	45.46	39970.0
2010-06-24 19:00:00	QQQ	ETF	45.46	45.5	45.45	45.5	37300.0
2010-06-24 05:00:00	IWM	ETF	63.99	63.99	63.94	63.94	800.0
2010-06-24 06:00:00	IWM	ETF	63.98	63.98	63.98	63.98	100.0
2010-06-24 07:00:00	IWM	ETF	64.08	64.11	63.82	63.89	270800.0
2010-06-24 08:00:00	IWM	ETF	63.93	64.22	63.72	64.09	1024098.0
2010-06-24 09:00:00	IWM	ETF	64.11	64.33	63.48	63.59	8761623.0
2010-06-24 10:00:00	IWM	ETF	63.6	64.28	63.53	63.82	12477288.0
2010-06-24 11:00:00	IWM	ETF	63.82	64.07	63.39	63.92	7307653.0
2010-06-24 12:00:00	IWM	ETF	63.92	64.17	63.585	63.89	5072556.0
2010-06-24 13:00:00	IWM	ETF	63.885	64.53	63.8	64.5083	11925483.0
2010-06-24 14:00:00	IWM	ETF	64.51	64.52	63.69	63.78	6704515.0
2010-06-24 15:00:00	IWM	ETF	63.77	64.0	63.4	63.53	15205674.0
2010-06-24 16:00:00	IWM	ETF	63.54	64.1994	63.45	63.73	1353982.0
2010-06-24 17:00:00	IWM	ETF	63.71	63.79	63.68	63.79	23947.0
2010-06-24 18:00:00	IWM	ETF	63.79	63.79	63.74	63.74	8566.0
2010-06-24 19:00:00	IWM	ETF	63.76	63.76	63.64	63.64	18826.0
2010-06-24 07:00:00	DIA	ETF	102.53	102.53	102.28	102.31	13450.0
2010-06-24 08:00:00	DIA	ETF	102.35	102.71	102.2	102.57	77950.0
2010-06-24 09:00:00	DIA	ETF	102.59	102.65	101.83	101.96	2316942.0

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

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