PREVIEW / etf_1hour / 2012-12-03

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-12-03.parquet
  size:    190 KB
  rows:    5,918

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-03 04:00:00	SPY	ETF	142.33	142.33	142.1	142.16	5050.0
2012-12-03 05:00:00	SPY	ETF	142.11	142.41	142.11	142.38	13400.0
2012-12-03 06:00:00	SPY	ETF	142.37	142.54	142.37	142.51	144161.0
2012-12-03 07:00:00	SPY	ETF	142.53	143.02	142.5	142.69	1386574.0
2012-12-03 08:00:00	SPY	ETF	142.72	142.85	142.06	142.79	941969.0
2012-12-03 09:00:00	SPY	ETF	142.8	142.92	142.52	142.58	14860406.0
2012-12-03 10:00:00	SPY	ETF	142.59	142.6	141.95	142.04	22667249.0
2012-12-03 11:00:00	SPY	ETF	142.0499	142.3	141.9	142.28	12632816.0
2012-12-03 12:00:00	SPY	ETF	142.285	142.3	142.03	142.05	6973191.0
2012-12-03 13:00:00	SPY	ETF	142.04	142.04	141.56	141.73	10198797.0
2012-12-03 14:00:00	SPY	ETF	141.72	141.91	141.57	141.6999	11211382.0
2012-12-03 15:00:00	SPY	ETF	141.7	141.96	141.34	141.46	25873667.0
2012-12-03 16:00:00	SPY	ETF	141.46	142.1698	141.19	141.27	11057229.0
2012-12-03 17:00:00	SPY	ETF	141.26	142.1368	141.16	141.25	1123121.0
2012-12-03 18:00:00	SPY	ETF	141.28	141.35	141.25	141.33	40595.0
2012-12-03 19:00:00	SPY	ETF	141.3	141.3	141.04	141.11	238841.0
2012-12-03 04:00:00	QQQ	ETF	66.03	66.04	66.03	66.04	300.0
2012-12-03 05:00:00	QQQ	ETF	66.02	66.09	66.0	66.09	4200.0
2012-12-03 06:00:00	QQQ	ETF	66.07	66.13	66.07	66.13	13744.0
2012-12-03 07:00:00	QQQ	ETF	66.14	66.36	66.14	66.22	78173.0
2012-12-03 08:00:00	QQQ	ETF	66.23	66.28	65.94	66.27	137748.0
2012-12-03 09:00:00	QQQ	ETF	66.27	66.37	66.19	66.2801	4353904.0
2012-12-03 10:00:00	QQQ	ETF	66.26	66.281	65.92	65.98	5909699.0
2012-12-03 11:00:00	QQQ	ETF	65.99	66.09	65.89	66.09	2555363.0
2012-12-03 12:00:00	QQQ	ETF	66.0801	66.1	65.91	65.91	2019397.0
2012-12-03 13:00:00	QQQ	ETF	65.91	65.93	65.76	65.863	2819790.0
2012-12-03 14:00:00	QQQ	ETF	65.86	65.92	65.74	65.8115	1999918.0
2012-12-03 15:00:00	QQQ	ETF	65.82	65.94	65.64	65.705	5860794.0
2012-12-03 16:00:00	QQQ	ETF	65.71	65.9547	65.6	65.65	1628270.0
2012-12-03 17:00:00	QQQ	ETF	65.63	65.63	65.59	65.62	40456.0
2012-12-03 18:00:00	QQQ	ETF	65.64	65.68	65.63	65.67	20595.0
2012-12-03 19:00:00	QQQ	ETF	65.65	65.65	65.53	65.57	22769.0
2012-12-03 04:00:00	IWM	ETF	82.35	82.35	82.35	82.35	100.0
2012-12-03 07:00:00	IWM	ETF	82.74	82.9	82.57	82.75	67640.0
2012-12-03 08:00:00	IWM	ETF	82.75	82.85	82.11	82.72	475559.0
2012-12-03 09:00:00	IWM	ETF	82.71	82.76	82.06	82.07	4147599.0
2012-12-03 10:00:00	IWM	ETF	82.07	82.24	81.8	81.97	4684080.0
2012-12-03 11:00:00	IWM	ETF	81.97	82.12	81.84	82.1	2048561.0
2012-12-03 12:00:00	IWM	ETF	82.1	82.14	81.99	82.01	1699992.0
2012-12-03 13:00:00	IWM	ETF	82.0	82.01	81.75	81.86	1403079.0
2012-12-03 14:00:00	IWM	ETF	81.86	82.08	81.82	81.94	1946778.0
2012-12-03 15:00:00	IWM	ETF	81.94	82.09	81.79	82.0	6426138.0
2012-12-03 16:00:00	IWM	ETF	82.0	82.11	81.89	81.92	825095.0
2012-12-03 17:00:00	IWM	ETF	81.92	81.95	81.89	81.89	55830.0
2012-12-03 19:00:00	IWM	ETF	81.9	81.9	81.87	81.87	15658.0
2012-12-03 06:00:00	DIA	ETF	130.56	130.56	130.56	130.56	1500.0
2012-12-03 07:00:00	DIA	ETF	130.57	130.78	130.57	130.74	15200.0
2012-12-03 08:00:00	DIA	ETF	130.65	130.79	130.65	130.74	8432.0
2012-12-03 09:00:00	DIA	ETF	130.73	130.8	130.38	130.41	596720.0
2012-12-03 10:00:00	DIA	ETF	130.41	130.41	129.81	129.88	1011001.0

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

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