PREVIEW / etf_1hour / 2013-08-27

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-08-27.parquet
  size:    217 KB
  rows:    6,766

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-27 04:00:00	SPY	ETF	165.56	165.56	164.93	165.1	84185.0
2013-08-27 05:00:00	SPY	ETF	165.1	165.22	165.04	165.2	211825.0
2013-08-27 06:00:00	SPY	ETF	165.22	165.23	164.72	164.8	186298.0
2013-08-27 07:00:00	SPY	ETF	164.81	165.12	164.72	165.02	748962.0
2013-08-27 08:00:00	SPY	ETF	165.02	165.97	164.14	164.37	2534041.0
2013-08-27 09:00:00	SPY	ETF	164.36	164.98	164.2	164.75	19423515.0
2013-08-27 10:00:00	SPY	ETF	164.759	164.92	164.11	164.6	22392746.0
2013-08-27 11:00:00	SPY	ETF	164.59	164.745	164.3101	164.4601	13623409.0
2013-08-27 12:00:00	SPY	ETF	164.461	164.47	163.98	164.077	11899167.0
2013-08-27 13:00:00	SPY	ETF	164.08	166.0024	163.74	163.99	14938781.0
2013-08-27 14:00:00	SPY	ETF	163.98	163.9881	163.44	163.7	18951152.0
2013-08-27 15:00:00	SPY	ETF	163.71	163.9	163.21	163.32	33504167.0
2013-08-27 16:00:00	SPY	ETF	163.33	166.0024	163.26	163.41	16383360.0
2013-08-27 17:00:00	SPY	ETF	163.41	163.42	163.35	163.41	150706.0
2013-08-27 18:00:00	SPY	ETF	163.41	163.44	163.3	163.4	169284.0
2013-08-27 19:00:00	SPY	ETF	163.38	163.43	163.25	163.3	93044.0
2013-08-27 04:00:00	QQQ	ETF	76.5	76.5	76.24	76.32	49000.0
2013-08-27 05:00:00	QQQ	ETF	76.3	76.3	76.23	76.3	25300.0
2013-08-27 06:00:00	QQQ	ETF	76.28	76.28	75.94	75.96	43889.0
2013-08-27 07:00:00	QQQ	ETF	75.96	76.16	75.94	76.11	89780.0
2013-08-27 08:00:00	QQQ	ETF	76.14	76.67	75.73	75.785	636270.0
2013-08-27 09:00:00	QQQ	ETF	75.79	76.18	75.74	76.03	4877174.0
2013-08-27 10:00:00	QQQ	ETF	76.03	76.12	75.66	75.9	5069693.0
2013-08-27 11:00:00	QQQ	ETF	75.9	76.03	75.73	75.8001	5124564.0
2013-08-27 12:00:00	QQQ	ETF	75.809	75.809	75.45	75.51	5139046.0
2013-08-27 13:00:00	QQQ	ETF	75.51	75.51	75.22	75.35	3941609.0
2013-08-27 14:00:00	QQQ	ETF	75.3586	75.3586	75.07	75.25	3406858.0
2013-08-27 15:00:00	QQQ	ETF	75.25	75.39	74.96	75.1	7686687.0
2013-08-27 16:00:00	QQQ	ETF	75.1	76.6616	75.064	75.18	3045755.0
2013-08-27 17:00:00	QQQ	ETF	75.18	75.19	75.15	75.19	6725.0
2013-08-27 18:00:00	QQQ	ETF	75.18	75.18	75.13	75.15	5588.0
2013-08-27 19:00:00	QQQ	ETF	75.17	75.18	75.09	75.11	9035.0
2013-08-27 04:00:00	IWM	ETF	102.47	102.47	102.47	102.47	100.0
2013-08-27 06:00:00	IWM	ETF	102.48	102.48	102.22	102.22	330.0
2013-08-27 07:00:00	IWM	ETF	102.22	102.35	102.11	102.31	58951.0
2013-08-27 08:00:00	IWM	ETF	102.34	102.34	101.74	101.89	415234.0
2013-08-27 09:00:00	IWM	ETF	101.88	102.3901	101.78	102.23	5257685.0
2013-08-27 10:00:00	IWM	ETF	102.23	102.38	101.59	101.92	7493926.0
2013-08-27 11:00:00	IWM	ETF	101.92	101.96	101.63	101.77	3943465.0
2013-08-27 12:00:00	IWM	ETF	101.76	101.77	101.38	101.435	3415707.0
2013-08-27 13:00:00	IWM	ETF	101.43	101.47	101.1	101.24	3631796.0
2013-08-27 14:00:00	IWM	ETF	101.23	101.24	100.68	100.86	6056629.0
2013-08-27 15:00:00	IWM	ETF	100.85	100.96	100.555	100.71	8703968.0
2013-08-27 16:00:00	IWM	ETF	100.7	103.1634	100.63	100.78	3627485.0
2013-08-27 17:00:00	IWM	ETF	100.77	100.77	100.73	100.73	1842.0
2013-08-27 18:00:00	IWM	ETF	100.8	100.8	100.7	100.7	821.0
2013-08-27 19:00:00	IWM	ETF	100.7	100.75	100.66	100.66	2800.0
2013-08-27 06:00:00	DIA	ETF	148.6	148.6	148.38	148.38	14000.0
2013-08-27 07:00:00	DIA	ETF	148.3	148.53	148.3	148.5	1299.0
2013-08-27 08:00:00	DIA	ETF	148.61	148.61	148.0	148.03	12650.0

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

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