PREVIEW / etf_1hour / 2013-03-11

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-03-11.parquet
  size:    196 KB
  rows:    6,123

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
2013-03-11 04:00:00	SPY	ETF	155.35	155.35	155.11	155.19	3402.0
2013-03-11 05:00:00	SPY	ETF	155.23	155.23	155.11	155.14	28100.0
2013-03-11 06:00:00	SPY	ETF	155.16	155.19	155.12	155.17	17290.0
2013-03-11 07:00:00	SPY	ETF	155.17	155.17	154.99	155.13	768490.0
2013-03-11 08:00:00	SPY	ETF	154.99	155.3	154.99	155.24	2499266.0
2013-03-11 09:00:00	SPY	ETF	155.25	155.42	155.13	155.35	11575291.0
2013-03-11 10:00:00	SPY	ETF	155.34	155.43	155.2	155.3685	8311932.0
2013-03-11 11:00:00	SPY	ETF	155.36	155.6	155.32	155.58	7807947.0
2013-03-11 12:00:00	SPY	ETF	155.59	155.79	155.58	155.79	7191410.0
2013-03-11 13:00:00	SPY	ETF	155.785	155.92	155.78	155.845	7310065.0
2013-03-11 14:00:00	SPY	ETF	155.845	156.03	155.77	155.96	7771309.0
2013-03-11 15:00:00	SPY	ETF	155.96	156.04	155.72	156.0	14347850.0
2013-03-11 16:00:00	SPY	ETF	156.0	156.1	155.3348	156.07	10293590.0
2013-03-11 17:00:00	SPY	ETF	156.07	156.15	156.05	156.1	1117867.0
2013-03-11 18:00:00	SPY	ETF	156.12	156.13	155.95	155.96	403765.0
2013-03-11 19:00:00	SPY	ETF	155.96	156.02	155.96	156.0	27908.0
2013-03-11 04:00:00	QQQ	ETF	68.51	68.56	68.51	68.56	28800.0
2013-03-11 06:00:00	QQQ	ETF	68.59	68.59	68.58	68.58	1500.0
2013-03-11 07:00:00	QQQ	ETF	68.6	68.6	68.53	68.57	4724.0
2013-03-11 08:00:00	QQQ	ETF	68.59	68.64	68.53	68.61	1391744.0
2013-03-11 09:00:00	QQQ	ETF	68.61	68.72	68.57	68.61	3078728.0
2013-03-11 10:00:00	QQQ	ETF	68.62	68.665	68.47	68.53	2794144.0
2013-03-11 11:00:00	QQQ	ETF	68.52	68.68	68.5	68.67	1626902.0
2013-03-11 12:00:00	QQQ	ETF	68.67	68.78	68.67	68.73	1982090.0
2013-03-11 13:00:00	QQQ	ETF	68.74	68.835	68.72	68.76	1501600.0
2013-03-11 14:00:00	QQQ	ETF	68.76	68.978	68.69	68.914	2987984.0
2013-03-11 15:00:00	QQQ	ETF	68.91	68.99	68.85	68.97	4183686.0
2013-03-11 16:00:00	QQQ	ETF	68.97	68.98	68.65	68.96	611832.0
2013-03-11 17:00:00	QQQ	ETF	68.95	68.97	68.93	68.93	10374.0
2013-03-11 18:00:00	QQQ	ETF	68.96	68.96	68.91	68.91	5137.0
2013-03-11 19:00:00	QQQ	ETF	68.91	68.93	68.91	68.93	2600.0
2013-03-11 07:00:00	IWM	ETF	93.58	93.58	93.25	93.35	2150.0
2013-03-11 08:00:00	IWM	ETF	93.44	93.44	93.26	93.4	1466396.0
2013-03-11 09:00:00	IWM	ETF	93.42	93.63	93.33	93.45	3865798.0
2013-03-11 10:00:00	IWM	ETF	93.46	93.605	93.34	93.43	3594023.0
2013-03-11 11:00:00	IWM	ETF	93.43	93.68	93.38	93.66	3016392.0
2013-03-11 12:00:00	IWM	ETF	93.66	93.72	93.53	93.63	2158873.0
2013-03-11 13:00:00	IWM	ETF	93.63	93.75	93.6	93.6435	1936453.0
2013-03-11 14:00:00	IWM	ETF	93.64	93.69	93.52	93.64	1900463.0
2013-03-11 15:00:00	IWM	ETF	93.64	93.71	93.49	93.68	4340938.0
2013-03-11 16:00:00	IWM	ETF	93.7	93.72	93.46	93.67	1473641.0
2013-03-11 17:00:00	IWM	ETF	93.67	93.69	93.65	93.65	53605.0
2013-03-11 18:00:00	IWM	ETF	93.65	93.65	93.65	93.65	3200.0
2013-03-11 19:00:00	IWM	ETF	93.65	93.67	93.65	93.65	5639.0
2013-03-11 07:00:00	DIA	ETF	143.55	143.57	143.55	143.55	1070.0
2013-03-11 08:00:00	DIA	ETF	143.49	143.66	143.49	143.66	3300.0
2013-03-11 09:00:00	DIA	ETF	143.72	143.85	143.61	143.82	503376.0
2013-03-11 10:00:00	DIA	ETF	143.83	143.92	143.75	143.86	464873.0
2013-03-11 11:00:00	DIA	ETF	143.86	144.025	143.845	144.02	571371.0
2013-03-11 12:00:00	DIA	ETF	144.03	144.22	144.009	144.209	518578.0

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

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