PREVIEW / etf_1hour / 2012-11-16

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-11-16.parquet
  size:    193 KB
  rows:    5,976

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-11-16 04:00:00	SPY	ETF	135.68	135.74	135.21	135.27	14100.0
2012-11-16 05:00:00	SPY	ETF	135.13	135.33	135.12	135.29	20942.0
2012-11-16 06:00:00	SPY	ETF	135.34	135.69	135.3	135.69	42290.0
2012-11-16 07:00:00	SPY	ETF	135.68	135.83	135.42	135.83	905511.0
2012-11-16 08:00:00	SPY	ETF	135.79	136.36	135.425	136.17	2989640.0
2012-11-16 09:00:00	SPY	ETF	136.18	136.29	135.21	135.35	25546260.0
2012-11-16 10:00:00	SPY	ETF	135.36	135.63	134.87	135.25	31904653.0
2012-11-16 11:00:00	SPY	ETF	135.26	136.23	134.7	136.22	49215794.0
2012-11-16 12:00:00	SPY	ETF	136.22	136.57	135.96	136.195	29153487.0
2012-11-16 13:00:00	SPY	ETF	136.18	136.34	135.87	136.23	26376874.0
2012-11-16 14:00:00	SPY	ETF	136.24	136.28	135.47	136.015	22760145.0
2012-11-16 15:00:00	SPY	ETF	136.02	136.64	135.835	136.39	31842661.0
2012-11-16 16:00:00	SPY	ETF	136.36	136.7374	135.7365	136.68	14107795.0
2012-11-16 17:00:00	SPY	ETF	136.68	136.69	136.64	136.68	2004478.0
2012-11-16 18:00:00	SPY	ETF	136.69	136.72	136.68	136.7	83705.0
2012-11-16 19:00:00	SPY	ETF	136.71	136.83	136.69	136.83	84034.0
2012-11-16 04:00:00	QQQ	ETF	62.02	62.02	61.87	61.87	5300.0
2012-11-16 05:00:00	QQQ	ETF	61.87	61.94	61.83	61.94	42400.0
2012-11-16 06:00:00	QQQ	ETF	61.9	61.97	61.9	61.97	2400.0
2012-11-16 07:00:00	QQQ	ETF	62.0	62.05	61.84	61.97	942345.0
2012-11-16 08:00:00	QQQ	ETF	62.02	62.34	61.86	62.23	1390056.0
2012-11-16 09:00:00	QQQ	ETF	62.24	62.26	61.64	61.77	6489884.0
2012-11-16 10:00:00	QQQ	ETF	61.76	61.92	61.55	61.77	8600095.0
2012-11-16 11:00:00	QQQ	ETF	61.7701	62.08	61.31	62.07	9311761.0
2012-11-16 12:00:00	QQQ	ETF	62.08	62.47	62.0	62.28	7926008.0
2012-11-16 13:00:00	QQQ	ETF	62.279	62.34	62.1	62.32	3007069.0
2012-11-16 14:00:00	QQQ	ETF	62.32	62.34	61.91	62.1799	4317506.0
2012-11-16 15:00:00	QQQ	ETF	62.18	62.48	62.04	62.28	8927729.0
2012-11-16 16:00:00	QQQ	ETF	62.28	62.45	62.0521	62.45	7314645.0
2012-11-16 17:00:00	QQQ	ETF	62.46	62.53	62.45	62.45	74510.0
2012-11-16 18:00:00	QQQ	ETF	62.46	62.49	62.42	62.49	12930.0
2012-11-16 19:00:00	QQQ	ETF	62.46	62.48	62.42	62.44	10111.0
2012-11-16 06:00:00	IWM	ETF	76.8	76.88	76.8	76.88	11400.0
2012-11-16 07:00:00	IWM	ETF	76.88	76.88	76.67	76.73	24200.0
2012-11-16 08:00:00	IWM	ETF	76.85	77.2	76.84	77.05	261543.0
2012-11-16 09:00:00	IWM	ETF	77.06	77.17	76.21	76.34	7069368.0
2012-11-16 10:00:00	IWM	ETF	76.34	76.75	76.15	76.38	7909619.0
2012-11-16 11:00:00	IWM	ETF	76.37	77.11	76.13	77.08	8025324.0
2012-11-16 12:00:00	IWM	ETF	77.077	77.29	76.86	77.14	5313983.0
2012-11-16 13:00:00	IWM	ETF	77.13	77.22	76.98	77.15	2714130.0
2012-11-16 14:00:00	IWM	ETF	77.145	77.26	76.72	77.21	4924728.0
2012-11-16 15:00:00	IWM	ETF	77.21	77.68	77.1	77.49	10732292.0
2012-11-16 16:00:00	IWM	ETF	77.48	77.57	76.2365	77.54	2427147.0
2012-11-16 17:00:00	IWM	ETF	77.54	77.6	77.53	77.6	857100.0
2012-11-16 18:00:00	IWM	ETF	77.63	77.65	77.63	77.65	4200.0
2012-11-16 19:00:00	IWM	ETF	77.64	77.64	77.64	77.64	100.0
2012-11-16 04:00:00	DIA	ETF	125.25	125.25	124.87	124.87	300.0
2012-11-16 05:00:00	DIA	ETF	124.83	124.95	124.83	124.95	200.0
2012-11-16 06:00:00	DIA	ETF	124.97	124.97	124.96	124.97	400.0
2012-11-16 07:00:00	DIA	ETF	125.21	125.21	124.93	124.94	743.0

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

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