PREVIEW / etf_1hour / 2014-08-19

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-08-19.parquet
  size:    218 KB
  rows:    6,979

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-08-19 04:00:00	SPY	ETF	197.65	197.68	197.64	197.65	2038.0
2014-08-19 05:00:00	SPY	ETF	197.68	197.75	197.61	197.67	7124.0
2014-08-19 06:00:00	SPY	ETF	197.65	197.65	197.52	197.57	24793.0
2014-08-19 07:00:00	SPY	ETF	197.51	197.72	197.51	197.71	88603.0
2014-08-19 08:00:00	SPY	ETF	197.72	197.99	197.56	197.77	765560.0
2014-08-19 09:00:00	SPY	ETF	197.78	198.05	197.645	197.995	9636795.0
2014-08-19 10:00:00	SPY	ETF	198.0	198.25	197.88	198.185	11084550.0
2014-08-19 11:00:00	SPY	ETF	198.18	198.23	198.08	198.175	5555939.0
2014-08-19 12:00:00	SPY	ETF	198.17	198.35	198.14	198.285	3960522.0
2014-08-19 13:00:00	SPY	ETF	198.285	198.36	198.2525	198.28	5188259.0
2014-08-19 14:00:00	SPY	ETF	198.285	198.52	198.28	198.48	6617665.0
2014-08-19 15:00:00	SPY	ETF	198.475	198.54	198.37	198.39	10715402.0
2014-08-19 16:00:00	SPY	ETF	198.38	198.43	197.4041	198.28	4743684.0
2014-08-19 17:00:00	SPY	ETF	198.3	198.33	198.28	198.31	41063.0
2014-08-19 18:00:00	SPY	ETF	198.32	198.32	198.25	198.285	53347.0
2014-08-19 19:00:00	SPY	ETF	198.3	198.32	198.23	198.23	116300.0
2014-08-19 04:00:00	QQQ	ETF	98.25	98.3	98.25	98.3	400.0
2014-08-19 05:00:00	QQQ	ETF	98.29	98.29	98.29	98.29	300.0
2014-08-19 06:00:00	QQQ	ETF	98.29	98.29	98.26	98.26	47400.0
2014-08-19 07:00:00	QQQ	ETF	98.28	98.35	98.25	98.34	41950.0
2014-08-19 08:00:00	QQQ	ETF	98.33	98.43	98.28	98.34	171874.0
2014-08-19 09:00:00	QQQ	ETF	98.34	98.5	98.32	98.46	3007366.0
2014-08-19 10:00:00	QQQ	ETF	98.451	98.5	98.35	98.45	3650088.0
2014-08-19 11:00:00	QQQ	ETF	98.46	98.5	98.4	98.46	1814613.0
2014-08-19 12:00:00	QQQ	ETF	98.455	98.57	98.41	98.52	2329108.0
2014-08-19 13:00:00	QQQ	ETF	98.52	98.63	98.52	98.63	1798025.0
2014-08-19 14:00:00	QQQ	ETF	98.625	98.74	98.58	98.71	2028823.0
2014-08-19 15:00:00	QQQ	ETF	98.71	98.76	98.69	98.71	3444763.0
2014-08-19 16:00:00	QQQ	ETF	98.71	98.7249	98.5129	98.63	1384820.0
2014-08-19 17:00:00	QQQ	ETF	98.62	98.68	98.6	98.68	18617.0
2014-08-19 18:00:00	QQQ	ETF	98.67	98.67	98.6	98.61	13261.0
2014-08-19 19:00:00	QQQ	ETF	98.61	98.62	98.6	98.6	30848.0
2014-08-19 04:00:00	IWM	ETF	115.16	115.16	115.16	115.16	500.0
2014-08-19 06:00:00	IWM	ETF	115.01	115.01	114.8	114.8	3000.0
2014-08-19 07:00:00	IWM	ETF	114.92	115.02	114.84	114.98	6390.0
2014-08-19 08:00:00	IWM	ETF	114.97	115.31	114.9	115.12	136147.0
2014-08-19 09:00:00	IWM	ETF	115.1	115.58	115.06	115.54	4566150.0
2014-08-19 10:00:00	IWM	ETF	115.54	115.73	115.361	115.64	3350673.0
2014-08-19 11:00:00	IWM	ETF	115.635	115.65	115.39	115.6	2194101.0
2014-08-19 12:00:00	IWM	ETF	115.61	115.66	115.43	115.5	1469880.0
2014-08-19 13:00:00	IWM	ETF	115.495	115.56	115.375	115.4	1189968.0
2014-08-19 14:00:00	IWM	ETF	115.4	115.59	115.39	115.5	1270465.0
2014-08-19 15:00:00	IWM	ETF	115.495	115.55	115.41	115.44	3029442.0
2014-08-19 16:00:00	IWM	ETF	115.45	115.46	115.29	115.38	1862803.0
2014-08-19 17:00:00	IWM	ETF	115.41	115.44	115.38	115.44	2096.0
2014-08-19 18:00:00	IWM	ETF	115.34	115.34	115.34	115.34	200.0
2014-08-19 04:00:00	DIA	ETF	168.35	168.35	168.35	168.35	499.0
2014-08-19 08:00:00	DIA	ETF	168.51	168.6	168.51	168.53	2000.0
2014-08-19 09:00:00	DIA	ETF	168.57	168.69	168.33	168.61	505466.0
2014-08-19 10:00:00	DIA	ETF	168.61	168.825	168.53	168.8	471410.0

> showing 50 of 6,979 rows — these rows as CSV

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