PREVIEW / etf_1hour / 2011-06-28

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-06-28.parquet
  size:    180 KB
  rows:    5,454

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
2011-06-28 04:00:00	SPY	ETF	128.18	128.25	128.0	128.0	4500.0
2011-06-28 05:00:00	SPY	ETF	127.89	127.95	127.75	127.75	17450.0
2011-06-28 06:00:00	SPY	ETF	127.8	127.95	127.77	127.83	16800.0
2011-06-28 07:00:00	SPY	ETF	127.87	128.09	127.61	127.94	650522.0
2011-06-28 08:00:00	SPY	ETF	127.94	128.7	127.78	128.61	2562648.0
2011-06-28 09:00:00	SPY	ETF	128.61	128.83	128.27	128.71	22882853.0
2011-06-28 10:00:00	SPY	ETF	128.71	129.23	128.66	128.98	26761213.0
2011-06-28 11:00:00	SPY	ETF	128.98	129.14	128.89	129.08	13044627.0
2011-06-28 12:00:00	SPY	ETF	129.08	129.29	129.06	129.23	11553675.0
2011-06-28 13:00:00	SPY	ETF	129.23	129.4	129.16	129.33	14724942.0
2011-06-28 14:00:00	SPY	ETF	129.339	129.605	129.25	129.48	18229172.0
2011-06-28 15:00:00	SPY	ETF	129.47	129.63	129.27	129.6	34379877.0
2011-06-28 16:00:00	SPY	ETF	129.6	129.93	127.9595	129.86	16741896.0
2011-06-28 17:00:00	SPY	ETF	129.86	129.94	129.81	129.9	224409.0
2011-06-28 18:00:00	SPY	ETF	129.88	129.89	129.61	129.76	239000.0
2011-06-28 19:00:00	SPY	ETF	129.76	129.92	129.73	129.92	127477.0
2011-06-28 04:00:00	QQQ	ETF	55.22	55.27	55.22	55.27	300.0
2011-06-28 05:00:00	QQQ	ETF	55.22	55.22	55.14	55.14	800.0
2011-06-28 06:00:00	QQQ	ETF	55.19	55.2	55.17	55.17	800.0
2011-06-28 07:00:00	QQQ	ETF	55.16	55.27	55.11	55.25	38775.0
2011-06-28 08:00:00	QQQ	ETF	55.22	55.51	55.17	55.46	319047.0
2011-06-28 09:00:00	QQQ	ETF	55.47	55.64	55.29	55.56	6865441.0
2011-06-28 10:00:00	QQQ	ETF	55.5684	55.83	55.54	55.76	7774235.0
2011-06-28 11:00:00	QQQ	ETF	55.76	55.86	55.71	55.83	3439809.0
2011-06-28 12:00:00	QQQ	ETF	55.83	55.91	55.81	55.88	2597885.0
2011-06-28 13:00:00	QQQ	ETF	55.875	55.97	55.85	55.945	3445464.0
2011-06-28 14:00:00	QQQ	ETF	55.9438	56.08	55.9	55.98	4847947.0
2011-06-28 15:00:00	QQQ	ETF	55.98	56.07	55.89	56.07	7448932.0
2011-06-28 16:00:00	QQQ	ETF	56.07	56.14	55.2454	56.13	2751220.0
2011-06-28 17:00:00	QQQ	ETF	56.13	56.17	55.2454	56.17	1652457.0
2011-06-28 18:00:00	QQQ	ETF	56.13	56.13	56.07	56.08	50943.0
2011-06-28 19:00:00	QQQ	ETF	56.07	56.11	56.06	56.09	21534.0
2011-06-28 05:00:00	IWM	ETF	80.39	80.54	80.37	80.37	1700.0
2011-06-28 06:00:00	IWM	ETF	80.44	80.46	80.44	80.46	3200.0
2011-06-28 07:00:00	IWM	ETF	80.49	80.62	80.42	80.59	18600.0
2011-06-28 08:00:00	IWM	ETF	80.56	81.0	80.51	80.97	879845.0
2011-06-28 09:00:00	IWM	ETF	80.97	81.2	80.67	81.04	7670485.0
2011-06-28 10:00:00	IWM	ETF	81.03	81.41	80.99	81.23	8899555.0
2011-06-28 11:00:00	IWM	ETF	81.22	81.44	81.16	81.42	3992569.0
2011-06-28 12:00:00	IWM	ETF	81.43	81.59	81.4	81.55	3315032.0
2011-06-28 13:00:00	IWM	ETF	81.55	81.66	81.46	81.605	4535616.0
2011-06-28 14:00:00	IWM	ETF	81.6036	81.76	81.57	81.72	4681818.0
2011-06-28 15:00:00	IWM	ETF	81.72	81.84	81.55	81.83	9234875.0
2011-06-28 16:00:00	IWM	ETF	81.83	81.99	80.6216	81.97	2887354.0
2011-06-28 17:00:00	IWM	ETF	81.95	82.04	81.89	82.03	78869.0
2011-06-28 18:00:00	IWM	ETF	82.03	82.04	81.99	82.02	9080.0
2011-06-28 19:00:00	IWM	ETF	82.0	82.0	81.99	82.0	6765.0
2011-06-28 05:00:00	DIA	ETF	120.13	120.13	120.09	120.09	400.0
2011-06-28 07:00:00	DIA	ETF	120.05	120.24	120.0	120.24	1200.0
2011-06-28 08:00:00	DIA	ETF	120.21	120.85	120.2	120.66	46025.0

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

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