PREVIEW / etf_1hour / 2012-01-19

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-01-19.parquet
  size:    188 KB
  rows:    5,823

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-01-19 04:00:00	SPY	ETF	130.6	130.68	130.5	130.6	10550.0
2012-01-19 05:00:00	SPY	ETF	130.48	130.78	130.43	130.78	15400.0
2012-01-19 06:00:00	SPY	ETF	130.74	130.85	130.73	130.79	15140.0
2012-01-19 07:00:00	SPY	ETF	130.78	131.28	130.75	131.17	758677.0
2012-01-19 08:00:00	SPY	ETF	131.14	131.5	130.8	131.14	2510807.0
2012-01-19 09:00:00	SPY	ETF	131.14	131.27	130.98	131.24	17293876.0
2012-01-19 10:00:00	SPY	ETF	131.23	131.42	130.8	131.24	20102286.0
2012-01-19 11:00:00	SPY	ETF	131.24	131.54	131.18	131.53	14603867.0
2012-01-19 12:00:00	SPY	ETF	131.5274	131.54	131.27	131.36	9060724.0
2012-01-19 13:00:00	SPY	ETF	131.35	131.57	131.34	131.37	13380551.0
2012-01-19 14:00:00	SPY	ETF	131.361	131.54	131.2	131.21	11906019.0
2012-01-19 15:00:00	SPY	ETF	131.205	131.48	131.19	131.48	24173958.0
2012-01-19 16:00:00	SPY	ETF	131.47	131.53	131.03	131.5	9439090.0
2012-01-19 17:00:00	SPY	ETF	131.46	131.488	131.38	131.44	666778.0
2012-01-19 18:00:00	SPY	ETF	131.43	131.48	131.35	131.42	235080.0
2012-01-19 19:00:00	SPY	ETF	131.42	131.42	131.35	131.38	125405.0
2012-01-19 05:00:00	QQQ	ETF	59.52	59.57	59.52	59.57	400.0
2012-01-19 06:00:00	QQQ	ETF	59.56	59.6	59.56	59.58	21600.0
2012-01-19 07:00:00	QQQ	ETF	59.59	59.7	59.56	59.67	48550.0
2012-01-19 08:00:00	QQQ	ETF	59.66	59.8	59.65	59.69	482897.0
2012-01-19 09:00:00	QQQ	ETF	59.69	59.84	59.67	59.821	5826752.0
2012-01-19 10:00:00	QQQ	ETF	59.82	59.91	59.65	59.83	6546870.0
2012-01-19 11:00:00	QQQ	ETF	59.84	59.97	59.83	59.94	3598217.0
2012-01-19 12:00:00	QQQ	ETF	59.95	59.95	59.85	59.88	2285794.0
2012-01-19 13:00:00	QQQ	ETF	59.88	59.958	59.84	59.845	3211148.0
2012-01-19 14:00:00	QQQ	ETF	59.85	59.95	59.74	59.7584	6821707.0
2012-01-19 15:00:00	QQQ	ETF	59.7584	59.91	59.75	59.86	7045342.0
2012-01-19 16:00:00	QQQ	ETF	59.86	59.86	59.43	59.7	3688274.0
2012-01-19 17:00:00	QQQ	ETF	59.7	59.7	59.62	59.65	91602.0
2012-01-19 18:00:00	QQQ	ETF	59.65	59.68	59.59	59.64	100606.0
2012-01-19 19:00:00	QQQ	ETF	59.63	59.64	59.61	59.62	20948.0
2012-01-19 04:00:00	IWM	ETF	77.52	77.65	77.52	77.65	1100.0
2012-01-19 06:00:00	IWM	ETF	77.79	77.82	77.79	77.82	300.0
2012-01-19 07:00:00	IWM	ETF	77.79	78.05	77.74	77.97	121361.0
2012-01-19 08:00:00	IWM	ETF	77.96	78.11	77.72	77.91	605842.0
2012-01-19 09:00:00	IWM	ETF	77.91	78.16	77.82	78.05	4745476.0
2012-01-19 10:00:00	IWM	ETF	78.05	78.11	77.66	78.02	7175226.0
2012-01-19 11:00:00	IWM	ETF	78.02	78.36	78.0	78.31	4095129.0
2012-01-19 12:00:00	IWM	ETF	78.32	78.33	78.07	78.1329	1822558.0
2012-01-19 13:00:00	IWM	ETF	78.13	78.25	78.09	78.12	1576629.0
2012-01-19 14:00:00	IWM	ETF	78.13	78.24	77.89	77.92	2333334.0
2012-01-19 15:00:00	IWM	ETF	77.9101	78.18	77.9	78.18	4976727.0
2012-01-19 16:00:00	IWM	ETF	78.18	78.339	77.91	78.1	3463760.0
2012-01-19 17:00:00	IWM	ETF	78.1	78.11	78.0664	78.11	91598.0
2012-01-19 18:00:00	IWM	ETF	78.08	78.08	78.08	78.08	2801.0
2012-01-19 19:00:00	IWM	ETF	78.03	78.04	78.01	78.04	2075.0
2012-01-19 08:00:00	DIA	ETF	125.68	126.0	125.68	125.89	10200.0
2012-01-19 09:00:00	DIA	ETF	125.89	126.0	125.74	125.83	1216022.0
2012-01-19 10:00:00	DIA	ETF	125.83	126.02	125.52	125.87	1411535.0
2012-01-19 11:00:00	DIA	ETF	125.87	126.03	125.84	125.99	974971.0

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

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