PREVIEW / etf_1hour / 2013-08-30

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-08-30.parquet
  size:    199 KB
  rows:    6,338

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-08-30 04:00:00	SPY	ETF	164.47	164.47	164.26	164.44	408020.0
2013-08-30 05:00:00	SPY	ETF	164.46	164.63	164.38	164.56	387590.0
2013-08-30 06:00:00	SPY	ETF	164.58	164.68	164.54	164.68	165470.0
2013-08-30 07:00:00	SPY	ETF	164.68	164.68	164.37	164.55	603795.0
2013-08-30 08:00:00	SPY	ETF	164.66	164.66	164.25	164.39	697268.0
2013-08-30 09:00:00	SPY	ETF	164.4	164.58	164.04	164.16	10783032.0
2013-08-30 10:00:00	SPY	ETF	164.15	164.16	163.5499	163.66	17943694.0
2013-08-30 11:00:00	SPY	ETF	163.65	163.91	163.44	163.56	12729008.0
2013-08-30 12:00:00	SPY	ETF	163.56	163.84	163.5	163.76	9092509.0
2013-08-30 13:00:00	SPY	ETF	163.76	164.08	163.2	163.56	19355041.0
2013-08-30 14:00:00	SPY	ETF	163.56	163.95	163.45	163.85	9383999.0
2013-08-30 15:00:00	SPY	ETF	163.85	164.0	163.17	163.57	28806292.0
2013-08-30 16:00:00	SPY	ETF	163.58	164.2128	163.47	163.8	17008200.0
2013-08-30 17:00:00	SPY	ETF	163.8	163.85	163.46	163.53	3017681.0
2013-08-30 18:00:00	SPY	ETF	163.53	163.53	163.38	163.5	161695.0
2013-08-30 19:00:00	SPY	ETF	163.49	163.58	163.49	163.54	26487.0
2013-08-30 04:00:00	QQQ	ETF	75.95	75.97	75.87	75.97	27700.0
2013-08-30 05:00:00	QQQ	ETF	75.99	76.07	75.95	76.05	15100.0
2013-08-30 06:00:00	QQQ	ETF	76.05	76.09	76.04	76.09	3200.0
2013-08-30 07:00:00	QQQ	ETF	76.07	76.07	75.95	76.03	26025.0
2013-08-30 08:00:00	QQQ	ETF	76.03	76.04	75.9	75.95	270920.0
2013-08-30 09:00:00	QQQ	ETF	75.96	76.05	75.69	75.75	4092372.0
2013-08-30 10:00:00	QQQ	ETF	75.745	75.75	75.4	75.46	4277432.0
2013-08-30 11:00:00	QQQ	ETF	75.45	75.57	75.33	75.41	2817965.0
2013-08-30 12:00:00	QQQ	ETF	75.41	75.56	75.36	75.51	2489493.0
2013-08-30 13:00:00	QQQ	ETF	75.51	75.64	75.2	75.4201	4038740.0
2013-08-30 14:00:00	QQQ	ETF	75.42	75.6	75.38	75.55	1185857.0
2013-08-30 15:00:00	QQQ	ETF	75.54	75.6	75.29	75.47	4562340.0
2013-08-30 16:00:00	QQQ	ETF	75.47	75.69	75.4551	75.6	1884331.0
2013-08-30 17:00:00	QQQ	ETF	75.6	75.62	75.42	75.43	8000.0
2013-08-30 18:00:00	QQQ	ETF	75.43	75.55	75.43	75.55	9213.0
2013-08-30 19:00:00	QQQ	ETF	75.55	75.62	75.55	75.55	2700.0
2013-08-30 07:00:00	IWM	ETF	102.0	102.0	101.86	101.91	8600.0
2013-08-30 08:00:00	IWM	ETF	101.95	101.99	101.72	101.87	55936.0
2013-08-30 09:00:00	IWM	ETF	101.86	102.02	101.52	101.62	2578930.0
2013-08-30 10:00:00	IWM	ETF	101.61	101.61	100.92	101.05	5942951.0
2013-08-30 11:00:00	IWM	ETF	101.0499	101.26	100.6	100.73	5035816.0
2013-08-30 12:00:00	IWM	ETF	100.72	100.98	100.67	100.83	2633258.0
2013-08-30 13:00:00	IWM	ETF	100.835	101.1	100.26	100.5802	5883728.0
2013-08-30 14:00:00	IWM	ETF	100.58	100.73	100.51	100.58	2031207.0
2013-08-30 15:00:00	IWM	ETF	100.58	100.75	100.24	100.43	10102970.0
2013-08-30 16:00:00	IWM	ETF	100.43	102.0524	100.36	100.62	4679593.0
2013-08-30 17:00:00	IWM	ETF	100.62	100.62	100.4	100.5	113842.0
2013-08-30 18:00:00	IWM	ETF	100.5	100.5	100.37	100.37	8934.0
2013-08-30 19:00:00	IWM	ETF	100.48	100.5	100.43	100.43	1308.0
2013-08-30 07:00:00	DIA	ETF	148.47	148.47	148.47	148.47	700.0
2013-08-30 08:00:00	DIA	ETF	148.48	148.53	148.25	148.25	5402.0
2013-08-30 09:00:00	DIA	ETF	148.4	148.48	147.94	148.0901	599002.0
2013-08-30 10:00:00	DIA	ETF	148.09	148.1	147.67	147.76	1177187.0
2013-08-30 11:00:00	DIA	ETF	147.76	147.95	147.57	147.68	903643.0

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

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