PREVIEW / etf_1hour / 2013-05-17

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-05-17.parquet
  size:    204 KB
  rows:    6,344

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-05-17 04:00:00	SPY	ETF	165.7	165.7	165.43	165.49	15050.0
2013-05-17 05:00:00	SPY	ETF	165.58	165.88	165.58	165.76	86660.0
2013-05-17 06:00:00	SPY	ETF	165.78	165.9	165.67	165.76	84100.0
2013-05-17 07:00:00	SPY	ETF	165.755	165.81	165.67	165.78	296418.0
2013-05-17 08:00:00	SPY	ETF	165.78	166.03	165.3257	165.97	3603768.0
2013-05-17 09:00:00	SPY	ETF	165.97	166.21	165.73	166.18	15966425.0
2013-05-17 10:00:00	SPY	ETF	166.19	166.36	166.01	166.02	19225332.0
2013-05-17 11:00:00	SPY	ETF	166.021	166.24	165.83	166.12	11547470.0
2013-05-17 12:00:00	SPY	ETF	166.11	166.18	165.97	166.05	6251222.0
2013-05-17 13:00:00	SPY	ETF	166.055	166.2	166.04	166.14	5049107.0
2013-05-17 14:00:00	SPY	ETF	166.14	166.76	166.12	166.74	17908103.0
2013-05-17 15:00:00	SPY	ETF	166.75	167.04	166.66	166.97	32599528.0
2013-05-17 16:00:00	SPY	ETF	166.97	167.05	165.3258	166.9	15862671.0
2013-05-17 17:00:00	SPY	ETF	166.9	167.02	166.9	167.02	237186.0
2013-05-17 18:00:00	SPY	ETF	167.0	167.04	166.95	167.0	23734.0
2013-05-17 19:00:00	SPY	ETF	167.01	167.02	166.84	166.88	59051.0
2013-05-17 04:00:00	QQQ	ETF	73.69	73.69	73.6	73.6	3200.0
2013-05-17 05:00:00	QQQ	ETF	73.69	73.7	73.69	73.7	250.0
2013-05-17 06:00:00	QQQ	ETF	73.68	73.73	73.66	73.73	11000.0
2013-05-17 07:00:00	QQQ	ETF	73.74	73.78	73.72	73.78	51100.0
2013-05-17 08:00:00	QQQ	ETF	73.79	73.89	73.79	73.85	165725.0
2013-05-17 09:00:00	QQQ	ETF	73.84	74.12	73.6	73.94	3805414.0
2013-05-17 10:00:00	QQQ	ETF	73.95	74.05	73.88	73.93	3275505.0
2013-05-17 11:00:00	QQQ	ETF	73.92	73.96	73.76	73.908	4849991.0
2013-05-17 12:00:00	QQQ	ETF	73.91	73.93	73.79	73.89	1323218.0
2013-05-17 13:00:00	QQQ	ETF	73.89	73.93	73.8001	73.88	2140154.0
2013-05-17 14:00:00	QQQ	ETF	73.89	74.18	73.8601	74.1601	2942182.0
2013-05-17 15:00:00	QQQ	ETF	74.165	74.33	74.1	74.3	6387444.0
2013-05-17 16:00:00	QQQ	ETF	74.3	74.35	73.5998	74.24	5233773.0
2013-05-17 17:00:00	QQQ	ETF	74.23	74.28	74.23	74.28	12319.0
2013-05-17 18:00:00	QQQ	ETF	74.27	74.3	74.23	74.3	1635.0
2013-05-17 19:00:00	QQQ	ETF	74.31	74.33	74.31	74.32	2563.0
2013-05-17 06:00:00	IWM	ETF	98.66	98.98	98.35	98.35	5190.0
2013-05-17 07:00:00	IWM	ETF	98.24	98.25	98.19	98.24	103600.0
2013-05-17 08:00:00	IWM	ETF	98.26	98.45	98.04	98.37	196432.0
2013-05-17 09:00:00	IWM	ETF	98.36	98.64	98.25	98.55	4674710.0
2013-05-17 10:00:00	IWM	ETF	98.55	98.91	98.5	98.73	4199587.0
2013-05-17 11:00:00	IWM	ETF	98.73	98.77	98.54	98.61	2504450.0
2013-05-17 12:00:00	IWM	ETF	98.62	98.8	98.525	98.67	2073897.0
2013-05-17 13:00:00	IWM	ETF	98.67	98.75	98.58	98.69	1321098.0
2013-05-17 14:00:00	IWM	ETF	98.69	98.995	98.67	98.97	3601975.0
2013-05-17 15:00:00	IWM	ETF	98.971	99.0715	98.9	99.03	7621324.0
2013-05-17 16:00:00	IWM	ETF	99.02	99.08	98.92	99.0	2375307.0
2013-05-17 17:00:00	IWM	ETF	99.02	99.07	99.0	99.05	54793.0
2013-05-17 18:00:00	IWM	ETF	99.05	99.05	99.02	99.05	500.0
2013-05-17 19:00:00	IWM	ETF	99.05	99.05	98.98	99.05	3811.0
2013-05-17 07:00:00	DIA	ETF	152.47	152.47	152.36	152.44	12191.0
2013-05-17 08:00:00	DIA	ETF	152.44	152.54	152.42	152.54	76250.0
2013-05-17 09:00:00	DIA	ETF	152.49	152.61	152.21	152.54	843679.0
2013-05-17 10:00:00	DIA	ETF	152.55	152.72	152.46	152.52	601143.0

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

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