PREVIEW / etf_1hour / 2010-05-14

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-05-14.parquet
  size:    168 KB
  rows:    5,094

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-05-14 04:00:00	SPY	ETF	115.75	115.75	115.44	115.44	640.0
2010-05-14 05:00:00	SPY	ETF	115.47	115.47	115.08	115.08	32470.0
2010-05-14 06:00:00	SPY	ETF	115.2	115.4	115.1	115.38	46752.0
2010-05-14 07:00:00	SPY	ETF	115.42	115.54	115.25	115.27	987646.0
2010-05-14 08:00:00	SPY	ETF	115.26	115.48	114.91	115.25	6788417.0
2010-05-14 09:00:00	SPY	ETF	115.24	115.33	113.98	114.24	53757230.0
2010-05-14 10:00:00	SPY	ETF	114.23	114.68	113.73	114.1795	44931109.0
2010-05-14 11:00:00	SPY	ETF	114.17	114.19	113.07	113.38	56752829.0
2010-05-14 12:00:00	SPY	ETF	113.38	113.83	112.87	113.77	33821884.0
2010-05-14 13:00:00	SPY	ETF	113.77	113.94	113.19	113.46	28434060.0
2010-05-14 14:00:00	SPY	ETF	113.46	113.64	112.95	113.29	36217930.0
2010-05-14 15:00:00	SPY	ETF	113.28	114.12	112.91	113.9	62788538.0
2010-05-14 16:00:00	SPY	ETF	113.9	116.0329	113.13	114.01	18789137.0
2010-05-14 17:00:00	SPY	ETF	114.0	114.04	113.79	113.9	540739.0
2010-05-14 18:00:00	SPY	ETF	113.85	114.04	113.83	113.97	35120.0
2010-05-14 19:00:00	SPY	ETF	113.91	113.99	113.86	113.95	30434.0
2010-05-14 04:00:00	QQQ	ETF	47.79	47.79	47.74	47.74	3700.0
2010-05-14 05:00:00	QQQ	ETF	47.65	47.65	47.6	47.6	20900.0
2010-05-14 06:00:00	QQQ	ETF	47.63	47.63	47.57	47.57	400.0
2010-05-14 07:00:00	QQQ	ETF	47.7	47.72	47.62	47.64	69239.0
2010-05-14 08:00:00	QQQ	ETF	47.63	47.65	47.45	47.57	3780536.0
2010-05-14 09:00:00	QQQ	ETF	47.56	47.58	46.82	46.85	27056612.0
2010-05-14 10:00:00	QQQ	ETF	46.86	47.14	46.72	46.97	16321936.0
2010-05-14 11:00:00	QQQ	ETF	46.96	46.96	46.48	46.55	21445178.0
2010-05-14 12:00:00	QQQ	ETF	46.55	46.75	46.38	46.74	17721803.0
2010-05-14 13:00:00	QQQ	ETF	46.74	46.79	46.5	46.58	16509142.0
2010-05-14 14:00:00	QQQ	ETF	46.58	46.79	46.45	46.63	8955006.0
2010-05-14 15:00:00	QQQ	ETF	46.62	47.06	46.4734	46.94	23999970.0
2010-05-14 16:00:00	QQQ	ETF	46.94	47.08	46.5748	47.01	6935166.0
2010-05-14 17:00:00	QQQ	ETF	47.03	47.1	46.87	46.97	129029.0
2010-05-14 18:00:00	QQQ	ETF	46.97	46.99	46.93	46.96	39500.0
2010-05-14 19:00:00	QQQ	ETF	46.97	46.97	46.86	46.9	12337.0
2010-05-14 04:00:00	IWM	ETF	70.81	70.81	70.81	70.81	100.0
2010-05-14 05:00:00	IWM	ETF	70.77	70.85	70.61	70.61	2800.0
2010-05-14 06:00:00	IWM	ETF	70.69	70.69	70.57	70.69	8599.0
2010-05-14 07:00:00	IWM	ETF	70.71	70.82	70.58	70.62	110998.0
2010-05-14 08:00:00	IWM	ETF	70.61	70.75	70.39	70.61	1292632.0
2010-05-14 09:00:00	IWM	ETF	70.61	70.61	69.48	69.73	16054690.0
2010-05-14 10:00:00	IWM	ETF	69.73	70.01	69.4	69.6317	13358141.0
2010-05-14 11:00:00	IWM	ETF	69.63	69.64	68.92	69.07	12406763.0
2010-05-14 12:00:00	IWM	ETF	69.07	69.35	68.75	69.32	7280371.0
2010-05-14 13:00:00	IWM	ETF	69.325	69.44	69.02	69.18	5458671.0
2010-05-14 14:00:00	IWM	ETF	69.19	69.25	68.82	68.93	6074690.0
2010-05-14 15:00:00	IWM	ETF	68.92	69.6	68.62	69.53	17885488.0
2010-05-14 16:00:00	IWM	ETF	69.53	69.77	68.866	69.65	3012045.0
2010-05-14 17:00:00	IWM	ETF	69.65	69.71	69.55	69.69	46503.0
2010-05-14 18:00:00	IWM	ETF	69.67	69.71	69.56	69.6	7446.0
2010-05-14 19:00:00	IWM	ETF	69.68	69.68	69.61	69.61	600.0
2010-05-14 06:00:00	DIA	ETF	107.6	107.6	107.5	107.5	200.0
2010-05-14 07:00:00	DIA	ETF	107.64	107.71	107.57	107.57	17750.0

> showing 50 of 5,094 rows — these rows as CSV

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