PREVIEW / etf_1hour / 2013-08-19

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-08-19.parquet
  size:    210 KB
  rows:    6,501

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
2013-08-19 04:00:00	SPY	ETF	165.7	165.7	165.55	165.62	13104.0
2013-08-19 05:00:00	SPY	ETF	165.62	165.84	165.62	165.71	30061.0
2013-08-19 06:00:00	SPY	ETF	165.71	165.82	165.6	165.63	34100.0
2013-08-19 07:00:00	SPY	ETF	165.64	165.66	165.4	165.46	246186.0
2013-08-19 08:00:00	SPY	ETF	165.44	165.77	165.35	165.67	753203.0
2013-08-19 09:00:00	SPY	ETF	165.67	166.09	165.4	166.08	12739904.0
2013-08-19 10:00:00	SPY	ETF	166.07	166.21	165.83	165.94	12841222.0
2013-08-19 11:00:00	SPY	ETF	165.935	165.97	165.64	165.72	11295964.0
2013-08-19 12:00:00	SPY	ETF	165.71	165.81	165.58	165.73	8042241.0
2013-08-19 13:00:00	SPY	ETF	165.73	165.74	165.26	165.5	7349434.0
2013-08-19 14:00:00	SPY	ETF	165.5	165.5903	165.22	165.38	9891783.0
2013-08-19 15:00:00	SPY	ETF	165.38	165.39	164.76	164.77	21800703.0
2013-08-19 16:00:00	SPY	ETF	164.78	165.8661	164.76	164.955	10143734.0
2013-08-19 17:00:00	SPY	ETF	164.96	164.96	164.92	164.95	141338.0
2013-08-19 18:00:00	SPY	ETF	164.99	165.11	164.97	164.97	85856.0
2013-08-19 19:00:00	SPY	ETF	164.97	165.01	164.97	164.98	20908.0
2013-08-19 04:00:00	QQQ	ETF	75.39	75.43	75.38	75.43	15200.0
2013-08-19 05:00:00	QQQ	ETF	75.45	75.53	75.45	75.49	6300.0
2013-08-19 06:00:00	QQQ	ETF	75.51	75.53	75.43	75.45	8200.0
2013-08-19 07:00:00	QQQ	ETF	75.45	75.47	75.39	75.41	11850.0
2013-08-19 08:00:00	QQQ	ETF	75.4	75.55	75.36	75.51	140761.0
2013-08-19 09:00:00	QQQ	ETF	75.5	75.9	75.41	75.9	3364897.0
2013-08-19 10:00:00	QQQ	ETF	75.9	76.13	75.8922	76.05	3375301.0
2013-08-19 11:00:00	QQQ	ETF	76.05	76.08	75.9	75.94	1370180.0
2013-08-19 12:00:00	QQQ	ETF	75.932	75.9865	75.83	75.95	1113710.0
2013-08-19 13:00:00	QQQ	ETF	75.95	75.9592	75.75	75.89	1388866.0
2013-08-19 14:00:00	QQQ	ETF	75.8825	75.91	75.645	75.69	5466333.0
2013-08-19 15:00:00	QQQ	ETF	75.69	75.7	75.33	75.35	11621020.0
2013-08-19 16:00:00	QQQ	ETF	75.35	76.0168	75.31	75.41	1421740.0
2013-08-19 17:00:00	QQQ	ETF	75.38	75.485	75.33	75.39	18881.0
2013-08-19 18:00:00	QQQ	ETF	75.41	75.45	75.41	75.41	35400.0
2013-08-19 19:00:00	QQQ	ETF	75.41	75.44	75.41	75.43	8550.0
2013-08-19 07:00:00	IWM	ETF	101.45	101.45	101.42	101.42	661.0
2013-08-19 08:00:00	IWM	ETF	101.42	101.69	101.37	101.65	168036.0
2013-08-19 09:00:00	IWM	ETF	101.62	101.76	101.4	101.73	2791778.0
2013-08-19 10:00:00	IWM	ETF	101.73	101.88	101.54	101.64	2762240.0
2013-08-19 11:00:00	IWM	ETF	101.64	101.75	101.5	101.62	2233244.0
2013-08-19 12:00:00	IWM	ETF	101.62	101.68	101.48	101.49	1716284.0
2013-08-19 13:00:00	IWM	ETF	101.495	101.5	101.2	101.31	2475529.0
2013-08-19 14:00:00	IWM	ETF	101.3	101.33	101.02	101.035	3490152.0
2013-08-19 15:00:00	IWM	ETF	101.04	101.04	100.59	100.6	7782096.0
2013-08-19 16:00:00	IWM	ETF	100.6	101.6973	100.6	100.64	961465.0
2013-08-19 17:00:00	IWM	ETF	100.63	100.7	100.63	100.7	32525.0
2013-08-19 19:00:00	IWM	ETF	100.7	100.71	100.67	100.67	1200.0
2013-08-19 07:00:00	DIA	ETF	150.23	150.23	150.23	150.23	300.0
2013-08-19 08:00:00	DIA	ETF	150.19	150.42	150.16	150.42	5400.0
2013-08-19 09:00:00	DIA	ETF	150.3	150.6	150.05	150.58	586193.0
2013-08-19 10:00:00	DIA	ETF	150.58	150.72	150.37	150.55	532482.0
2013-08-19 11:00:00	DIA	ETF	150.56	150.56	150.24	150.33	399626.0
2013-08-19 12:00:00	DIA	ETF	150.33	150.48	150.23	150.45	386401.0

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

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