PREVIEW / etf_1hour / 2012-06-01

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-06-01.parquet
  size:    197 KB
  rows:    6,114

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-06-01 04:00:00	SPY	ETF	131.0	131.0	130.17	130.17	2525.0
2012-06-01 05:00:00	SPY	ETF	130.15	130.15	129.84	129.94	36276.0
2012-06-01 06:00:00	SPY	ETF	129.99	130.08	129.75	130.01	163510.0
2012-06-01 07:00:00	SPY	ETF	130.0	130.21	129.91	130.0	736320.0
2012-06-01 08:00:00	SPY	ETF	130.0	130.86	128.61	129.18	9642903.0
2012-06-01 09:00:00	SPY	ETF	129.17	131.49	128.93	129.26	32610218.0
2012-06-01 10:00:00	SPY	ETF	129.27	129.76	128.95	129.01	35953009.0
2012-06-01 11:00:00	SPY	ETF	129.01	129.18	128.74	129.15	22443180.0
2012-06-01 12:00:00	SPY	ETF	129.15	129.32	128.77	128.87	16462518.0
2012-06-01 13:00:00	SPY	ETF	128.87	128.98	128.41	128.54	22378559.0
2012-06-01 14:00:00	SPY	ETF	128.5375	131.5042	128.2	128.41	28529139.0
2012-06-01 15:00:00	SPY	ETF	128.41	128.65	128.17	128.22	51450326.0
2012-06-01 16:00:00	SPY	ETF	128.22	131.5042	127.96	128.07	22288665.0
2012-06-01 17:00:00	SPY	ETF	128.08	129.0167	128.08	128.13	381121.0
2012-06-01 18:00:00	SPY	ETF	128.13	128.16	127.95	127.95	104809.0
2012-06-01 19:00:00	SPY	ETF	127.96	128.02	127.91	128.01	76629.0
2012-06-01 04:00:00	QQQ	ETF	61.59	61.64	61.5	61.5	1225.0
2012-06-01 05:00:00	QQQ	ETF	61.41	61.43	61.37	61.42	5200.0
2012-06-01 06:00:00	QQQ	ETF	61.39	61.39	61.34	61.35	1300.0
2012-06-01 07:00:00	QQQ	ETF	61.37	61.43	61.32	61.39	36335.0
2012-06-01 08:00:00	QQQ	ETF	61.39	62.06	60.68	60.98	2903363.0
2012-06-01 09:00:00	QQQ	ETF	60.96	61.32	60.86	61.09	11125199.0
2012-06-01 10:00:00	QQQ	ETF	61.09	61.28	60.8376	60.9123	11801049.0
2012-06-01 11:00:00	QQQ	ETF	60.92	60.935	60.75	60.8301	6992598.0
2012-06-01 12:00:00	QQQ	ETF	60.83	60.9299	60.74	60.75	3648650.0
2012-06-01 13:00:00	QQQ	ETF	60.75	60.79	60.51	60.57	7074134.0
2012-06-01 14:00:00	QQQ	ETF	60.571	60.68	60.39	60.52	8244128.0
2012-06-01 15:00:00	QQQ	ETF	60.5175	60.69	60.39	60.44	14038503.0
2012-06-01 16:00:00	QQQ	ETF	60.4	60.4855	60.3	60.31	2416996.0
2012-06-01 17:00:00	QQQ	ETF	60.31	60.4	60.3	60.35	19528.0
2012-06-01 18:00:00	QQQ	ETF	60.36	60.38	60.31	60.31	6179.0
2012-06-01 19:00:00	QQQ	ETF	60.33	60.43	60.31	60.43	13299.0
2012-06-01 04:00:00	IWM	ETF	75.49	75.59	75.16	75.16	2030.0
2012-06-01 05:00:00	IWM	ETF	75.02	75.02	75.02	75.02	100.0
2012-06-01 07:00:00	IWM	ETF	75.05	75.1	74.9	75.01	92006.0
2012-06-01 08:00:00	IWM	ETF	75.05	75.1	73.85	74.45	1852677.0
2012-06-01 09:00:00	IWM	ETF	74.44	74.91	74.26	74.58	7647943.0
2012-06-01 10:00:00	IWM	ETF	74.57	75.01	74.39	74.4601	12022318.0
2012-06-01 11:00:00	IWM	ETF	74.47	74.48	74.23	74.36	7301102.0
2012-06-01 12:00:00	IWM	ETF	74.36	74.62	74.27	74.405	4248020.0
2012-06-01 13:00:00	IWM	ETF	74.4	74.42	73.94	74.02	7030368.0
2012-06-01 14:00:00	IWM	ETF	74.03	74.25	73.84	74.05	4987849.0
2012-06-01 15:00:00	IWM	ETF	74.04	74.14	73.71	73.82	11294073.0
2012-06-01 16:00:00	IWM	ETF	73.83	76.1809	73.72	73.78	2890215.0
2012-06-01 17:00:00	IWM	ETF	73.78	74.3694	73.78	73.78	35816.0
2012-06-01 18:00:00	IWM	ETF	73.8	73.8	73.75	73.75	3292.0
2012-06-01 05:00:00	DIA	ETF	122.75	122.75	122.63	122.63	6500.0
2012-06-01 06:00:00	DIA	ETF	122.7	122.7	122.61	122.61	1100.0
2012-06-01 07:00:00	DIA	ETF	122.74	122.9	122.59	122.9	14025.0
2012-06-01 08:00:00	DIA	ETF	122.73	122.81	121.63	122.08	212058.0

> showing 50 of 6,114 rows — these rows as CSV

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