PREVIEW / etf_1hour / 2013-03-25

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-03-25.parquet
  size:    201 KB
  rows:    6,256

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-03-25 04:00:00	SPY	ETF	155.99	156.2	155.99	156.17	8150.0
2013-03-25 05:00:00	SPY	ETF	156.17	156.45	156.17	156.45	111750.0
2013-03-25 06:00:00	SPY	ETF	156.45	156.47	156.26	156.27	123928.0
2013-03-25 07:00:00	SPY	ETF	156.27	156.31	156.17	156.28	381317.0
2013-03-25 08:00:00	SPY	ETF	156.28	156.3	155.94	155.96	798423.0
2013-03-25 09:00:00	SPY	ETF	155.96	156.25	155.81	156.23	11806289.0
2013-03-25 10:00:00	SPY	ETF	156.23	156.27	155.26	155.3	16400593.0
2013-03-25 11:00:00	SPY	ETF	155.3	155.41	154.8	155.169	22439344.0
2013-03-25 12:00:00	SPY	ETF	155.17	155.4555	154.6	154.64	17180241.0
2013-03-25 13:00:00	SPY	ETF	154.64	155.38	154.35	155.2	24237874.0
2013-03-25 14:00:00	SPY	ETF	155.198	155.34	154.88	155.04	13232768.0
2013-03-25 15:00:00	SPY	ETF	155.04	155.15	154.56	155.0	28876962.0
2013-03-25 16:00:00	SPY	ETF	154.99	156.0444	154.85	155.24	11476236.0
2013-03-25 17:00:00	SPY	ETF	155.24	155.29	155.17	155.25	186243.0
2013-03-25 18:00:00	SPY	ETF	155.26	155.26	155.1	155.24	109087.0
2013-03-25 19:00:00	SPY	ETF	155.22	155.27	155.22	155.24	72773.0
2013-03-25 04:00:00	QQQ	ETF	68.8	68.81	68.8	68.8	682.0
2013-03-25 05:00:00	QQQ	ETF	68.84	68.9	68.84	68.9	1340.0
2013-03-25 06:00:00	QQQ	ETF	68.95	68.96	68.9	68.9	9400.0
2013-03-25 07:00:00	QQQ	ETF	68.87	68.91	68.87	68.89	10960.0
2013-03-25 08:00:00	QQQ	ETF	68.88	68.92	68.8	68.8	57182.0
2013-03-25 09:00:00	QQQ	ETF	68.78	68.86	68.71	68.86	1987271.0
2013-03-25 10:00:00	QQQ	ETF	68.85	68.96	68.4164	68.42	3247556.0
2013-03-25 11:00:00	QQQ	ETF	68.42	68.445	68.13	68.32	4416756.0
2013-03-25 12:00:00	QQQ	ETF	68.32	68.38	68.111	68.16	2433540.0
2013-03-25 13:00:00	QQQ	ETF	68.13	68.55	68.01	68.47	4425767.0
2013-03-25 14:00:00	QQQ	ETF	68.47	68.52	68.28	68.35	2238929.0
2013-03-25 15:00:00	QQQ	ETF	68.359	68.37	68.12	68.3	5074143.0
2013-03-25 16:00:00	QQQ	ETF	68.31	68.78	68.16	68.39	934083.0
2013-03-25 17:00:00	QQQ	ETF	68.38	68.42	68.34	68.4	8000.0
2013-03-25 18:00:00	QQQ	ETF	68.42	68.42	68.34	68.38	6600.0
2013-03-25 19:00:00	QQQ	ETF	68.36	68.39	68.36	68.39	6491.0
2013-03-25 05:00:00	IWM	ETF	94.45	94.45	94.45	94.45	15000.0
2013-03-25 06:00:00	IWM	ETF	94.49	94.49	94.49	94.49	2600.0
2013-03-25 07:00:00	IWM	ETF	94.45	94.47	94.33	94.4	65115.0
2013-03-25 08:00:00	IWM	ETF	94.66	94.66	94.22	94.22	288029.0
2013-03-25 09:00:00	IWM	ETF	94.23	94.55	94.06	94.54	5269696.0
2013-03-25 10:00:00	IWM	ETF	94.54	94.72	93.84	93.86	6346994.0
2013-03-25 11:00:00	IWM	ETF	93.87	93.89	93.51	93.79	5109483.0
2013-03-25 12:00:00	IWM	ETF	93.8	93.87	93.47	93.48	2461660.0
2013-03-25 13:00:00	IWM	ETF	93.479	94.18	93.28	94.1	4433103.0
2013-03-25 14:00:00	IWM	ETF	94.09	94.125	93.765	93.86	2652417.0
2013-03-25 15:00:00	IWM	ETF	93.86	93.95	93.65	93.91	5691921.0
2013-03-25 16:00:00	IWM	ETF	93.92	94.7	93.41	94.02	622021.0
2013-03-25 17:00:00	IWM	ETF	94.06	94.06	93.95	94.0	25375.0
2013-03-25 18:00:00	IWM	ETF	94.0	94.03	94.0	94.03	20100.0
2013-03-25 19:00:00	IWM	ETF	94.03	94.04	94.02	94.03	1520.0
2013-03-25 05:00:00	DIA	ETF	145.35	145.35	145.35	145.35	100.0
2013-03-25 06:00:00	DIA	ETF	145.55	145.55	145.55	145.55	1527.0
2013-03-25 07:00:00	DIA	ETF	145.36	145.4	145.36	145.4	330.0

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

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