PREVIEW / etf_1hour / 2014-10-17

all etf 1-hour files

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

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-17 04:00:00	SPY	ETF	187.0	188.19	187.0	188.0	41787.0
2014-10-17 05:00:00	SPY	ETF	188.09	188.2	187.82	187.98	90154.0
2014-10-17 06:00:00	SPY	ETF	188.0	188.43	187.82	187.82	405359.0
2014-10-17 07:00:00	SPY	ETF	187.8	188.37	187.75	188.09	1100318.0
2014-10-17 08:00:00	SPY	ETF	188.08	188.41	187.69	187.94	2863724.0
2014-10-17 09:00:00	SPY	ETF	187.94	188.52	187.62	188.2	30597003.0
2014-10-17 10:00:00	SPY	ETF	188.21	189.24	188.04	188.9899	39352650.0
2014-10-17 11:00:00	SPY	ETF	188.985	189.75	188.85	189.399	23207798.0
2014-10-17 12:00:00	SPY	ETF	189.39	189.62	188.79	189.03	18291048.0
2014-10-17 13:00:00	SPY	ETF	189.03	189.24	188.25	188.46	23162374.0
2014-10-17 14:00:00	SPY	ETF	188.465	188.55	187.63	188.4	22251435.0
2014-10-17 15:00:00	SPY	ETF	188.4	189.18	187.77	188.54	38115832.0
2014-10-17 16:00:00	SPY	ETF	188.52	189.1	188.2	188.77	12749672.0
2014-10-17 17:00:00	SPY	ETF	188.77	188.95	188.62	188.89	353845.0
2014-10-17 18:00:00	SPY	ETF	188.9	188.92	188.64	188.64	112741.0
2014-10-17 19:00:00	SPY	ETF	188.65	188.65	187.95	188.55	259157.0
2014-10-17 04:00:00	QQQ	ETF	92.03	92.69	92.03	92.69	2200.0
2014-10-17 05:00:00	QQQ	ETF	92.77	92.85	92.6	92.6	38750.0
2014-10-17 06:00:00	QQQ	ETF	92.68	92.97	92.63	92.77	57070.0
2014-10-17 07:00:00	QQQ	ETF	92.7	92.91	92.64	92.78	93202.0
2014-10-17 08:00:00	QQQ	ETF	92.77	92.99	92.63	92.78	609586.0
2014-10-17 09:00:00	QQQ	ETF	92.78	93.2	92.46	92.97	10586653.0
2014-10-17 10:00:00	QQQ	ETF	92.97	93.475	92.9007	93.33	8770756.0
2014-10-17 11:00:00	QQQ	ETF	93.33	93.89	93.25	93.65	5442966.0
2014-10-17 12:00:00	QQQ	ETF	93.645	93.7498	93.4032	93.51	6715289.0
2014-10-17 13:00:00	QQQ	ETF	93.515	93.59	93.0	93.09	5709956.0
2014-10-17 14:00:00	QQQ	ETF	93.09	93.13	92.68	93.04	6562695.0
2014-10-17 15:00:00	QQQ	ETF	93.0456	93.415	92.703	93.04	12356702.0
2014-10-17 16:00:00	QQQ	ETF	93.03	93.1686	92.86	93.03	2324129.0
2014-10-17 17:00:00	QQQ	ETF	93.03	93.14	92.98	93.14	81519.0
2014-10-17 18:00:00	QQQ	ETF	93.11	93.15	93.0	93.04	1180425.0
2014-10-17 19:00:00	QQQ	ETF	93.05	93.08	92.88	93.05	19499.0
2014-10-17 04:00:00	IWM	ETF	108.6	108.9	108.6	108.79	4991.0
2014-10-17 05:00:00	IWM	ETF	108.87	108.89	108.79	108.79	3450.0
2014-10-17 06:00:00	IWM	ETF	108.88	109.14	108.75	108.8	94830.0
2014-10-17 07:00:00	IWM	ETF	108.8	109.13	108.76	108.8	244100.0
2014-10-17 08:00:00	IWM	ETF	108.8	109.02	108.7	108.72	589511.0
2014-10-17 09:00:00	IWM	ETF	108.7	109.22	108.3	108.66	12198622.0
2014-10-17 10:00:00	IWM	ETF	108.67	109.19	108.24	108.48	10689878.0
2014-10-17 11:00:00	IWM	ETF	108.49	108.62	108.15	108.28	7018273.0
2014-10-17 12:00:00	IWM	ETF	108.28	108.41	107.86	108.13	7227151.0
2014-10-17 13:00:00	IWM	ETF	108.12	108.26	107.52	107.645	6412714.0
2014-10-17 14:00:00	IWM	ETF	107.65	107.66	107.04	107.51	7635377.0
2014-10-17 15:00:00	IWM	ETF	107.51	107.875	107.18	107.47	10264715.0
2014-10-17 16:00:00	IWM	ETF	107.47	107.8758	107.3129	107.55	2604866.0
2014-10-17 17:00:00	IWM	ETF	107.52	107.55	107.43	107.52	48548.0
2014-10-17 18:00:00	IWM	ETF	107.53	107.59	107.43	107.43	4056.0
2014-10-17 07:00:00	DIA	ETF	162.2	162.5	162.2	162.49	500.0
2014-10-17 08:00:00	DIA	ETF	162.16	162.6	162.16	162.33	5839.0
2014-10-17 09:00:00	DIA	ETF	162.25	162.8	162.16	162.54	1939552.0

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

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