PREVIEW / etf_1hour / 2013-01-18

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-01-18.parquet
  size:    195 KB
  rows:    6,092

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
2013-01-18 04:00:00	SPY	ETF	148.16	148.16	147.93	148.0	1450.0
2013-01-18 05:00:00	SPY	ETF	147.96	147.96	147.91	147.91	2791.0
2013-01-18 06:00:00	SPY	ETF	148.02	148.03	147.88	147.95	40919.0
2013-01-18 07:00:00	SPY	ETF	147.91	148.06	147.8	147.93	247156.0
2013-01-18 08:00:00	SPY	ETF	147.94	148.12	147.84	148.0	753199.0
2013-01-18 09:00:00	SPY	ETF	148.0	148.09	147.69	147.87	15009110.0
2013-01-18 10:00:00	SPY	ETF	147.87	147.9754	147.67	147.69	20827325.0
2013-01-18 11:00:00	SPY	ETF	147.685	147.9754	147.43	147.55	45440439.0
2013-01-18 12:00:00	SPY	ETF	147.54	147.86	147.54	147.81	9554845.0
2013-01-18 13:00:00	SPY	ETF	147.82	148.06	147.81	147.965	11640567.0
2013-01-18 14:00:00	SPY	ETF	147.965	148.13	147.94	148.01	8058897.0
2013-01-18 15:00:00	SPY	ETF	148.01	148.49	147.97	148.33	34564278.0
2013-01-18 16:00:00	SPY	ETF	148.33	148.4831	147.84	148.29	13150067.0
2013-01-18 17:00:00	SPY	ETF	148.29	148.48	147.9755	148.44	7067518.0
2013-01-18 18:00:00	SPY	ETF	148.43	148.44	148.37	148.4	11819.0
2013-01-18 19:00:00	SPY	ETF	148.4	148.41	148.32	148.35	43358.0
2013-01-18 06:00:00	QQQ	ETF	67.11	67.12	67.03	67.03	1944.0
2013-01-18 07:00:00	QQQ	ETF	67.02	67.05	66.95	67.02	46158.0
2013-01-18 08:00:00	QQQ	ETF	67.05	67.06	66.99	67.02	155652.0
2013-01-18 09:00:00	QQQ	ETF	67.22	67.22	66.88	67.07	4356979.0
2013-01-18 10:00:00	QQQ	ETF	67.07	67.1	66.88	66.91	5341176.0
2013-01-18 11:00:00	QQQ	ETF	66.91	66.921	66.77	66.788	5890481.0
2013-01-18 12:00:00	QQQ	ETF	66.79	66.94	66.78	66.9175	2037108.0
2013-01-18 13:00:00	QQQ	ETF	66.92	67.02	66.91	66.97	1616345.0
2013-01-18 14:00:00	QQQ	ETF	66.975	67.0	66.94	66.96	975975.0
2013-01-18 15:00:00	QQQ	ETF	66.96	67.14	66.92	67.1	6460171.0
2013-01-18 16:00:00	QQQ	ETF	67.1	67.1398	66.95	67.05	3272173.0
2013-01-18 17:00:00	QQQ	ETF	67.06	67.11	67.04	67.11	43789.0
2013-01-18 18:00:00	QQQ	ETF	67.09	67.1	67.07	67.07	11700.0
2013-01-18 19:00:00	QQQ	ETF	67.08	67.08	67.04	67.05	7140.0
2013-01-18 06:00:00	IWM	ETF	88.26	88.26	88.26	88.26	100.0
2013-01-18 07:00:00	IWM	ETF	88.3	88.3	88.3	88.3	200.0
2013-01-18 08:00:00	IWM	ETF	88.28	88.35	88.25	88.32	77995.0
2013-01-18 09:00:00	IWM	ETF	88.32	88.39	88.15	88.25	2232051.0
2013-01-18 10:00:00	IWM	ETF	88.245	88.36	88.18	88.2	3564528.0
2013-01-18 11:00:00	IWM	ETF	88.19	88.26	88.11	88.2	2821825.0
2013-01-18 12:00:00	IWM	ETF	88.2	88.4	88.19	88.385	1741949.0
2013-01-18 13:00:00	IWM	ETF	88.38	88.46	88.35	88.42	1947423.0
2013-01-18 14:00:00	IWM	ETF	88.415	88.57	88.384	88.505	2372443.0
2013-01-18 15:00:00	IWM	ETF	88.51	88.62	88.45	88.55	4347814.0
2013-01-18 16:00:00	IWM	ETF	88.56	88.66	88.55	88.65	3047412.0
2013-01-18 17:00:00	IWM	ETF	88.64	88.7	88.64	88.67	45475.0
2013-01-18 18:00:00	IWM	ETF	88.67	88.67	88.67	88.67	600.0
2013-01-18 19:00:00	IWM	ETF	88.65	88.65	88.65	88.65	300.0
2013-01-18 06:00:00	DIA	ETF	135.68	135.68	135.68	135.68	100.0
2013-01-18 07:00:00	DIA	ETF	135.68	135.85	135.67	135.75	2900.0
2013-01-18 08:00:00	DIA	ETF	135.75	135.83	135.68	135.83	9357.0
2013-01-18 09:00:00	DIA	ETF	135.79	135.84	135.6	135.76	695179.0
2013-01-18 10:00:00	DIA	ETF	135.7665	135.8	135.55	135.59	815931.0
2013-01-18 11:00:00	DIA	ETF	135.58	135.71	135.42	135.47	927275.0

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

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