PREVIEW / etf_1hour / 2015-09-29

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-09-29.parquet
  size:    245 KB
  rows:    7,895

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
2015-09-29 04:00:00	SPY	ETF	188.35	189.35	188.24	189.06	95401.0
2015-09-29 05:00:00	SPY	ETF	189.08	189.11	188.4	188.49	44336.0
2015-09-29 06:00:00	SPY	ETF	188.67	189.03	188.53	189.02	51817.0
2015-09-29 07:00:00	SPY	ETF	188.98	189.06	188.59	188.85	425640.0
2015-09-29 08:00:00	SPY	ETF	188.81	189.32	187.73	189.1	917970.0
2015-09-29 09:00:00	SPY	ETF	189.1	189.13	187.37	188.63	21103418.0
2015-09-29 10:00:00	SPY	ETF	188.67	189.74	188.32	188.99	26954110.0
2015-09-29 11:00:00	SPY	ETF	188.99	189.3	188.12	188.44	12912748.0
2015-09-29 12:00:00	SPY	ETF	188.43	188.545	187.65	187.7	13764269.0
2015-09-29 13:00:00	SPY	ETF	187.71	188.92	187.66	188.68	13514559.0
2015-09-29 14:00:00	SPY	ETF	188.68	188.72	187.61	187.62	17165309.0
2015-09-29 15:00:00	SPY	ETF	187.62	188.46	186.93	188.05	39642107.0
2015-09-29 16:00:00	SPY	ETF	188.06	188.58	187.94	188.21	10278042.0
2015-09-29 17:00:00	SPY	ETF	188.22	188.35	188.12	188.34	646744.0
2015-09-29 18:00:00	SPY	ETF	188.29	188.55	188.22	188.41	219300.0
2015-09-29 19:00:00	SPY	ETF	188.36	188.53	188.26	188.3	28855.0
2015-09-29 04:00:00	QQQ	ETF	100.3	100.8	100.3	100.75	18480.0
2015-09-29 05:00:00	QQQ	ETF	100.68	100.68	100.49	100.49	1250.0
2015-09-29 06:00:00	QQQ	ETF	100.56	100.61	100.38	100.6	9621.0
2015-09-29 07:00:00	QQQ	ETF	100.64	100.64	100.44	100.5	31819.0
2015-09-29 08:00:00	QQQ	ETF	100.5	100.78	99.79	100.65	297022.0
2015-09-29 09:00:00	QQQ	ETF	100.65	100.66	99.52	100.48	6952353.0
2015-09-29 10:00:00	QQQ	ETF	100.49	101.26	100.29	100.75	9331340.0
2015-09-29 11:00:00	QQQ	ETF	100.75	100.95	100.23	100.38	4748638.0
2015-09-29 12:00:00	QQQ	ETF	100.38	100.46	99.67	99.68	4125692.0
2015-09-29 13:00:00	QQQ	ETF	99.71	100.46	99.68	100.29	3521693.0
2015-09-29 14:00:00	QQQ	ETF	100.29	100.32	99.3999	99.3999	4612373.0
2015-09-29 15:00:00	QQQ	ETF	99.41	99.71	98.75	99.48	11580901.0
2015-09-29 16:00:00	QQQ	ETF	99.48	99.75	99.4	99.51	1074962.0
2015-09-29 17:00:00	QQQ	ETF	99.49	99.59	99.47	99.59	440419.0
2015-09-29 18:00:00	QQQ	ETF	99.6	99.75	99.57	99.62	83831.0
2015-09-29 19:00:00	QQQ	ETF	99.59	99.66	99.55	99.55	26283.0
2015-09-29 04:00:00	IWM	ETF	108.15	108.18	108.15	108.18	400.0
2015-09-29 05:00:00	IWM	ETF	108.5	108.5	108.5	108.5	100.0
2015-09-29 06:00:00	IWM	ETF	108.54	108.61	108.39	108.61	4400.0
2015-09-29 07:00:00	IWM	ETF	108.62	108.69	108.35	108.5	40088.0
2015-09-29 08:00:00	IWM	ETF	108.44	108.77	108.41	108.6	87236.0
2015-09-29 09:00:00	IWM	ETF	108.6	108.67	107.5	108.51	7116661.0
2015-09-29 10:00:00	IWM	ETF	108.53	109.11	108.2	108.49	9389344.0
2015-09-29 11:00:00	IWM	ETF	108.51	108.68	107.88	108.11	5038758.0
2015-09-29 12:00:00	IWM	ETF	108.12	108.24	107.62	107.6533	3729287.0
2015-09-29 13:00:00	IWM	ETF	107.6506	108.33	107.645	108.095	3055928.0
2015-09-29 14:00:00	IWM	ETF	108.1	108.11	107.54	107.55	4298882.0
2015-09-29 15:00:00	IWM	ETF	107.56	107.78	106.99	107.55	11696355.0
2015-09-29 16:00:00	IWM	ETF	107.56	108.0084	107.3143	107.43	1255724.0
2015-09-29 17:00:00	IWM	ETF	107.44	107.55	107.44	107.54	1621802.0
2015-09-29 18:00:00	IWM	ETF	107.58	107.69	107.58	107.62	3270.0
2015-09-29 19:00:00	IWM	ETF	107.6	107.69	107.6	107.6	4240.0
2015-09-29 05:00:00	DIA	ETF	160.34	160.38	160.33	160.36	16585.0
2015-09-29 06:00:00	DIA	ETF	160.34	160.34	160.34	160.34	400.0

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

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