PREVIEW / etf_1hour / 2014-10-14

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-10-14.parquet
  size:    236 KB
  rows:    7,481

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
2014-10-14 04:00:00	SPY	ETF	187.8	188.11	187.43	187.46	23067.0
2014-10-14 05:00:00	SPY	ETF	187.34	187.51	187.04	187.27	112738.0
2014-10-14 06:00:00	SPY	ETF	187.28	187.83	187.26	187.71	235804.0
2014-10-14 07:00:00	SPY	ETF	187.69	187.95	187.21	187.95	1121860.0
2014-10-14 08:00:00	SPY	ETF	188.04	188.65	187.45	188.25	3241259.0
2014-10-14 09:00:00	SPY	ETF	188.25	189.03	187.59	187.83	30175395.0
2014-10-14 10:00:00	SPY	ETF	187.83	188.94	187.51	188.49	38989634.0
2014-10-14 11:00:00	SPY	ETF	188.49	189.68	188.36	189.5	25022920.0
2014-10-14 12:00:00	SPY	ETF	189.51	189.82	188.72	189.04	16227606.0
2014-10-14 13:00:00	SPY	ETF	189.035	189.47	188.36	188.86	14530809.0
2014-10-14 14:00:00	SPY	ETF	188.85	189.08	187.81	188.092	22620120.0
2014-10-14 15:00:00	SPY	ETF	188.1	188.36	187.04	187.75	49545318.0
2014-10-14 16:00:00	SPY	ETF	187.75	188.33	187.6511	188.33	10271757.0
2014-10-14 17:00:00	SPY	ETF	188.33	188.37	188.2	188.34	1915101.0
2014-10-14 18:00:00	SPY	ETF	188.35	188.67	188.35	188.47	336325.0
2014-10-14 19:00:00	SPY	ETF	188.5	188.81	188.47	188.67	158886.0
2014-10-14 04:00:00	QQQ	ETF	93.22	93.29	93.01	93.01	25267.0
2014-10-14 05:00:00	QQQ	ETF	92.97	93.01	92.85	92.92	54700.0
2014-10-14 06:00:00	QQQ	ETF	93.0	93.17	92.99	93.17	36200.0
2014-10-14 07:00:00	QQQ	ETF	93.0	93.23	92.71	93.23	192981.0
2014-10-14 08:00:00	QQQ	ETF	93.24	93.71	92.96	93.51	787652.0
2014-10-14 09:00:00	QQQ	ETF	93.51	93.88	92.84	93.01	12363265.0
2014-10-14 10:00:00	QQQ	ETF	93.01	93.77	92.73	93.51	13662704.0
2014-10-14 11:00:00	QQQ	ETF	93.52	94.129	93.42	94.0199	8144046.0
2014-10-14 12:00:00	QQQ	ETF	94.01	94.1699	93.54	93.7	4563025.0
2014-10-14 13:00:00	QQQ	ETF	93.7	93.91	93.24	93.51	5635986.0
2014-10-14 14:00:00	QQQ	ETF	93.5	93.68	92.94	93.16	7237850.0
2014-10-14 15:00:00	QQQ	ETF	93.18	93.46	92.71	92.98	14369611.0
2014-10-14 16:00:00	QQQ	ETF	92.98	93.34	92.8888	93.3	2778641.0
2014-10-14 17:00:00	QQQ	ETF	93.3	93.5	93.27	93.48	161736.0
2014-10-14 18:00:00	QQQ	ETF	93.46	93.57	93.45	93.5	68400.0
2014-10-14 19:00:00	QQQ	ETF	93.5	93.63	93.48	93.56	23062.0
2014-10-14 04:00:00	IWM	ETF	104.8	104.88	104.8	104.88	200.0
2014-10-14 05:00:00	IWM	ETF	104.8	104.8	104.64	104.71	3750.0
2014-10-14 06:00:00	IWM	ETF	104.86	105.0	104.69	105.0	12034.0
2014-10-14 07:00:00	IWM	ETF	105.0	105.1	104.72	105.1	102604.0
2014-10-14 08:00:00	IWM	ETF	105.1	105.52	105.08	105.23	697738.0
2014-10-14 09:00:00	IWM	ETF	105.22	106.08	104.9	105.12	9742727.0
2014-10-14 10:00:00	IWM	ETF	105.13	106.21	104.97	105.83	13250800.0
2014-10-14 11:00:00	IWM	ETF	105.83	106.75	105.72	106.54	8880858.0
2014-10-14 12:00:00	IWM	ETF	106.558	106.99	105.87	106.2	5911980.0
2014-10-14 13:00:00	IWM	ETF	106.21	106.57	105.66	106.07	3656818.0
2014-10-14 14:00:00	IWM	ETF	106.07	106.19	105.4	105.615	5531146.0
2014-10-14 15:00:00	IWM	ETF	105.615	105.8	104.86	105.46	10287552.0
2014-10-14 16:00:00	IWM	ETF	105.46	106.3625	105.438	105.73	1993807.0
2014-10-14 17:00:00	IWM	ETF	105.8	106.01	105.707	106.01	183513.0
2014-10-14 18:00:00	IWM	ETF	106.0	106.05	105.88	105.92	6936.0
2014-10-14 19:00:00	IWM	ETF	106.0	106.1	106.0	106.09	7422.0
2014-10-14 04:00:00	DIA	ETF	163.13	163.13	163.13	163.13	10120.0
2014-10-14 06:00:00	DIA	ETF	163.15	163.15	163.15	163.15	100.0

> showing 50 of 7,481 rows — these rows as CSV

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