PREVIEW / etf_1hour / 2012-02-27

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-02-27.parquet
  size:    186 KB
  rows:    5,774

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-02-27 04:00:00	SPY	ETF	136.25	136.3	136.09	136.21	10012.0
2012-02-27 05:00:00	SPY	ETF	136.15	136.24	136.1	136.19	61350.0
2012-02-27 06:00:00	SPY	ETF	136.09	136.19	136.03	136.09	27665.0
2012-02-27 07:00:00	SPY	ETF	136.14	136.27	136.13	136.21	206311.0
2012-02-27 08:00:00	SPY	ETF	136.22	136.42	136.095	136.19	688399.0
2012-02-27 09:00:00	SPY	ETF	136.19	136.2	135.8	136.08	19593540.0
2012-02-27 10:00:00	SPY	ETF	136.075	136.82	136.07	136.68	30023238.0
2012-02-27 11:00:00	SPY	ETF	136.68	137.26	136.68	137.11	24701985.0
2012-02-27 12:00:00	SPY	ETF	137.11	137.46	136.99	137.2772	13482358.0
2012-02-27 13:00:00	SPY	ETF	137.28	137.31	137.08	137.12	7310982.0
2012-02-27 14:00:00	SPY	ETF	137.12	137.29	137.11	137.26	6391458.0
2012-02-27 15:00:00	SPY	ETF	137.27	137.53	137.09	137.11	30280367.0
2012-02-27 16:00:00	SPY	ETF	137.13	137.29	137.04	137.17	6100422.0
2012-02-27 17:00:00	SPY	ETF	137.17	137.21	136.8842	137.09	4552242.0
2012-02-27 18:00:00	SPY	ETF	137.09	137.25	137.09	137.23	129776.0
2012-02-27 19:00:00	SPY	ETF	137.22	137.3	137.14	137.18	79239.0
2012-02-27 04:00:00	QQQ	ETF	63.62	63.62	63.62	63.62	200.0
2012-02-27 06:00:00	QQQ	ETF	63.62	63.64	63.59	63.62	3210.0
2012-02-27 07:00:00	QQQ	ETF	63.62	63.65	63.6	63.63	50340.0
2012-02-27 08:00:00	QQQ	ETF	63.64	63.68	63.6	63.64	317545.0
2012-02-27 09:00:00	QQQ	ETF	63.65	63.65	63.33	63.5	7358097.0
2012-02-27 10:00:00	QQQ	ETF	63.5	63.96	63.5	63.88	10677715.0
2012-02-27 11:00:00	QQQ	ETF	63.87	64.18	63.87	64.07	6557831.0
2012-02-27 12:00:00	QQQ	ETF	64.0685	64.21	64.01	64.155	3199409.0
2012-02-27 13:00:00	QQQ	ETF	64.15	64.16	63.98	63.99	2134118.0
2012-02-27 14:00:00	QQQ	ETF	63.99	64.16	63.99	64.158	1931661.0
2012-02-27 15:00:00	QQQ	ETF	64.16	64.26	64.02	64.04	8071710.0
2012-02-27 16:00:00	QQQ	ETF	64.04	64.11	64.03	64.04	448291.0
2012-02-27 17:00:00	QQQ	ETF	64.06	64.08	64.05	64.05	10830.0
2012-02-27 18:00:00	QQQ	ETF	64.05	64.08	64.05	64.07	10260.0
2012-02-27 19:00:00	QQQ	ETF	64.07	64.08	64.05	64.05	9255.0
2012-02-27 04:00:00	IWM	ETF	82.04	82.04	82.04	82.04	200.0
2012-02-27 06:00:00	IWM	ETF	81.86	81.9	81.84	81.87	2788.0
2012-02-27 07:00:00	IWM	ETF	81.9	81.99	81.89	81.92	9699.0
2012-02-27 08:00:00	IWM	ETF	82.0	82.02	81.85	81.91	217367.0
2012-02-27 09:00:00	IWM	ETF	81.91	81.93	81.25	81.609	9860398.0
2012-02-27 10:00:00	IWM	ETF	81.6	82.51	81.56	82.42	10673090.0
2012-02-27 11:00:00	IWM	ETF	82.41	82.95	82.41	82.639	7312170.0
2012-02-27 12:00:00	IWM	ETF	82.64	82.9	82.44	82.79	4043422.0
2012-02-27 13:00:00	IWM	ETF	82.79	82.8	82.44	82.5	3627431.0
2012-02-27 14:00:00	IWM	ETF	82.5	82.73	82.5	82.691	2001907.0
2012-02-27 15:00:00	IWM	ETF	82.69	82.88	82.5	82.51	7062700.0
2012-02-27 16:00:00	IWM	ETF	82.5	82.61	81.3	82.48	1630942.0
2012-02-27 17:00:00	IWM	ETF	82.52	82.53	82.51	82.51	1678.0
2012-02-27 19:00:00	IWM	ETF	82.59	82.6	82.52	82.58	3400.0
2012-02-27 04:00:00	DIA	ETF	129.12	129.12	129.0	129.0	200.0
2012-02-27 05:00:00	DIA	ETF	128.95	128.95	128.93	128.93	1500.0
2012-02-27 06:00:00	DIA	ETF	129.0	129.0	129.0	129.0	1000.0
2012-02-27 07:00:00	DIA	ETF	129.04	129.05	129.04	129.05	500.0
2012-02-27 08:00:00	DIA	ETF	129.15	129.25	129.06	129.09	31539.0

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

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