PREVIEW / etf_1hour / 2012-03-23

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-03-23.parquet
  size:    179 KB
  rows:    5,528

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
2012-03-23 04:00:00	SPY	ETF	139.48	139.97	139.48	139.8	47066.0
2012-03-23 05:00:00	SPY	ETF	139.94	139.95	139.4	139.41	40000.0
2012-03-23 06:00:00	SPY	ETF	139.46	139.46	139.31	139.4	35850.0
2012-03-23 07:00:00	SPY	ETF	139.41	139.57	139.09	139.09	1131295.0
2012-03-23 08:00:00	SPY	ETF	139.11	139.475	139.05	139.36	2066929.0
2012-03-23 09:00:00	SPY	ETF	139.36	139.37	138.97	139.11	13063154.0
2012-03-23 10:00:00	SPY	ETF	139.1	139.23	138.55	139.16	27162376.0
2012-03-23 11:00:00	SPY	ETF	139.16	139.6	139.06	139.55	16935093.0
2012-03-23 12:00:00	SPY	ETF	139.55	139.68	139.33	139.6	9643157.0
2012-03-23 13:00:00	SPY	ETF	139.6	139.75	139.5	139.53	8747402.0
2012-03-23 14:00:00	SPY	ETF	139.53	139.81	139.5199	139.68	8592614.0
2012-03-23 15:00:00	SPY	ETF	139.68	139.75	139.55	139.65	22827209.0
2012-03-23 16:00:00	SPY	ETF	139.66	139.9375	139.0	139.88	7014658.0
2012-03-23 17:00:00	SPY	ETF	139.87	139.91	139.83	139.89	175522.0
2012-03-23 18:00:00	SPY	ETF	139.89	139.91	139.81	139.87	83127.0
2012-03-23 19:00:00	SPY	ETF	139.88	139.88	139.81	139.82	37722.0
2012-03-23 04:00:00	QQQ	ETF	67.39	67.39	67.39	67.39	200.0
2012-03-23 05:00:00	QQQ	ETF	67.26	67.26	67.18	67.18	850.0
2012-03-23 06:00:00	QQQ	ETF	67.19	67.19	67.11	67.13	2200.0
2012-03-23 07:00:00	QQQ	ETF	67.16	67.16	67.05	67.09	356398.0
2012-03-23 08:00:00	QQQ	ETF	67.04	67.38	67.01	67.12	503013.0
2012-03-23 09:00:00	QQQ	ETF	67.1	67.11	66.81	66.85	4707623.0
2012-03-23 10:00:00	QQQ	ETF	66.84	66.845	66.56	66.78	9750304.0
2012-03-23 11:00:00	QQQ	ETF	66.79	66.95	66.7	66.9	5878521.0
2012-03-23 12:00:00	QQQ	ETF	66.9	66.91	66.76	66.8222	2913960.0
2012-03-23 13:00:00	QQQ	ETF	66.83	66.91	66.78	66.8475	4556284.0
2012-03-23 14:00:00	QQQ	ETF	66.85	67.03	66.84	66.95	3383603.0
2012-03-23 15:00:00	QQQ	ETF	66.955	66.97	66.88	66.94	6864890.0
2012-03-23 16:00:00	QQQ	ETF	66.94	67.03	66.92	66.99	1061789.0
2012-03-23 17:00:00	QQQ	ETF	67.01	67.04	66.97	66.99	13490.0
2012-03-23 18:00:00	QQQ	ETF	66.99	67.05	66.99	67.04	8576.0
2012-03-23 19:00:00	QQQ	ETF	67.02	67.02	66.98	66.99	1210.0
2012-03-23 04:00:00	IWM	ETF	82.42	82.49	82.42	82.49	3690.0
2012-03-23 05:00:00	IWM	ETF	82.26	82.26	82.12	82.12	1228.0
2012-03-23 06:00:00	IWM	ETF	82.14	82.14	82.14	82.14	182.0
2012-03-23 07:00:00	IWM	ETF	81.94	81.94	81.58	81.8	35233.0
2012-03-23 08:00:00	IWM	ETF	81.78	81.95	81.76	81.94	154897.0
2012-03-23 09:00:00	IWM	ETF	81.91	82.05	81.67	81.75	4673118.0
2012-03-23 10:00:00	IWM	ETF	81.74	81.89	81.25	81.86	7999865.0
2012-03-23 11:00:00	IWM	ETF	81.87	82.17	81.7628	82.12	4192678.0
2012-03-23 12:00:00	IWM	ETF	82.12	82.27	81.95	82.18	3384566.0
2012-03-23 13:00:00	IWM	ETF	82.19	82.51	82.17	82.355	5220672.0
2012-03-23 14:00:00	IWM	ETF	82.36	82.77	82.3498	82.64	5159703.0
2012-03-23 15:00:00	IWM	ETF	82.65	82.79	82.48	82.7	9841936.0
2012-03-23 16:00:00	IWM	ETF	82.72	82.99	81.7176	82.86	1840671.0
2012-03-23 17:00:00	IWM	ETF	82.87	82.88	82.83	82.83	12775.0
2012-03-23 18:00:00	IWM	ETF	82.91	82.91	82.91	82.91	9997.0
2012-03-23 19:00:00	IWM	ETF	82.83	82.83	82.83	82.83	400.0
2012-03-23 04:00:00	DIA	ETF	130.72	130.72	130.6	130.6	2200.0
2012-03-23 05:00:00	DIA	ETF	130.46	130.46	130.46	130.46	200.0

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

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