PREVIEW / etf_1hour / 2012-08-16

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-08-16.parquet
  size:    184 KB
  rows:    5,662

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-08-16 04:00:00	SPY	ETF	141.03	141.1	141.03	141.1	1900.0
2012-08-16 05:00:00	SPY	ETF	141.06	141.12	141.06	141.09	2200.0
2012-08-16 06:00:00	SPY	ETF	141.09	141.12	141.05	141.12	2414.0
2012-08-16 07:00:00	SPY	ETF	141.12	141.26	141.12	141.17	104128.0
2012-08-16 08:00:00	SPY	ETF	141.18	141.4	141.05	141.2	915331.0
2012-08-16 09:00:00	SPY	ETF	141.21	141.29	140.91	140.97	10159018.0
2012-08-16 10:00:00	SPY	ETF	140.975	141.42	140.8	141.345	17818037.0
2012-08-16 11:00:00	SPY	ETF	141.345	141.77	141.29	141.7	12815154.0
2012-08-16 12:00:00	SPY	ETF	141.7	141.82	141.635	141.79	8845950.0
2012-08-16 13:00:00	SPY	ETF	141.781	141.91	141.74	141.81	6733225.0
2012-08-16 14:00:00	SPY	ETF	141.82	142.16	141.79	142.01	15232458.0
2012-08-16 15:00:00	SPY	ETF	142.02	142.16	141.83	141.99	21530527.0
2012-08-16 16:00:00	SPY	ETF	141.98	142.11	141.0	142.05	13807100.0
2012-08-16 17:00:00	SPY	ETF	142.03	142.05	141.92	141.99	1059827.0
2012-08-16 18:00:00	SPY	ETF	141.99	141.99	141.95	141.96	11050.0
2012-08-16 19:00:00	SPY	ETF	141.97	142.01	141.96	142.0	25513.0
2012-08-16 06:00:00	QQQ	ETF	67.35	67.35	67.35	67.35	100.0
2012-08-16 07:00:00	QQQ	ETF	67.41	67.44	67.4	67.44	14900.0
2012-08-16 08:00:00	QQQ	ETF	67.46	67.57	67.44	67.46	552833.0
2012-08-16 09:00:00	QQQ	ETF	67.45	67.55	67.23	67.48	3317766.0
2012-08-16 10:00:00	QQQ	ETF	67.48	67.75	67.39	67.7	4520149.0
2012-08-16 11:00:00	QQQ	ETF	67.699	67.9399	67.67	67.9	3307323.0
2012-08-16 12:00:00	QQQ	ETF	67.9	67.959	67.85	67.949	1807027.0
2012-08-16 13:00:00	QQQ	ETF	67.9401	67.99	67.87	67.94	2112323.0
2012-08-16 14:00:00	QQQ	ETF	67.93	68.16	67.91	68.13	5624383.0
2012-08-16 15:00:00	QQQ	ETF	68.122	68.17	67.99	68.01	5137982.0
2012-08-16 16:00:00	QQQ	ETF	68.01	68.0668	67.2186	68.01	4432805.0
2012-08-16 17:00:00	QQQ	ETF	68.01	68.01	68.0	68.0	900.0
2012-08-16 18:00:00	QQQ	ETF	68.0	68.01	67.98	68.0	2384.0
2012-08-16 19:00:00	QQQ	ETF	67.97	68.02	67.97	67.98	6151.0
2012-08-16 07:00:00	IWM	ETF	80.27	80.3	80.15	80.18	37400.0
2012-08-16 08:00:00	IWM	ETF	80.25	80.93	79.82	80.22	181111.0
2012-08-16 09:00:00	IWM	ETF	80.23	80.36	79.94	79.99	3255803.0
2012-08-16 10:00:00	IWM	ETF	79.99	80.41	79.83	80.329	5064749.0
2012-08-16 11:00:00	IWM	ETF	80.32	80.82	80.28	80.74	5097559.0
2012-08-16 12:00:00	IWM	ETF	80.75	80.94	80.7	80.94	2258148.0
2012-08-16 13:00:00	IWM	ETF	80.94	81.05	80.92	80.95	2763438.0
2012-08-16 14:00:00	IWM	ETF	80.96	81.185	80.94	81.04	3981760.0
2012-08-16 15:00:00	IWM	ETF	81.045	81.3	80.96	81.1	10506562.0
2012-08-16 16:00:00	IWM	ETF	81.11	81.2699	80.99	81.08	3141798.0
2012-08-16 17:00:00	IWM	ETF	81.09	81.09	81.07	81.07	2400.0
2012-08-16 18:00:00	IWM	ETF	81.0	81.0	81.0	81.0	1000.0
2012-08-16 19:00:00	IWM	ETF	81.08	81.12	81.08	81.12	8031.0
2012-08-16 08:00:00	DIA	ETF	131.83	131.93	131.83	131.93	8100.0
2012-08-16 09:00:00	DIA	ETF	131.86	131.96	131.55	131.66	280372.0
2012-08-16 10:00:00	DIA	ETF	131.66	132.1126	131.5	132.03	1007448.0
2012-08-16 11:00:00	DIA	ETF	132.04	132.32	131.99	132.26	447511.0
2012-08-16 12:00:00	DIA	ETF	132.26	132.43	132.25	132.43	290869.0
2012-08-16 13:00:00	DIA	ETF	132.44	132.52	132.37	132.42	422702.0
2012-08-16 14:00:00	DIA	ETF	132.42	132.75	132.41	132.65	694200.0

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

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