PREVIEW / etf_1hour / 2010-11-11

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-11-11.parquet
  size:    170 KB
  rows:    5,203

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-11-11 04:00:00	SPY	ETF	121.2	121.48	121.2	121.48	58996.0
2010-11-11 05:00:00	SPY	ETF	121.4	121.6	121.4	121.6	10950.0
2010-11-11 06:00:00	SPY	ETF	121.62	121.62	121.27	121.33	95200.0
2010-11-11 07:00:00	SPY	ETF	121.31	121.41	121.07	121.13	256620.0
2010-11-11 08:00:00	SPY	ETF	121.27	121.33	121.02	121.02	1692822.0
2010-11-11 09:00:00	SPY	ETF	121.03	121.19	120.68	121.04	24782111.0
2010-11-11 10:00:00	SPY	ETF	121.04	121.42	120.89	121.2	27888417.0
2010-11-11 11:00:00	SPY	ETF	121.21	121.29	120.92	121.21	19325843.0
2010-11-11 12:00:00	SPY	ETF	121.21	121.4	121.16	121.22	11862299.0
2010-11-11 13:00:00	SPY	ETF	121.22	121.58	121.12	121.51	14056105.0
2010-11-11 14:00:00	SPY	ETF	121.5	121.82	121.43	121.5885	13659546.0
2010-11-11 15:00:00	SPY	ETF	121.58	121.69	121.31	121.65	34849855.0
2010-11-11 16:00:00	SPY	ETF	121.65	121.67	120.995	121.53	6035848.0
2010-11-11 17:00:00	SPY	ETF	121.52	121.66	121.52	121.61	1546084.0
2010-11-11 18:00:00	SPY	ETF	121.61	121.66	121.27	121.32	182494.0
2010-11-11 19:00:00	SPY	ETF	121.34	121.58	121.34	121.38	177437.0
2010-11-11 04:00:00	QQQ	ETF	53.12	53.12	53.08	53.08	400.0
2010-11-11 05:00:00	QQQ	ETF	53.08	53.08	53.08	53.08	2000.0
2010-11-11 06:00:00	QQQ	ETF	53.1	53.13	53.05	53.05	12100.0
2010-11-11 07:00:00	QQQ	ETF	53.09	53.11	52.93	52.94	592316.0
2010-11-11 08:00:00	QQQ	ETF	52.95	53.03	52.86	52.89	916597.0
2010-11-11 09:00:00	QQQ	ETF	52.89	52.98	52.66	52.969	19209609.0
2010-11-11 10:00:00	QQQ	ETF	52.96	53.22	52.88	53.17	16614645.0
2010-11-11 11:00:00	QQQ	ETF	53.1799	53.2	52.99	53.16	6375112.0
2010-11-11 12:00:00	QQQ	ETF	53.16	53.33	53.15	53.2462	5323120.0
2010-11-11 13:00:00	QQQ	ETF	53.24	53.45	53.19	53.41	5683515.0
2010-11-11 14:00:00	QQQ	ETF	53.41	53.48	53.34	53.365	5490993.0
2010-11-11 15:00:00	QQQ	ETF	53.36	53.42	53.25	53.4	11311530.0
2010-11-11 16:00:00	QQQ	ETF	53.4	53.45	53.2891	53.4	1801241.0
2010-11-11 17:00:00	QQQ	ETF	53.39	53.45	53.39	53.41	75305.0
2010-11-11 18:00:00	QQQ	ETF	53.43	53.43	53.29	53.32	90216.0
2010-11-11 19:00:00	QQQ	ETF	53.32	53.4	53.32	53.32	37700.0
2010-11-11 04:00:00	IWM	ETF	73.03	73.1	73.03	73.1	300.0
2010-11-11 05:00:00	IWM	ETF	73.24	73.24	73.24	73.24	200.0
2010-11-11 06:00:00	IWM	ETF	73.27	73.27	73.05	73.05	6100.0
2010-11-11 07:00:00	IWM	ETF	73.02	73.1	72.88	72.89	95901.0
2010-11-11 08:00:00	IWM	ETF	72.88	73.5476	72.84	73.5476	713224.0
2010-11-11 09:00:00	IWM	ETF	72.88	72.94	72.46	72.81	7862048.0
2010-11-11 10:00:00	IWM	ETF	72.8	73.16	72.67	73.03	7283691.0
2010-11-11 11:00:00	IWM	ETF	73.03	73.14	72.79	73.09	3992451.0
2010-11-11 12:00:00	IWM	ETF	73.08	73.33	73.025	73.2	3459221.0
2010-11-11 13:00:00	IWM	ETF	73.19	73.49	73.08	73.39	4257843.0
2010-11-11 14:00:00	IWM	ETF	73.39	73.54	73.28	73.44	2571118.0
2010-11-11 15:00:00	IWM	ETF	73.43	73.46	73.105	73.24	7342865.0
2010-11-11 16:00:00	IWM	ETF	73.24	73.5472	72.65	73.18	4308947.0
2010-11-11 17:00:00	IWM	ETF	73.18	73.25	73.18	73.2	16900.0
2010-11-11 18:00:00	IWM	ETF	73.19	73.25	73.17	73.22	2000.0
2010-11-11 19:00:00	IWM	ETF	73.14	73.25	73.14	73.25	800.0
2010-11-11 07:00:00	DIA	ETF	113.22	113.22	112.99	113.05	4954.0
2010-11-11 08:00:00	DIA	ETF	113.04	113.23	112.95	112.95	59622.0

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

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