PREVIEW / etf_1hour / 2014-06-24

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-06-24.parquet
  size:    221 KB
  rows:    7,014

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-06-24 04:00:00	SPY	ETF	195.68	195.7	195.51	195.51	2997.0
2014-06-24 05:00:00	SPY	ETF	195.42	195.48	195.23	195.23	22748.0
2014-06-24 06:00:00	SPY	ETF	195.28	195.5	195.28	195.5	34765.0
2014-06-24 07:00:00	SPY	ETF	195.48	195.52	195.38	195.44	125574.0
2014-06-24 08:00:00	SPY	ETF	195.46	195.64	195.43	195.59	335607.0
2014-06-24 09:00:00	SPY	ETF	195.58	195.87	195.5	195.64	7121320.0
2014-06-24 10:00:00	SPY	ETF	195.659	196.44	195.65	196.39	12297870.0
2014-06-24 11:00:00	SPY	ETF	196.39	196.5	196.295	196.3599	8415406.0
2014-06-24 12:00:00	SPY	ETF	196.355	196.37	196.11	196.1444	6608704.0
2014-06-24 13:00:00	SPY	ETF	196.14	196.14	195.56	195.6	13881175.0
2014-06-24 14:00:00	SPY	ETF	195.59	195.79	195.27	195.36	10889413.0
2014-06-24 15:00:00	SPY	ETF	195.36	195.36	194.48	194.7	29893801.0
2014-06-24 16:00:00	SPY	ETF	194.71	195.88	194.6696	194.74	4604250.0
2014-06-24 17:00:00	SPY	ETF	194.74	194.83	194.69	194.73	377955.0
2014-06-24 18:00:00	SPY	ETF	194.75	194.75	194.62	194.67	104313.0
2014-06-24 19:00:00	SPY	ETF	194.67	194.72	194.63	194.7	56855.0
2014-06-24 04:00:00	QQQ	ETF	92.74	92.74	92.64	92.64	600.0
2014-06-24 05:00:00	QQQ	ETF	92.62	92.62	92.5	92.54	3000.0
2014-06-24 06:00:00	QQQ	ETF	92.6	92.6	92.57	92.59	5000.0
2014-06-24 07:00:00	QQQ	ETF	92.6	92.73	92.6	92.73	2400.0
2014-06-24 08:00:00	QQQ	ETF	92.65	92.79	92.65	92.78	26604.0
2014-06-24 09:00:00	QQQ	ETF	92.77	93.11	92.76	93.02	3338557.0
2014-06-24 10:00:00	QQQ	ETF	93.0	93.54	93.0	93.5099	5080370.0
2014-06-24 11:00:00	QQQ	ETF	93.51	93.57	93.485	93.53	2356241.0
2014-06-24 12:00:00	QQQ	ETF	93.53	93.56	93.43	93.48	1736715.0
2014-06-24 13:00:00	QQQ	ETF	93.47	93.485	93.17	93.2255	4710886.0
2014-06-24 14:00:00	QQQ	ETF	93.2201	93.335	93.06	93.13	2817977.0
2014-06-24 15:00:00	QQQ	ETF	93.13	93.13	92.43	92.69	8200970.0
2014-06-24 16:00:00	QQQ	ETF	92.7	93.309	92.67	92.7	1145088.0
2014-06-24 17:00:00	QQQ	ETF	92.69	92.71	92.69	92.71	17750.0
2014-06-24 18:00:00	QQQ	ETF	92.67	92.69	92.64	92.67	4704.0
2014-06-24 19:00:00	QQQ	ETF	92.66	92.69	92.64	92.69	20345.0
2014-06-24 05:00:00	IWM	ETF	117.46	117.46	117.46	117.46	100.0
2014-06-24 06:00:00	IWM	ETF	117.52	117.52	117.52	117.52	100.0
2014-06-24 07:00:00	IWM	ETF	117.55	117.55	117.52	117.52	5900.0
2014-06-24 08:00:00	IWM	ETF	117.65	117.72	117.6	117.71	44225.0
2014-06-24 09:00:00	IWM	ETF	117.71	117.96	117.6	117.62	2091737.0
2014-06-24 10:00:00	IWM	ETF	117.645	118.86	117.59	118.8	5874075.0
2014-06-24 11:00:00	IWM	ETF	118.8	118.91	118.62	118.74	2308033.0
2014-06-24 12:00:00	IWM	ETF	118.735	118.75	118.22	118.32	2019834.0
2014-06-24 13:00:00	IWM	ETF	118.32	118.325	117.52	117.54	5334328.0
2014-06-24 14:00:00	IWM	ETF	117.53	117.79	117.28	117.52	3094222.0
2014-06-24 15:00:00	IWM	ETF	117.515	117.515	116.6528	116.8	10733326.0
2014-06-24 16:00:00	IWM	ETF	116.79	116.87	116.71	116.72	1961221.0
2014-06-24 17:00:00	IWM	ETF	116.71	116.76	116.64	116.64	803700.0
2014-06-24 18:00:00	IWM	ETF	116.73	116.78	116.61	116.61	700.0
2014-06-24 19:00:00	IWM	ETF	116.62	116.78	116.62	116.78	3400.0
2014-06-24 05:00:00	DIA	ETF	168.55	168.55	168.55	168.55	1000.0
2014-06-24 07:00:00	DIA	ETF	168.63	168.63	168.63	168.63	100.0
2014-06-24 08:00:00	DIA	ETF	168.71	168.71	168.71	168.71	100.0

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

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