PREVIEW / etf_1hour / 2012-12-18

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-12-18.parquet
  size:    200 KB
  rows:    6,186

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-12-18 04:00:00	SPY	ETF	144.42	144.57	144.39	144.5	13360.0
2012-12-18 05:00:00	SPY	ETF	144.51	144.58	144.36	144.36	1666.0
2012-12-18 06:00:00	SPY	ETF	144.3	144.5	144.3	144.48	2195.0
2012-12-18 07:00:00	SPY	ETF	144.43	144.55	144.39	144.55	285772.0
2012-12-18 08:00:00	SPY	ETF	144.55	144.68	144.03	144.07	5278018.0
2012-12-18 09:00:00	SPY	ETF	144.08	144.22	143.79	143.87	21611194.0
2012-12-18 10:00:00	SPY	ETF	143.86	144.75	143.8	144.62	26471048.0
2012-12-18 11:00:00	SPY	ETF	144.62	145.02	144.6	144.765	18940910.0
2012-12-18 12:00:00	SPY	ETF	144.77	145.46	144.73	145.31	16973822.0
2012-12-18 13:00:00	SPY	ETF	145.31	145.35	145.07	145.1599	13031575.0
2012-12-18 14:00:00	SPY	ETF	145.15	145.27	144.85	145.03	18318039.0
2012-12-18 15:00:00	SPY	ETF	145.03	145.5	144.94	145.35	34688619.0
2012-12-18 16:00:00	SPY	ETF	145.34	145.45	143.7346	145.22	13535771.0
2012-12-18 17:00:00	SPY	ETF	145.22	145.31	143.7346	145.23	7214254.0
2012-12-18 18:00:00	SPY	ETF	145.23	145.36	145.16	145.28	146575.0
2012-12-18 19:00:00	SPY	ETF	145.27	145.33	145.17	145.3	26792.0
2012-12-18 04:00:00	QQQ	ETF	65.91	65.96	65.91	65.96	21400.0
2012-12-18 06:00:00	QQQ	ETF	65.88	65.95	65.88	65.95	16500.0
2012-12-18 07:00:00	QQQ	ETF	65.94	66.1	65.9	66.05	269383.0
2012-12-18 08:00:00	QQQ	ETF	66.05	66.1	65.85	65.87	318210.0
2012-12-18 09:00:00	QQQ	ETF	65.9	65.94	65.7	65.75	5700274.0
2012-12-18 10:00:00	QQQ	ETF	65.75	66.2	65.7	66.12	9225112.0
2012-12-18 11:00:00	QQQ	ETF	66.13	66.43	66.0999	66.339	6598982.0
2012-12-18 12:00:00	QQQ	ETF	66.33	66.6387	66.28	66.61	4807362.0
2012-12-18 13:00:00	QQQ	ETF	66.61	66.61	66.43	66.46	3534047.0
2012-12-18 14:00:00	QQQ	ETF	66.46	66.55	66.32	66.451	5537657.0
2012-12-18 15:00:00	QQQ	ETF	66.4545	66.65	66.37	66.57	9145090.0
2012-12-18 16:00:00	QQQ	ETF	66.56	66.6502	65.5618	66.54	2695652.0
2012-12-18 17:00:00	QQQ	ETF	66.54	66.61	65.5618	66.61	2870663.0
2012-12-18 18:00:00	QQQ	ETF	66.57	66.58	66.46	66.52	29794.0
2012-12-18 19:00:00	QQQ	ETF	66.52	66.57	66.49	66.57	7999.0
2012-12-18 07:00:00	IWM	ETF	83.84	83.87	83.79	83.87	160800.0
2012-12-18 08:00:00	IWM	ETF	83.83	83.93	83.5	83.74	1230137.0
2012-12-18 09:00:00	IWM	ETF	83.74	83.94	83.49	83.86	4819607.0
2012-12-18 10:00:00	IWM	ETF	83.86	84.38	83.84	84.3	7571954.0
2012-12-18 11:00:00	IWM	ETF	84.31	84.42	84.25	84.26	4036236.0
2012-12-18 12:00:00	IWM	ETF	84.26	84.6001	84.23	84.562	4287140.0
2012-12-18 13:00:00	IWM	ETF	84.57	84.65	84.47	84.565	3649370.0
2012-12-18 14:00:00	IWM	ETF	84.57	84.7	84.5	84.591	5339681.0
2012-12-18 15:00:00	IWM	ETF	84.595	84.77	84.47	84.69	9870461.0
2012-12-18 16:00:00	IWM	ETF	84.69	84.78	83.9109	84.76	3465446.0
2012-12-18 17:00:00	IWM	ETF	84.77	84.83	84.76	84.77	82604.0
2012-12-18 18:00:00	IWM	ETF	84.77	84.77	84.77	84.77	400.0
2012-12-18 19:00:00	IWM	ETF	84.73	84.73	84.68	84.71	5525.0
2012-12-18 07:00:00	DIA	ETF	132.97	133.0	132.95	133.0	5300.0
2012-12-18 08:00:00	DIA	ETF	132.98	133.07	132.7	132.7	21865.0
2012-12-18 09:00:00	DIA	ETF	132.79	132.8	132.46	132.46	933046.0
2012-12-18 10:00:00	DIA	ETF	132.47	133.065	132.38	132.98	1330842.0
2012-12-18 11:00:00	DIA	ETF	132.98	133.36	132.97	133.17	733381.0
2012-12-18 12:00:00	DIA	ETF	133.17	133.68	133.16	133.6201	571293.0

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

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