PREVIEW / etf_1hour / 2013-09-05

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-09-05.parquet
  size:    202 KB
  rows:    6,353

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-05 04:00:00	SPY	ETF	166.13	166.13	165.71	165.88	28215.0
2013-09-05 05:00:00	SPY	ETF	165.85	165.93	165.65	165.77	60735.0
2013-09-05 06:00:00	SPY	ETF	165.75	166.02	165.72	165.94	41600.0
2013-09-05 07:00:00	SPY	ETF	165.92	166.02	165.79	165.84	213714.0
2013-09-05 08:00:00	SPY	ETF	165.95	166.17	165.85	165.98	617369.0
2013-09-05 09:00:00	SPY	ETF	165.98	166.4	165.73	166.311	12136996.0
2013-09-05 10:00:00	SPY	ETF	166.31	166.38	165.86	165.89	13067880.0
2013-09-05 11:00:00	SPY	ETF	165.89	166.19	165.87	166.145	6617407.0
2013-09-05 12:00:00	SPY	ETF	166.1423	166.17	165.96	166.03	4259326.0
2013-09-05 13:00:00	SPY	ETF	166.02	166.22	165.93	165.98	4764722.0
2013-09-05 14:00:00	SPY	ETF	165.98	166.26	165.94	166.17	4591863.0
2013-09-05 15:00:00	SPY	ETF	166.1699	166.19	165.87	165.915	11672083.0
2013-09-05 16:00:00	SPY	ETF	165.92	166.04	165.83	165.85	2138493.0
2013-09-05 17:00:00	SPY	ETF	165.85	165.86	165.76	165.84	2104513.0
2013-09-05 18:00:00	SPY	ETF	165.83	166.0812	165.82	165.95	126430.0
2013-09-05 19:00:00	SPY	ETF	165.94	165.98	165.93	165.98	16234.0
2013-09-05 04:00:00	QQQ	ETF	76.94	76.94	76.75	76.83	29800.0
2013-09-05 05:00:00	QQQ	ETF	76.85	76.87	76.75	76.79	14900.0
2013-09-05 06:00:00	QQQ	ETF	76.81	76.93	76.79	76.88	14200.0
2013-09-05 07:00:00	QQQ	ETF	76.86	76.89	76.81	76.85	65155.0
2013-09-05 08:00:00	QQQ	ETF	76.87	76.98	76.81	76.85	263289.0
2013-09-05 09:00:00	QQQ	ETF	76.85	77.055	76.71	76.96	2938402.0
2013-09-05 10:00:00	QQQ	ETF	76.95	77.005	76.74	76.76	2860763.0
2013-09-05 11:00:00	QQQ	ETF	76.765	76.94	76.75	76.91	1741690.0
2013-09-05 12:00:00	QQQ	ETF	76.9	76.92	76.75	76.8	985699.0
2013-09-05 13:00:00	QQQ	ETF	76.799	76.89	76.75	76.81	1479073.0
2013-09-05 14:00:00	QQQ	ETF	76.8099	76.98	76.78	76.96	1099723.0
2013-09-05 15:00:00	QQQ	ETF	76.9678	76.968	76.8	76.85	2931453.0
2013-09-05 16:00:00	QQQ	ETF	76.84	76.9002	76.82	76.85	698087.0
2013-09-05 17:00:00	QQQ	ETF	76.84	76.84	76.81	76.81	4900.0
2013-09-05 18:00:00	QQQ	ETF	76.83	76.86	76.82	76.86	3073.0
2013-09-05 19:00:00	QQQ	ETF	76.88	76.89	76.88	76.89	2600.0
2013-09-05 04:00:00	IWM	ETF	102.18	102.18	102.18	102.18	100.0
2013-09-05 07:00:00	IWM	ETF	102.09	102.1	102.09	102.1	1400.0
2013-09-05 08:00:00	IWM	ETF	102.11	102.3	102.04	102.11	233732.0
2013-09-05 09:00:00	IWM	ETF	102.08	102.44	101.94	102.3553	2634123.0
2013-09-05 10:00:00	IWM	ETF	102.36	102.41	101.85	101.93	5259384.0
2013-09-05 11:00:00	IWM	ETF	101.93	102.34	101.92	102.29	2325251.0
2013-09-05 12:00:00	IWM	ETF	102.29	102.35	102.16	102.27	1729870.0
2013-09-05 13:00:00	IWM	ETF	102.26	102.52	102.14	102.35	2024525.0
2013-09-05 14:00:00	IWM	ETF	102.35	102.53	102.29	102.5	1925594.0
2013-09-05 15:00:00	IWM	ETF	102.5	102.51	102.14	102.18	4072853.0
2013-09-05 16:00:00	IWM	ETF	102.17	102.5	102.07	102.21	1027086.0
2013-09-05 17:00:00	IWM	ETF	102.2	102.2	102.15	102.16	4200.0
2013-09-05 18:00:00	IWM	ETF	102.2	102.2	102.2	102.2	100.0
2013-09-05 19:00:00	IWM	ETF	102.2	102.2	102.2	102.2	500.0
2013-09-05 04:00:00	DIA	ETF	149.15	149.15	149.15	149.15	200.0
2013-09-05 07:00:00	DIA	ETF	149.08	149.08	149.08	149.08	100.0
2013-09-05 08:00:00	DIA	ETF	149.23	149.31	149.15	149.17	13200.0
2013-09-05 09:00:00	DIA	ETF	149.19	149.71	148.76	149.61	542961.0

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

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