PREVIEW / etf_1hour / 2012-11-15

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-11-15.parquet
  size:    196 KB
  rows:    6,040

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-15 04:00:00	SPY	ETF	136.38	136.4	136.2	136.38	12708.0
2012-11-15 05:00:00	SPY	ETF	136.37	136.54	136.28	136.52	27360.0
2012-11-15 06:00:00	SPY	ETF	136.41	136.43	136.3	136.32	42774.0
2012-11-15 07:00:00	SPY	ETF	136.26	136.26	135.88	136.1	840682.0
2012-11-15 08:00:00	SPY	ETF	136.1	136.29	135.61	135.83	2485332.0
2012-11-15 09:00:00	SPY	ETF	135.82	136.4901	135.69	135.83	19436661.0
2012-11-15 10:00:00	SPY	ETF	135.83	136.42	135.52	135.72	26685922.0
2012-11-15 11:00:00	SPY	ETF	135.715	135.86	135.19	135.349	23589732.0
2012-11-15 12:00:00	SPY	ETF	135.345	135.63	135.18	135.415	18774469.0
2012-11-15 13:00:00	SPY	ETF	135.41	136.29	135.28	136.05	19254828.0
2012-11-15 14:00:00	SPY	ETF	136.045	136.05	135.59	135.73	15431424.0
2012-11-15 15:00:00	SPY	ETF	135.72	135.97	135.21	135.67	39205361.0
2012-11-15 16:00:00	SPY	ETF	135.69	136.108	135.4184	135.84	8966776.0
2012-11-15 17:00:00	SPY	ETF	135.86	135.87	135.71	135.72	206122.0
2012-11-15 18:00:00	SPY	ETF	135.72	135.81	135.66	135.66	65891.0
2012-11-15 19:00:00	SPY	ETF	135.68	135.68	135.45	135.49	122082.0
2012-11-15 04:00:00	QQQ	ETF	62.3	62.36	62.3	62.36	200.0
2012-11-15 05:00:00	QQQ	ETF	62.38	62.44	62.38	62.44	600.0
2012-11-15 06:00:00	QQQ	ETF	62.38	62.38	62.33	62.33	16300.0
2012-11-15 07:00:00	QQQ	ETF	62.34	62.34	62.19	62.32	18558.0
2012-11-15 08:00:00	QQQ	ETF	62.2	62.48	62.18	62.3	310799.0
2012-11-15 09:00:00	QQQ	ETF	62.32	62.49	62.1	62.14	5110846.0
2012-11-15 10:00:00	QQQ	ETF	62.14	62.48	62.02	62.0401	6133018.0
2012-11-15 11:00:00	QQQ	ETF	62.05	62.11	61.85	61.93	6352120.0
2012-11-15 12:00:00	QQQ	ETF	61.934	62.12	61.88	61.9999	3040812.0
2012-11-15 13:00:00	QQQ	ETF	61.99	62.32	61.93	62.21	4478201.0
2012-11-15 14:00:00	QQQ	ETF	62.21	62.23	62.04	62.081	3573007.0
2012-11-15 15:00:00	QQQ	ETF	62.088	62.18	61.8	62.01	11500056.0
2012-11-15 16:00:00	QQQ	ETF	62.01	62.2347	61.8701	62.09	8346621.0
2012-11-15 17:00:00	QQQ	ETF	62.09	62.2347	62.0	62.02	3526733.0
2012-11-15 18:00:00	QQQ	ETF	62.02	62.09	62.02	62.09	37800.0
2012-11-15 19:00:00	QQQ	ETF	62.05	62.05	61.94	61.97	29480.0
2012-11-15 07:00:00	IWM	ETF	77.19	77.19	77.19	77.19	100.0
2012-11-15 08:00:00	IWM	ETF	77.36	77.36	76.91	77.0	1549319.0
2012-11-15 09:00:00	IWM	ETF	77.0	77.49	76.85	76.97	4509242.0
2012-11-15 10:00:00	IWM	ETF	76.97	77.34	76.75	76.8	6878215.0
2012-11-15 11:00:00	IWM	ETF	76.81	76.86	76.54	76.63	5112143.0
2012-11-15 12:00:00	IWM	ETF	76.62	76.67	76.29	76.39	8129734.0
2012-11-15 13:00:00	IWM	ETF	76.39	77.1511	76.3399	76.995	6369753.0
2012-11-15 14:00:00	IWM	ETF	76.99	77.02	76.665	76.81	3820180.0
2012-11-15 15:00:00	IWM	ETF	76.8	76.87	76.41	76.85	9345951.0
2012-11-15 16:00:00	IWM	ETF	76.87	76.88	76.74	76.83	1358888.0
2012-11-15 17:00:00	IWM	ETF	76.88	76.88	76.81	76.81	1090.0
2012-11-15 18:00:00	IWM	ETF	76.77	76.77	76.77	76.77	100.0
2012-11-15 19:00:00	IWM	ETF	76.76	76.76	76.68	76.68	4680.0
2012-11-15 04:00:00	DIA	ETF	126.0	126.0	126.0	126.0	400.0
2012-11-15 05:00:00	DIA	ETF	126.1	126.1	126.1	126.1	100.0
2012-11-15 07:00:00	DIA	ETF	125.96	125.96	125.61	125.66	2119.0
2012-11-15 08:00:00	DIA	ETF	125.69	125.83	125.32	125.5	31449.0
2012-11-15 09:00:00	DIA	ETF	125.56	126.05	125.42	125.56	1122315.0

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

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