PREVIEW / etf_1hour / 2014-09-23

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-09-23.parquet
  size:    228 KB
  rows:    7,209

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-09-23 04:00:00	SPY	ETF	198.6	199.04	198.54	198.54	5196.0
2014-09-23 05:00:00	SPY	ETF	198.54	198.62	198.36	198.47	12459.0
2014-09-23 06:00:00	SPY	ETF	198.64	198.64	198.41	198.62	67742.0
2014-09-23 07:00:00	SPY	ETF	198.64	198.72	198.37	198.46	331803.0
2014-09-23 08:00:00	SPY	ETF	198.53	199.23	198.25	198.6	1682020.0
2014-09-23 09:00:00	SPY	ETF	198.6	199.105	198.29	199.04	16503096.0
2014-09-23 10:00:00	SPY	ETF	199.05	199.26	198.67	198.73	16992444.0
2014-09-23 11:00:00	SPY	ETF	198.74	199.0	198.44	198.91	14700175.0
2014-09-23 12:00:00	SPY	ETF	198.91	198.98	198.46	198.5	8075666.0
2014-09-23 13:00:00	SPY	ETF	198.5	198.68	198.18	198.25	10356575.0
2014-09-23 14:00:00	SPY	ETF	198.24	198.43	198.02	198.275	11195793.0
2014-09-23 15:00:00	SPY	ETF	198.271	198.57	197.95	198.0	19451720.0
2014-09-23 16:00:00	SPY	ETF	197.98	199.1075	197.32	197.35	10699088.0
2014-09-23 17:00:00	SPY	ETF	197.37	197.51	197.33	197.45	216538.0
2014-09-23 18:00:00	SPY	ETF	197.45	197.7	197.45	197.67	218207.0
2014-09-23 19:00:00	SPY	ETF	197.67	197.78	197.64	197.78	53884.0
2014-09-23 04:00:00	QQQ	ETF	98.67	98.67	98.56	98.57	17100.0
2014-09-23 05:00:00	QQQ	ETF	98.68	98.68	98.55	98.66	16400.0
2014-09-23 06:00:00	QQQ	ETF	98.69	98.74	98.62	98.74	20000.0
2014-09-23 07:00:00	QQQ	ETF	98.75	98.78	98.61	98.66	62540.0
2014-09-23 08:00:00	QQQ	ETF	98.64	98.8	98.56	98.77	229720.0
2014-09-23 09:00:00	QQQ	ETF	98.78	99.12	98.58	99.08	5573545.0
2014-09-23 10:00:00	QQQ	ETF	99.09	99.22	98.83	98.96	5011674.0
2014-09-23 11:00:00	QQQ	ETF	98.96	99.19	98.84	99.12	3404786.0
2014-09-23 12:00:00	QQQ	ETF	99.1225	99.17	98.98	99.01	2357391.0
2014-09-23 13:00:00	QQQ	ETF	99.0	99.1099	98.8	98.87	3492017.0
2014-09-23 14:00:00	QQQ	ETF	98.865	98.98	98.76	98.8601	3305225.0
2014-09-23 15:00:00	QQQ	ETF	98.86	99.11	98.77	98.79	5841384.0
2014-09-23 16:00:00	QQQ	ETF	98.78	99.0	98.42	98.42	1699011.0
2014-09-23 17:00:00	QQQ	ETF	98.45	98.54	98.43	98.53	52188.0
2014-09-23 18:00:00	QQQ	ETF	98.53	98.68	98.53	98.68	188563.0
2014-09-23 19:00:00	QQQ	ETF	98.67	98.69	98.66	98.68	15200.0
2014-09-23 06:00:00	IWM	ETF	111.77	111.77	111.7	111.7	850.0
2014-09-23 07:00:00	IWM	ETF	111.7	111.78	111.56	111.7	57090.0
2014-09-23 08:00:00	IWM	ETF	111.75	112.36	111.67	112.0	985398.0
2014-09-23 09:00:00	IWM	ETF	112.05	112.54	111.82	112.49	5602844.0
2014-09-23 10:00:00	IWM	ETF	112.4828	112.62	111.99	112.125	5693217.0
2014-09-23 11:00:00	IWM	ETF	112.14	112.46	111.93	112.25	3641050.0
2014-09-23 12:00:00	IWM	ETF	112.25	112.33	111.82	111.82	2378354.0
2014-09-23 13:00:00	IWM	ETF	111.82	111.8899	111.3	111.33	5027538.0
2014-09-23 14:00:00	IWM	ETF	111.33	111.59	111.19	111.45	4283225.0
2014-09-23 15:00:00	IWM	ETF	111.45	111.78	111.29	111.32	8695873.0
2014-09-23 16:00:00	IWM	ETF	111.32	111.35	110.94	110.95	3539259.0
2014-09-23 17:00:00	IWM	ETF	110.97	111.02	110.9	110.99	37968.0
2014-09-23 18:00:00	IWM	ETF	111.0	111.05	110.95	111.02	64184.0
2014-09-23 19:00:00	IWM	ETF	111.05	111.05	111.02	111.05	18118.0
2014-09-23 07:00:00	DIA	ETF	171.14	171.14	170.95	170.97	750.0
2014-09-23 08:00:00	DIA	ETF	170.98	171.01	170.8	170.93	15219.0
2014-09-23 09:00:00	DIA	ETF	170.98	171.22	170.75	171.16	761884.0
2014-09-23 10:00:00	DIA	ETF	171.17	171.38	170.92	170.96	659173.0

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

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