PREVIEW / etf_1hour / 2012-05-24

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-05-24.parquet
  size:    183 KB
  rows:    5,690

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-05-24 04:00:00	SPY	ETF	131.53	131.99	131.39	131.98	18200.0
2012-05-24 05:00:00	SPY	ETF	131.93	132.57	131.91	132.56	38861.0
2012-05-24 06:00:00	SPY	ETF	132.58	132.9	132.58	132.74	190608.0
2012-05-24 07:00:00	SPY	ETF	132.74	132.75	132.36	132.39	580203.0
2012-05-24 08:00:00	SPY	ETF	132.43	132.82	132.2	132.78	2313729.0
2012-05-24 09:00:00	SPY	ETF	132.78	132.9	131.36	132.17	22884209.0
2012-05-24 10:00:00	SPY	ETF	132.16	132.84	131.99	132.46	27095789.0
2012-05-24 11:00:00	SPY	ETF	132.47	132.83	132.1	132.19	17047057.0
2012-05-24 12:00:00	SPY	ETF	132.18	132.23	131.74	131.94	17549638.0
2012-05-24 13:00:00	SPY	ETF	131.94	132.19	131.45	131.46	18189184.0
2012-05-24 14:00:00	SPY	ETF	131.46	131.94	131.42	131.58	20920406.0
2012-05-24 15:00:00	SPY	ETF	131.58	132.51	131.53	132.5	29029861.0
2012-05-24 16:00:00	SPY	ETF	132.5	133.03	132.2066	132.94	10776770.0
2012-05-24 17:00:00	SPY	ETF	132.96	132.96	132.81	132.88	175416.0
2012-05-24 18:00:00	SPY	ETF	132.87	132.87	132.71	132.71	197353.0
2012-05-24 19:00:00	SPY	ETF	132.71	132.76	132.63	132.76	142481.0
2012-05-24 04:00:00	QQQ	ETF	62.17	62.17	62.07	62.07	2012.0
2012-05-24 05:00:00	QQQ	ETF	62.4	62.55	62.4	62.55	2400.0
2012-05-24 06:00:00	QQQ	ETF	62.65	62.77	62.61	62.75	8300.0
2012-05-24 07:00:00	QQQ	ETF	62.71	62.71	62.56	62.56	66650.0
2012-05-24 08:00:00	QQQ	ETF	62.55	62.77	62.44	62.75	417690.0
2012-05-24 09:00:00	QQQ	ETF	62.75	62.8	62.0899	62.1999	7425706.0
2012-05-24 10:00:00	QQQ	ETF	62.19	62.6201	62.13	62.41	7906066.0
2012-05-24 11:00:00	QQQ	ETF	62.42	62.6	62.19	62.24	5956361.0
2012-05-24 12:00:00	QQQ	ETF	62.2491	62.258	62.025	62.13	4883789.0
2012-05-24 13:00:00	QQQ	ETF	62.13	62.28	61.88	61.88	5685965.0
2012-05-24 14:00:00	QQQ	ETF	61.8899	62.1	61.71	61.7399	18498954.0
2012-05-24 15:00:00	QQQ	ETF	61.74	62.18	61.69	62.17	14884999.0
2012-05-24 16:00:00	QQQ	ETF	62.17	62.5556	61.765	62.39	3510432.0
2012-05-24 17:00:00	QQQ	ETF	62.39	62.39	62.37	62.38	11035.0
2012-05-24 18:00:00	QQQ	ETF	62.37	62.37	62.3	62.3	3738.0
2012-05-24 19:00:00	QQQ	ETF	62.31	62.35	62.27	62.31	21087.0
2012-05-24 04:00:00	IWM	ETF	75.93	76.17	75.77	76.15	3882.0
2012-05-24 05:00:00	IWM	ETF	76.06	76.5	76.06	76.5	2500.0
2012-05-24 06:00:00	IWM	ETF	76.6	76.83	76.6	76.83	2700.0
2012-05-24 07:00:00	IWM	ETF	76.62	76.62	76.36	76.45	268535.0
2012-05-24 08:00:00	IWM	ETF	76.42	76.75	76.21	76.58	3070470.0
2012-05-24 09:00:00	IWM	ETF	76.58	76.69	75.98	76.13	8229946.0
2012-05-24 10:00:00	IWM	ETF	76.12	76.7401	76.0	76.5	7767540.0
2012-05-24 11:00:00	IWM	ETF	76.5	76.6	76.0899	76.15	4193867.0
2012-05-24 12:00:00	IWM	ETF	76.15	76.16	75.8	76.0	4340812.0
2012-05-24 13:00:00	IWM	ETF	76.01	76.25	75.62	75.62	5797615.0
2012-05-24 14:00:00	IWM	ETF	75.63	75.97	75.55	75.82	5080401.0
2012-05-24 15:00:00	IWM	ETF	75.81	76.66	75.81	76.65	9910484.0
2012-05-24 16:00:00	IWM	ETF	76.66	77.03	76.4823	77.0	3542823.0
2012-05-24 17:00:00	IWM	ETF	76.97	76.98	76.93	76.98	25900.0
2012-05-24 18:00:00	IWM	ETF	76.93	76.93	76.89	76.89	1900.0
2012-05-24 19:00:00	IWM	ETF	76.81	76.83	76.81	76.83	1817.0
2012-05-24 07:00:00	DIA	ETF	125.02	125.02	125.0	125.0	3275.0
2012-05-24 08:00:00	DIA	ETF	124.79	125.05	124.71	125.05	1000.0

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

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