PREVIEW / etf_1hour / 2013-05-21

all etf 1-hour files

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

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-05-21 04:00:00	SPY	ETF	167.05	167.11	166.83	166.84	57760.0
2013-05-21 05:00:00	SPY	ETF	166.78	166.83	166.65	166.72	40307.0
2013-05-21 06:00:00	SPY	ETF	166.75	166.88	166.75	166.83	34570.0
2013-05-21 07:00:00	SPY	ETF	166.85	166.85	166.62	166.84	134192.0
2013-05-21 08:00:00	SPY	ETF	166.85	167.08	166.85	167.07	420246.0
2013-05-21 09:00:00	SPY	ETF	167.07	167.52	167.01	167.34	11141377.0
2013-05-21 10:00:00	SPY	ETF	167.34	167.42	166.5	166.705	18714983.0
2013-05-21 11:00:00	SPY	ETF	166.71	167.2	166.7	167.085	10952518.0
2013-05-21 12:00:00	SPY	ETF	167.09	167.4	167.09	167.32	7062834.0
2013-05-21 13:00:00	SPY	ETF	167.33	167.76	167.31	167.51	9741629.0
2013-05-21 14:00:00	SPY	ETF	167.505	167.8	167.31	167.4808	10240944.0
2013-05-21 15:00:00	SPY	ETF	167.483	167.59	167.14	167.19	15955895.0
2013-05-21 16:00:00	SPY	ETF	167.18	167.4727	166.6199	167.07	6754251.0
2013-05-21 17:00:00	SPY	ETF	167.09	167.12	167.05	167.09	99517.0
2013-05-21 18:00:00	SPY	ETF	167.09	167.12	167.06	167.1	69610.0
2013-05-21 19:00:00	SPY	ETF	167.12	167.15	167.09	167.15	33772.0
2013-05-21 04:00:00	QQQ	ETF	74.26	74.26	74.26	74.26	100.0
2013-05-21 05:00:00	QQQ	ETF	74.07	74.07	74.05	74.05	3851.0
2013-05-21 06:00:00	QQQ	ETF	74.11	74.13	74.11	74.11	700.0
2013-05-21 07:00:00	QQQ	ETF	74.11	74.11	74.05	74.11	10800.0
2013-05-21 08:00:00	QQQ	ETF	74.17	74.22	74.16	74.22	77137.0
2013-05-21 09:00:00	QQQ	ETF	74.22	74.319	74.105	74.27	2546296.0
2013-05-21 10:00:00	QQQ	ETF	74.27	74.3	73.89	74.03	4854954.0
2013-05-21 11:00:00	QQQ	ETF	74.04	74.27	74.03	74.21	3432987.0
2013-05-21 12:00:00	QQQ	ETF	74.21	74.39	74.21	74.37	2866820.0
2013-05-21 13:00:00	QQQ	ETF	74.3601	74.51	74.36	74.41	2563656.0
2013-05-21 14:00:00	QQQ	ETF	74.41	74.54	74.27	74.359	4358219.0
2013-05-21 15:00:00	QQQ	ETF	74.36	74.4499	74.265	74.27	3665066.0
2013-05-21 16:00:00	QQQ	ETF	74.26	74.3399	74.1383	74.18	1465098.0
2013-05-21 17:00:00	QQQ	ETF	74.17	74.18	74.16	74.18	7424.0
2013-05-21 18:00:00	QQQ	ETF	74.18	74.22	74.18	74.22	13965.0
2013-05-21 19:00:00	QQQ	ETF	74.22	74.22	74.19	74.22	4700.0
2013-05-21 05:00:00	IWM	ETF	99.05	99.05	98.9	98.9	200.0
2013-05-21 06:00:00	IWM	ETF	99.05	99.05	99.05	99.05	1000.0
2013-05-21 07:00:00	IWM	ETF	98.88	98.98	98.88	98.98	13484.0
2013-05-21 08:00:00	IWM	ETF	99.0	99.16	99.0	99.16	62719.0
2013-05-21 09:00:00	IWM	ETF	99.19	99.47	99.14	99.41	2549943.0
2013-05-21 10:00:00	IWM	ETF	99.41	99.47	98.88	99.08	6726819.0
2013-05-21 11:00:00	IWM	ETF	99.08	99.24	98.96	99.19	2419586.0
2013-05-21 12:00:00	IWM	ETF	99.19	99.4	99.19	99.375	2188025.0
2013-05-21 13:00:00	IWM	ETF	99.38	99.55	99.37	99.43	1725625.0
2013-05-21 14:00:00	IWM	ETF	99.43	99.55	99.31	99.39	1552420.0
2013-05-21 15:00:00	IWM	ETF	99.4	99.48	99.19	99.28	3702377.0
2013-05-21 16:00:00	IWM	ETF	99.27	99.31	99.22	99.3	750645.0
2013-05-21 17:00:00	IWM	ETF	99.28	99.29	99.23	99.23	17000.0
2013-05-21 18:00:00	IWM	ETF	99.3	99.32	99.3	99.32	5868.0
2013-05-21 19:00:00	IWM	ETF	99.32	99.32	99.28	99.3	8284.0
2013-05-21 06:00:00	DIA	ETF	153.03	153.03	153.03	153.03	260.0
2013-05-21 08:00:00	DIA	ETF	153.24	153.26	153.15	153.26	4000.0
2013-05-21 09:00:00	DIA	ETF	153.27	153.66	153.26	153.5201	1045937.0

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

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