PREVIEW / etf_1hour / 2012-05-15

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-05-15.parquet
  size:    190 KB
  rows:    5,885

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-15 04:00:00	SPY	ETF	134.85	135.11	134.59	134.59	29349.0
2012-05-15 05:00:00	SPY	ETF	134.66	134.83	134.59	134.65	40240.0
2012-05-15 06:00:00	SPY	ETF	134.88	134.88	134.61	134.64	175055.0
2012-05-15 07:00:00	SPY	ETF	134.64	134.75	134.51	134.75	201692.0
2012-05-15 08:00:00	SPY	ETF	134.75	134.97	134.25	134.26	2642387.0
2012-05-15 09:00:00	SPY	ETF	134.26	134.47	133.61	134.26	28273890.0
2012-05-15 10:00:00	SPY	ETF	134.265	134.72	134.1	134.35	26876421.0
2012-05-15 11:00:00	SPY	ETF	134.36	134.7	133.84	134.595	23186590.0
2012-05-15 12:00:00	SPY	ETF	134.6	134.81	134.36	134.4	12384200.0
2012-05-15 13:00:00	SPY	ETF	134.4	134.55	133.92	134.0025	16920152.0
2012-05-15 14:00:00	SPY	ETF	134.01	134.37	133.89	133.935	20328710.0
2012-05-15 15:00:00	SPY	ETF	133.922	134.1358	133.13	133.36	55728547.0
2012-05-15 16:00:00	SPY	ETF	133.35	133.61	133.32	133.51	16837637.0
2012-05-15 17:00:00	SPY	ETF	133.51	133.58	133.48	133.56	140110.0
2012-05-15 18:00:00	SPY	ETF	133.57	133.75	133.52	133.63	288594.0
2012-05-15 19:00:00	SPY	ETF	133.63	133.73	133.6	133.68	85183.0
2012-05-15 04:00:00	QQQ	ETF	64.0	64.0	64.0	64.0	100.0
2012-05-15 05:00:00	QQQ	ETF	63.95	63.95	63.95	63.95	500.0
2012-05-15 06:00:00	QQQ	ETF	64.04	64.04	63.93	63.93	6600.0
2012-05-15 07:00:00	QQQ	ETF	63.93	63.98	63.86	63.98	191605.0
2012-05-15 08:00:00	QQQ	ETF	63.98	64.08	63.78	63.78	437155.0
2012-05-15 09:00:00	QQQ	ETF	63.78	63.91	63.58	63.77	5538003.0
2012-05-15 10:00:00	QQQ	ETF	63.77	64.06	63.63	63.95	13418191.0
2012-05-15 11:00:00	QQQ	ETF	63.95	64.15	63.66	64.065	7331388.0
2012-05-15 12:00:00	QQQ	ETF	64.07	64.27	64.03	64.06	4972431.0
2012-05-15 13:00:00	QQQ	ETF	64.06	64.14	63.77	63.86	3328401.0
2012-05-15 14:00:00	QQQ	ETF	63.86	64.06	63.73	63.75	4005065.0
2012-05-15 15:00:00	QQQ	ETF	63.75	63.75	63.26	63.38	16087661.0
2012-05-15 16:00:00	QQQ	ETF	63.37	63.8777	63.2875	63.4	2106487.0
2012-05-15 17:00:00	QQQ	ETF	63.4	63.45	63.39	63.4	44618.0
2012-05-15 18:00:00	QQQ	ETF	63.44	63.49	63.44	63.46	19450.0
2012-05-15 19:00:00	QQQ	ETF	63.47	63.48	63.45	63.47	8227.0
2012-05-15 04:00:00	IWM	ETF	78.3	78.32	78.1	78.1	5551.0
2012-05-15 05:00:00	IWM	ETF	78.14	78.25	78.14	78.25	1099.0
2012-05-15 06:00:00	IWM	ETF	78.37	78.39	78.1	78.32	7500.0
2012-05-15 07:00:00	IWM	ETF	78.17	78.2	78.07	78.2	86234.0
2012-05-15 08:00:00	IWM	ETF	78.2	78.33	77.89	77.89	443304.0
2012-05-15 09:00:00	IWM	ETF	77.89	78.05	77.56	77.94	7036582.0
2012-05-15 10:00:00	IWM	ETF	77.94	78.36	77.93	78.14	8895583.0
2012-05-15 11:00:00	IWM	ETF	78.14	78.44	77.72	78.36	7780312.0
2012-05-15 12:00:00	IWM	ETF	78.37	78.49	78.2	78.25	3709144.0
2012-05-15 13:00:00	IWM	ETF	78.25	78.37	77.92	78.03	4192336.0
2012-05-15 14:00:00	IWM	ETF	78.02	78.248	77.9	77.92	4135286.0
2012-05-15 15:00:00	IWM	ETF	77.92	77.925	77.47	77.7	12398558.0
2012-05-15 16:00:00	IWM	ETF	77.7	77.85	77.644	77.76	1239280.0
2012-05-15 17:00:00	IWM	ETF	77.72	77.81	77.69	77.81	9800.0
2012-05-15 18:00:00	IWM	ETF	77.81	77.81	77.63	77.8	3700.0
2012-05-15 06:00:00	DIA	ETF	127.41	127.41	127.41	127.41	1000.0
2012-05-15 07:00:00	DIA	ETF	127.41	127.49	127.33	127.45	10700.0
2012-05-15 08:00:00	DIA	ETF	127.44	127.62	127.1	127.1	11620.0

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

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