PREVIEW / etf_1hour / 2014-10-21

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-10-21.parquet
  size:    239 KB
  rows:    7,522

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-21 04:00:00	SPY	ETF	190.36	190.81	190.36	190.78	13297.0
2014-10-21 05:00:00	SPY	ETF	190.7	191.23	190.45	191.07	85642.0
2014-10-21 06:00:00	SPY	ETF	191.1	192.2	191.09	192.05	497961.0
2014-10-21 07:00:00	SPY	ETF	192.07	192.18	191.28	191.44	1653989.0
2014-10-21 08:00:00	SPY	ETF	191.42	192.18	191.23	191.85	2020809.0
2014-10-21 09:00:00	SPY	ETF	191.82	192.36	191.48	192.157	21109257.0
2014-10-21 10:00:00	SPY	ETF	192.16	192.77	192.0	192.6	25626770.0
2014-10-21 11:00:00	SPY	ETF	192.595	193.33	192.55	193.22	21838223.0
2014-10-21 12:00:00	SPY	ETF	193.215	193.39	192.93	193.02	13569294.0
2014-10-21 13:00:00	SPY	ETF	193.01	193.54	192.85	193.45	13059497.0
2014-10-21 14:00:00	SPY	ETF	193.45	193.75	193.35	193.57	13376304.0
2014-10-21 15:00:00	SPY	ETF	193.57	194.2	193.52	194.05	30435776.0
2014-10-21 16:00:00	SPY	ETF	194.05	194.51	193.2398	194.5	9294191.0
2014-10-21 17:00:00	SPY	ETF	194.47	194.54	194.07	194.4	1308895.0
2014-10-21 18:00:00	SPY	ETF	194.4	194.41	194.23	194.26	180746.0
2014-10-21 19:00:00	SPY	ETF	194.26	194.29	194.19	194.26	267915.0
2014-10-21 04:00:00	QQQ	ETF	94.69	94.69	94.63	94.63	1300.0
2014-10-21 05:00:00	QQQ	ETF	94.8	95.02	94.72	94.96	25100.0
2014-10-21 06:00:00	QQQ	ETF	94.98	95.47	94.98	95.39	77500.0
2014-10-21 07:00:00	QQQ	ETF	95.45	95.47	95.04	95.15	332020.0
2014-10-21 08:00:00	QQQ	ETF	95.12	95.45	95.08	95.44	393854.0
2014-10-21 09:00:00	QQQ	ETF	95.43	95.72	95.32	95.63	7405809.0
2014-10-21 10:00:00	QQQ	ETF	95.63	95.96	95.48	95.9398	7599949.0
2014-10-21 11:00:00	QQQ	ETF	95.939	96.27	95.91	96.17	5596945.0
2014-10-21 12:00:00	QQQ	ETF	96.165	96.3099	96.12	96.15	3193854.0
2014-10-21 13:00:00	QQQ	ETF	96.15	96.54	96.08	96.47	5525531.0
2014-10-21 14:00:00	QQQ	ETF	96.475	96.71	96.41	96.611	6156294.0
2014-10-21 15:00:00	QQQ	ETF	96.61	96.87	96.595	96.86	9509740.0
2014-10-21 16:00:00	QQQ	ETF	96.87	97.29	96.3389	97.18	2467313.0
2014-10-21 17:00:00	QQQ	ETF	97.18	97.2	96.876	97.08	135232.0
2014-10-21 18:00:00	QQQ	ETF	97.07	97.12	96.87	97.0	40276.0
2014-10-21 19:00:00	QQQ	ETF	97.0	97.01	96.98	97.0	34664.0
2014-10-21 04:00:00	IWM	ETF	108.96	108.96	108.96	108.96	200.0
2014-10-21 06:00:00	IWM	ETF	109.34	109.34	109.25	109.32	2300.0
2014-10-21 07:00:00	IWM	ETF	109.45	109.58	109.2	109.31	341901.0
2014-10-21 08:00:00	IWM	ETF	109.28	109.57	109.11	109.4	333497.0
2014-10-21 09:00:00	IWM	ETF	109.39	109.68	109.01	109.5	5457553.0
2014-10-21 10:00:00	IWM	ETF	109.53	110.24	109.4415	110.08	7508245.0
2014-10-21 11:00:00	IWM	ETF	110.09	110.28	109.87	109.91	6246074.0
2014-10-21 12:00:00	IWM	ETF	109.92	110.09	109.79	109.87	2937435.0
2014-10-21 13:00:00	IWM	ETF	109.87	110.21	109.76	110.1799	3021570.0
2014-10-21 14:00:00	IWM	ETF	110.17	110.46	110.12	110.315	4451276.0
2014-10-21 15:00:00	IWM	ETF	110.315	110.59	110.28	110.5	8615693.0
2014-10-21 16:00:00	IWM	ETF	110.51	110.72	109.9046	110.69	1859052.0
2014-10-21 17:00:00	IWM	ETF	110.67	110.71	110.1	110.7	50260.0
2014-10-21 18:00:00	IWM	ETF	110.61	110.62	110.59	110.62	3153.0
2014-10-21 19:00:00	IWM	ETF	110.59	110.59	110.53	110.53	876.0
2014-10-21 04:00:00	DIA	ETF	163.65	163.65	163.65	163.65	150.0
2014-10-21 05:00:00	DIA	ETF	164.18	164.18	164.16	164.16	200.0
2014-10-21 06:00:00	DIA	ETF	164.6	164.6	164.6	164.6	100.0

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

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