PREVIEW / etf_1hour / 2010-04-20

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-04-20.parquet
  size:    158 KB
  rows:    4,904

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
2010-04-20 04:00:00	SPY	ETF	120.16	120.16	120.04	120.04	3000.0
2010-04-20 05:00:00	SPY	ETF	119.95	120.23	119.95	120.23	33000.0
2010-04-20 06:00:00	SPY	ETF	120.3	120.7	120.3	120.7	38250.0
2010-04-20 07:00:00	SPY	ETF	120.66	120.79	120.4	120.44	1486610.0
2010-04-20 08:00:00	SPY	ETF	120.44	120.56	119.81	120.43	1531981.0
2010-04-20 09:00:00	SPY	ETF	120.44	120.69	120.33	120.545	27950376.0
2010-04-20 10:00:00	SPY	ETF	120.54	120.61	120.17	120.44	27366396.0
2010-04-20 11:00:00	SPY	ETF	120.44	120.75	120.44	120.72	19793350.0
2010-04-20 12:00:00	SPY	ETF	120.72	120.98	120.7	120.77	16480095.0
2010-04-20 13:00:00	SPY	ETF	120.77	120.85	120.7	120.7383	9076553.0
2010-04-20 14:00:00	SPY	ETF	120.7301	120.93	120.61	120.9	14488205.0
2010-04-20 15:00:00	SPY	ETF	120.89	120.95	120.68	120.87	23583887.0
2010-04-20 16:00:00	SPY	ETF	120.87	121.31	119.871	121.24	13759368.0
2010-04-20 17:00:00	SPY	ETF	121.24	121.24	121.11	121.16	317309.0
2010-04-20 18:00:00	SPY	ETF	121.16	121.19	121.07	121.17	147033.0
2010-04-20 19:00:00	SPY	ETF	121.17	121.2	121.07	121.14	103896.0
2010-04-20 04:00:00	QQQ	ETF	49.6	49.63	49.6	49.63	350.0
2010-04-20 05:00:00	QQQ	ETF	49.63	49.63	49.63	49.63	100.0
2010-04-20 06:00:00	QQQ	ETF	49.68	49.79	49.68	49.78	17900.0
2010-04-20 07:00:00	QQQ	ETF	49.77	49.79	49.72	49.73	109052.0
2010-04-20 08:00:00	QQQ	ETF	49.73	49.77	49.69	49.71	232409.0
2010-04-20 09:00:00	QQQ	ETF	49.7	49.8	49.57	49.63	10324788.0
2010-04-20 10:00:00	QQQ	ETF	49.63	49.66	49.43	49.59	13246686.0
2010-04-20 11:00:00	QQQ	ETF	49.59	49.74	49.59	49.73	7542591.0
2010-04-20 12:00:00	QQQ	ETF	49.73	49.87	49.71	49.7899	6185570.0
2010-04-20 13:00:00	QQQ	ETF	49.79	49.82	49.75	49.79	2818037.0
2010-04-20 14:00:00	QQQ	ETF	49.78	49.85	49.71	49.83	6395586.0
2010-04-20 15:00:00	QQQ	ETF	49.83	49.88	49.73	49.75	8215138.0
2010-04-20 16:00:00	QQQ	ETF	49.74	50.25	49.5992	50.21	11236680.0
2010-04-20 17:00:00	QQQ	ETF	50.21	50.21	50.08	50.11	1674921.0
2010-04-20 18:00:00	QQQ	ETF	50.13	50.17	50.12	50.13	146064.0
2010-04-20 19:00:00	QQQ	ETF	50.15	50.16	50.12	50.16	96880.0
2010-04-20 06:00:00	IWM	ETF	71.54	71.57	71.5	71.5	3400.0
2010-04-20 07:00:00	IWM	ETF	71.62	71.62	71.37	71.37	292493.0
2010-04-20 08:00:00	IWM	ETF	71.42	71.47	71.35	71.42	579676.0
2010-04-20 09:00:00	IWM	ETF	71.41	71.79	71.38	71.521	7745353.0
2010-04-20 10:00:00	IWM	ETF	71.53	71.59	71.18	71.45	6992473.0
2010-04-20 11:00:00	IWM	ETF	71.4575	71.78	71.455	71.7599	6357353.0
2010-04-20 12:00:00	IWM	ETF	71.76	71.97	71.69	71.8475	6267884.0
2010-04-20 13:00:00	IWM	ETF	71.845	71.95	71.8	71.88	3592004.0
2010-04-20 14:00:00	IWM	ETF	71.88	72.0	71.78	71.905	6129049.0
2010-04-20 15:00:00	IWM	ETF	71.9	72.13	71.74	72.09	9178065.0
2010-04-20 16:00:00	IWM	ETF	72.09	72.47	71.7019	72.45	2003935.0
2010-04-20 17:00:00	IWM	ETF	72.4	72.42	72.32	72.39	94051.0
2010-04-20 18:00:00	IWM	ETF	72.36	72.41	72.33	72.4	12200.0
2010-04-20 19:00:00	IWM	ETF	72.43	72.45	72.31	72.31	4399.0
2010-04-20 05:00:00	DIA	ETF	110.93	110.93	110.93	110.93	500.0
2010-04-20 06:00:00	DIA	ETF	111.25	111.35	111.25	111.35	3900.0
2010-04-20 07:00:00	DIA	ETF	111.35	111.37	111.04	111.09	19250.0
2010-04-20 08:00:00	DIA	ETF	111.09	111.2	111.07	111.11	135650.0

> showing 50 of 4,904 rows — these rows as CSV

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