PREVIEW / etf_1hour / 2014-02-03

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-02-03.parquet
  size:    232 KB
  rows:    7,205

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-02-03 04:00:00	SPY	ETF	178.32	178.32	177.81	177.88	55084.0
2014-02-03 05:00:00	SPY	ETF	177.93	178.11	177.62	177.72	40500.0
2014-02-03 06:00:00	SPY	ETF	177.73	178.2	177.68	178.06	222028.0
2014-02-03 07:00:00	SPY	ETF	178.09	178.55	178.01	178.55	229492.0
2014-02-03 08:00:00	SPY	ETF	178.11	178.66	178.08	178.13	969323.0
2014-02-03 09:00:00	SPY	ETF	178.14	178.37	177.4	177.69	18469225.0
2014-02-03 10:00:00	SPY	ETF	177.68	177.94	176.21	176.4799	39312965.0
2014-02-03 11:00:00	SPY	ETF	176.47	176.4799	175.33	175.41	30050685.0
2014-02-03 12:00:00	SPY	ETF	175.4	175.61	174.98	175.3	23947129.0
2014-02-03 13:00:00	SPY	ETF	175.295	175.395	174.28	174.5064	28496653.0
2014-02-03 14:00:00	SPY	ETF	174.5	174.86	174.05	174.05	28022961.0
2014-02-03 15:00:00	SPY	ETF	174.05	174.475	173.83	174.17	56988373.0
2014-02-03 16:00:00	SPY	ETF	174.18	178.1575	173.73	174.15	20117678.0
2014-02-03 17:00:00	SPY	ETF	174.17	178.1574	174.0	174.21	1326099.0
2014-02-03 18:00:00	SPY	ETF	174.21	174.4	174.14	174.3	245509.0
2014-02-03 19:00:00	SPY	ETF	174.3	174.5	174.17	174.5	214363.0
2014-02-03 04:00:00	QQQ	ETF	86.3	86.3	86.3	86.3	100.0
2014-02-03 05:00:00	QQQ	ETF	86.13	86.16	85.97	85.97	10600.0
2014-02-03 06:00:00	QQQ	ETF	85.99	86.28	85.99	86.18	3619.0
2014-02-03 07:00:00	QQQ	ETF	86.22	86.46	86.18	86.46	61920.0
2014-02-03 08:00:00	QQQ	ETF	86.43	86.49	86.24	86.25	594977.0
2014-02-03 09:00:00	QQQ	ETF	86.24	86.5	85.81	86.07	4921178.0
2014-02-03 10:00:00	QQQ	ETF	86.01	86.01	85.24	85.4899	10716271.0
2014-02-03 11:00:00	QQQ	ETF	85.48	85.51	84.9305	84.97	8075913.0
2014-02-03 12:00:00	QQQ	ETF	84.96	85.0899	84.71	84.84	6859425.0
2014-02-03 13:00:00	QQQ	ETF	84.84	84.9	84.13	84.27	10608613.0
2014-02-03 14:00:00	QQQ	ETF	84.26	84.51	84.08	84.08	5692465.0
2014-02-03 15:00:00	QQQ	ETF	84.09	84.41	84.07	84.3	10894155.0
2014-02-03 16:00:00	QQQ	ETF	84.31	86.2465	84.16	84.36	4083646.0
2014-02-03 17:00:00	QQQ	ETF	84.35	84.35	84.26	84.3	25532.0
2014-02-03 18:00:00	QQQ	ETF	84.35	84.46	84.35	84.46	8768.0
2014-02-03 19:00:00	QQQ	ETF	84.48	84.51	84.38	84.49	10162.0
2014-02-03 04:00:00	IWM	ETF	111.88	111.88	111.88	111.88	200.0
2014-02-03 05:00:00	IWM	ETF	111.88	111.88	111.88	111.88	100.0
2014-02-03 06:00:00	IWM	ETF	112.0	112.0	112.0	112.0	1000.0
2014-02-03 07:00:00	IWM	ETF	112.06	112.36	111.99	112.36	56600.0
2014-02-03 08:00:00	IWM	ETF	112.37	112.5	112.1	112.15	541646.0
2014-02-03 09:00:00	IWM	ETF	112.07	112.2	111.06	111.67	7813635.0
2014-02-03 10:00:00	IWM	ETF	111.67	111.69	110.34	110.58	13403144.0
2014-02-03 11:00:00	IWM	ETF	110.58	110.58	109.32	109.34	9889375.0
2014-02-03 12:00:00	IWM	ETF	109.34	109.51	109.01	109.07	10158076.0
2014-02-03 13:00:00	IWM	ETF	109.07	109.145	108.15	108.5	10011671.0
2014-02-03 14:00:00	IWM	ETF	108.5	109.08	108.32	108.32	8366819.0
2014-02-03 15:00:00	IWM	ETF	108.32	108.83	108.295	108.71	13704332.0
2014-02-03 16:00:00	IWM	ETF	108.71	112.2411	108.4	108.7	7151075.0
2014-02-03 17:00:00	IWM	ETF	108.66	108.69	108.62	108.62	10945.0
2014-02-03 18:00:00	IWM	ETF	108.7	108.8	108.65	108.8	4780.0
2014-02-03 19:00:00	IWM	ETF	108.8	108.85	108.62	108.85	15793.0
2014-02-03 07:00:00	DIA	ETF	156.85	156.85	156.85	156.85	100.0
2014-02-03 08:00:00	DIA	ETF	157.18	157.18	156.75	156.75	26500.0

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

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