PREVIEW / etf_1hour / 2013-03-08

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-03-08.parquet
  size:    203 KB
  rows:    6,340

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-08 04:00:00	SPY	ETF	155.06	155.21	155.06	155.12	7000.0
2013-03-08 05:00:00	SPY	ETF	155.18	155.3	155.13	155.25	11999.0
2013-03-08 06:00:00	SPY	ETF	155.24	155.3	155.15	155.25	84925.0
2013-03-08 07:00:00	SPY	ETF	155.26	155.28	155.09	155.13	307556.0
2013-03-08 08:00:00	SPY	ETF	155.14	155.78	155.09	155.27	4875085.0
2013-03-08 09:00:00	SPY	ETF	155.27	155.6	154.82	155.03	17812624.0
2013-03-08 10:00:00	SPY	ETF	155.03	155.145	154.66	155.04	21621542.0
2013-03-08 11:00:00	SPY	ETF	155.05	155.28	154.89	155.2799	11952046.0
2013-03-08 12:00:00	SPY	ETF	155.2799	155.33	154.94	155.15	10715960.0
2013-03-08 13:00:00	SPY	ETF	155.15	155.32	155.08	155.29	6017262.0
2013-03-08 14:00:00	SPY	ETF	155.29	155.39	155.21	155.321	5393228.0
2013-03-08 15:00:00	SPY	ETF	155.3201	155.65	155.32	155.44	26117946.0
2013-03-08 16:00:00	SPY	ETF	155.43	155.5102	154.8089	155.42	11795045.0
2013-03-08 17:00:00	SPY	ETF	155.42	155.53	155.36	155.47	335769.0
2013-03-08 18:00:00	SPY	ETF	155.48	155.48	155.4	155.44	10660.0
2013-03-08 19:00:00	SPY	ETF	155.44	155.5	155.4	155.47	5459.0
2013-03-08 04:00:00	QQQ	ETF	68.79	68.79	68.79	68.79	4800.0
2013-03-08 06:00:00	QQQ	ETF	68.82	68.86	68.82	68.86	6400.0
2013-03-08 07:00:00	QQQ	ETF	68.86	68.88	68.77	68.78	350320.0
2013-03-08 08:00:00	QQQ	ETF	68.79	69.14	68.76	68.88	685354.0
2013-03-08 09:00:00	QQQ	ETF	68.89	69.02	68.66	68.692	4839010.0
2013-03-08 10:00:00	QQQ	ETF	68.69	68.74	68.5	68.68	5203363.0
2013-03-08 11:00:00	QQQ	ETF	68.6818	68.78	68.6	68.78	3338743.0
2013-03-08 12:00:00	QQQ	ETF	68.77	68.81	68.6	68.67	1900350.0
2013-03-08 13:00:00	QQQ	ETF	68.67	68.76	68.65	68.731	1434752.0
2013-03-08 14:00:00	QQQ	ETF	68.73	68.77	68.71	68.76	1365688.0
2013-03-08 15:00:00	QQQ	ETF	68.7548	68.87	68.75	68.76	4970039.0
2013-03-08 16:00:00	QQQ	ETF	68.76	68.82	68.6455	68.72	906757.0
2013-03-08 17:00:00	QQQ	ETF	68.74	68.79	68.74	68.75	5460.0
2013-03-08 18:00:00	QQQ	ETF	68.75	68.78	68.75	68.78	562.0
2013-03-08 19:00:00	QQQ	ETF	68.78	68.78	68.7	68.7	2260.0
2013-03-08 05:00:00	IWM	ETF	93.18	93.5	93.18	93.45	16350.0
2013-03-08 06:00:00	IWM	ETF	93.45	93.45	93.35	93.36	21450.0
2013-03-08 07:00:00	IWM	ETF	93.35	93.35	93.25	93.28	80247.0
2013-03-08 08:00:00	IWM	ETF	93.28	93.76	92.87	93.48	1933659.0
2013-03-08 09:00:00	IWM	ETF	93.47	93.73	93.06	93.16	6588772.0
2013-03-08 10:00:00	IWM	ETF	93.16	93.34	92.92	93.24	5651423.0
2013-03-08 11:00:00	IWM	ETF	93.24	93.505	93.17	93.47	4188625.0
2013-03-08 12:00:00	IWM	ETF	93.48	93.53	93.24	93.41	3433549.0
2013-03-08 13:00:00	IWM	ETF	93.4	93.57	93.36	93.46	2254734.0
2013-03-08 14:00:00	IWM	ETF	93.46	93.62	93.39	93.52	2842888.0
2013-03-08 15:00:00	IWM	ETF	93.52	93.75	93.52	93.72	6952971.0
2013-03-08 16:00:00	IWM	ETF	93.72	93.73	93.53	93.56	1879451.0
2013-03-08 17:00:00	IWM	ETF	93.59	93.61	93.55	93.55	50200.0
2013-03-08 18:00:00	IWM	ETF	93.56	93.6	93.56	93.6	600.0
2013-03-08 19:00:00	IWM	ETF	93.64	93.65	93.62	93.65	31480.0
2013-03-08 06:00:00	DIA	ETF	143.7	143.7	143.7	143.7	500.0
2013-03-08 07:00:00	DIA	ETF	143.7	143.71	143.62	143.62	2400.0
2013-03-08 08:00:00	DIA	ETF	143.6	144.09	143.6	143.88	126872.0
2013-03-08 09:00:00	DIA	ETF	143.87	144.02	143.37	143.46	1248442.0

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

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