PREVIEW / etf_1hour / 2013-09-06

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-09-06.parquet
  size:    206 KB
  rows:    6,437

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-09-06 04:00:00	SPY	ETF	165.88	165.96	165.88	165.96	6600.0
2013-09-06 05:00:00	SPY	ETF	165.94	165.96	165.86	165.86	5900.0
2013-09-06 06:00:00	SPY	ETF	165.83	165.92	165.81	165.92	12800.0
2013-09-06 07:00:00	SPY	ETF	165.91	166.23	165.91	166.22	141248.0
2013-09-06 08:00:00	SPY	ETF	166.21	166.94	165.82	166.83	4994251.0
2013-09-06 09:00:00	SPY	ETF	166.83	166.85	164.84	165.18	32290871.0
2013-09-06 10:00:00	SPY	ETF	165.17	166.33	164.48	166.27	34977332.0
2013-09-06 11:00:00	SPY	ETF	166.27	166.64	166.259	166.53	15381454.0
2013-09-06 12:00:00	SPY	ETF	166.53	166.6301	166.2	166.385	8665154.0
2013-09-06 13:00:00	SPY	ETF	166.38	166.92	166.375	166.8	9421443.0
2013-09-06 14:00:00	SPY	ETF	166.81	166.98	166.58	166.66	10229026.0
2013-09-06 15:00:00	SPY	ETF	166.66	166.73	165.88	165.98	25519813.0
2013-09-06 16:00:00	SPY	ETF	165.97	166.54	165.1651	166.0	14481067.0
2013-09-06 17:00:00	SPY	ETF	166.0	166.12	165.81	165.94	214326.0
2013-09-06 18:00:00	SPY	ETF	165.9	165.96	165.81	165.84	22136.0
2013-09-06 19:00:00	SPY	ETF	165.84	165.94	165.83	165.84	34077.0
2013-09-06 04:00:00	QQQ	ETF	76.87	76.92	76.84	76.92	11300.0
2013-09-06 05:00:00	QQQ	ETF	76.9	76.9	76.84	76.84	6900.0
2013-09-06 06:00:00	QQQ	ETF	76.84	76.92	76.84	76.92	6000.0
2013-09-06 07:00:00	QQQ	ETF	76.91	77.02	76.91	77.02	31170.0
2013-09-06 08:00:00	QQQ	ETF	76.77	77.22	76.77	77.18	590761.0
2013-09-06 09:00:00	QQQ	ETF	77.18	77.18	76.3	76.4	5309544.0
2013-09-06 10:00:00	QQQ	ETF	76.4	77.0891	76.05	77.045	6838143.0
2013-09-06 11:00:00	QQQ	ETF	77.05	77.19	77.03	77.1	2852777.0
2013-09-06 12:00:00	QQQ	ETF	77.1	77.18	76.99	77.0801	1556569.0
2013-09-06 13:00:00	QQQ	ETF	77.09	77.34	77.08	77.28	3052763.0
2013-09-06 14:00:00	QQQ	ETF	77.27	77.3299	77.17	77.2	1473448.0
2013-09-06 15:00:00	QQQ	ETF	77.2001	77.22	76.905	76.92	4846146.0
2013-09-06 16:00:00	QQQ	ETF	76.93	77.11	76.786	76.96	976368.0
2013-09-06 17:00:00	QQQ	ETF	76.96	77.03	76.95	77.0	10319.0
2013-09-06 18:00:00	QQQ	ETF	76.99	77.0	76.99	77.0	760.0
2013-09-06 19:00:00	QQQ	ETF	76.98	77.0	76.92	77.0	2731.0
2013-09-06 07:00:00	IWM	ETF	102.38	102.39	102.37	102.39	6700.0
2013-09-06 08:00:00	IWM	ETF	102.39	102.8	102.34	102.78	575324.0
2013-09-06 09:00:00	IWM	ETF	102.8	102.82	101.3	101.58	9235782.0
2013-09-06 10:00:00	IWM	ETF	101.58	102.6	100.74	102.54	9790149.0
2013-09-06 11:00:00	IWM	ETF	102.54	102.79	102.54	102.68	3523521.0
2013-09-06 12:00:00	IWM	ETF	102.68	102.75	102.46	102.6	1830218.0
2013-09-06 13:00:00	IWM	ETF	102.61	102.89	102.57	102.79	1912017.0
2013-09-06 14:00:00	IWM	ETF	102.79	102.88	102.65	102.7	1966629.0
2013-09-06 15:00:00	IWM	ETF	102.71	102.76	102.24	102.34	6819649.0
2013-09-06 16:00:00	IWM	ETF	102.36	102.4868	102.18	102.38	790592.0
2013-09-06 17:00:00	IWM	ETF	102.39	102.39	102.32	102.37	1643.0
2013-09-06 18:00:00	IWM	ETF	102.37	102.37	102.37	102.37	950.0
2013-09-06 19:00:00	IWM	ETF	102.37	102.39	102.37	102.37	1398.0
2013-09-06 08:00:00	DIA	ETF	149.36	149.95	149.36	149.9	21190.0
2013-09-06 09:00:00	DIA	ETF	149.88	149.88	148.05	148.19	1390648.0
2013-09-06 10:00:00	DIA	ETF	148.18	149.24	147.77	149.19	2166683.0
2013-09-06 11:00:00	DIA	ETF	149.21	149.75	149.21	149.58	958981.0
2013-09-06 12:00:00	DIA	ETF	149.58	149.71	149.33	149.44	394423.0

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

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