PREVIEW / etf_1hour / 2012-06-28

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-06-28.parquet
  size:    183 KB
  rows:    5,647

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
2012-06-28 04:00:00	SPY	ETF	132.66	132.66	132.24	132.4	10900.0
2012-06-28 05:00:00	SPY	ETF	132.4	132.58	132.23	132.28	27503.0
2012-06-28 06:00:00	SPY	ETF	132.15	132.59	132.15	132.5	109509.0
2012-06-28 07:00:00	SPY	ETF	132.48	133.09	132.35	132.45	1038693.0
2012-06-28 08:00:00	SPY	ETF	132.45	133.17	132.27	132.38	1824021.0
2012-06-28 09:00:00	SPY	ETF	132.38	133.17	132.02	132.32	17362611.0
2012-06-28 10:00:00	SPY	ETF	132.31	132.47	131.41	131.565	36166555.0
2012-06-28 11:00:00	SPY	ETF	131.57	131.98	131.42	131.83	15951546.0
2012-06-28 12:00:00	SPY	ETF	131.82	131.95	131.61	131.819	13379652.0
2012-06-28 13:00:00	SPY	ETF	131.82	131.91	131.46	131.71	12019147.0
2012-06-28 14:00:00	SPY	ETF	131.71	131.75	131.28	131.5899	12993416.0
2012-06-28 15:00:00	SPY	ETF	131.59	132.99	131.561	132.79	49021484.0
2012-06-28 16:00:00	SPY	ETF	132.79	132.98	131.49	132.6	6766160.0
2012-06-28 17:00:00	SPY	ETF	132.59	133.1581	132.53	132.68	765159.0
2012-06-28 18:00:00	SPY	ETF	132.68	132.68	132.39	132.49	147618.0
2012-06-28 19:00:00	SPY	ETF	132.44	132.44	132.21	132.38	153725.0
2012-06-28 06:00:00	QQQ	ETF	62.46	62.46	62.46	62.46	100.0
2012-06-28 07:00:00	QQQ	ETF	62.54	62.78	62.53	62.53	28365.0
2012-06-28 08:00:00	QQQ	ETF	62.56	62.58	62.49	62.5	126590.0
2012-06-28 09:00:00	QQQ	ETF	62.49	62.5	62.01	62.33	6245410.0
2012-06-28 10:00:00	QQQ	ETF	62.33	62.35	61.76	61.85	10032305.0
2012-06-28 11:00:00	QQQ	ETF	61.85	62.0199	61.77	61.92	4015559.0
2012-06-28 12:00:00	QQQ	ETF	61.91	61.99	61.79	61.87	3164532.0
2012-06-28 13:00:00	QQQ	ETF	61.8755	61.91	61.6335	61.76	4418112.0
2012-06-28 14:00:00	QQQ	ETF	61.77	61.8	61.54	61.64	2819885.0
2012-06-28 15:00:00	QQQ	ETF	61.65	62.26	61.64	62.19	10326234.0
2012-06-28 16:00:00	QQQ	ETF	62.19	62.8994	61.7868	62.1	2452475.0
2012-06-28 17:00:00	QQQ	ETF	62.07	62.15	62.04	62.1	48201.0
2012-06-28 18:00:00	QQQ	ETF	62.1	62.1	62.0	62.05	10176.0
2012-06-28 19:00:00	QQQ	ETF	62.05	62.05	61.91	61.97	15673.0
2012-06-28 05:00:00	IWM	ETF	77.02	77.02	77.02	77.02	200.0
2012-06-28 07:00:00	IWM	ETF	76.9	77.25	76.8	76.89	53911.0
2012-06-28 08:00:00	IWM	ETF	76.9	76.95	76.76	76.85	364277.0
2012-06-28 09:00:00	IWM	ETF	76.82	77.35	76.67	77.11	5551496.0
2012-06-28 10:00:00	IWM	ETF	77.11	77.2	76.24	76.47	15472637.0
2012-06-28 11:00:00	IWM	ETF	76.47	76.77	76.34	76.608	3982976.0
2012-06-28 12:00:00	IWM	ETF	76.59	76.675	76.36	76.49	3168623.0
2012-06-28 13:00:00	IWM	ETF	76.49	76.4901	76.22	76.35	4438696.0
2012-06-28 14:00:00	IWM	ETF	76.36	76.4	76.12	76.37	2980661.0
2012-06-28 15:00:00	IWM	ETF	76.37	77.37	76.35	77.25	14454407.0
2012-06-28 16:00:00	IWM	ETF	77.25	77.46	76.29	77.11	5996882.0
2012-06-28 17:00:00	IWM	ETF	77.14	77.14	77.05	77.13	25810.0
2012-06-28 18:00:00	IWM	ETF	77.09	77.13	77.09	77.13	6600.0
2012-06-28 19:00:00	IWM	ETF	76.99	76.99	76.88	76.88	2995.0
2012-06-28 07:00:00	DIA	ETF	125.6	125.61	125.6	125.61	1600.0
2012-06-28 08:00:00	DIA	ETF	125.39	125.39	125.1	125.26	4600.0
2012-06-28 09:00:00	DIA	ETF	125.12	125.2	124.9	125.03	654115.0
2012-06-28 10:00:00	DIA	ETF	125.05	125.19	124.36	124.4882	1221293.0
2012-06-28 11:00:00	DIA	ETF	124.47	124.8	124.36	124.71	525739.0
2012-06-28 12:00:00	DIA	ETF	124.71	124.85	124.5505	124.73	498898.0

> showing 50 of 5,647 rows — these rows as CSV

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