PREVIEW / etf_1hour / 2011-01-06

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-01-06.parquet
  size:    175 KB
  rows:    5,363

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
2011-01-06 04:00:00	SPY	ETF	127.57	127.69	127.57	127.69	1600.0
2011-01-06 05:00:00	SPY	ETF	127.8	127.88	127.8	127.88	700.0
2011-01-06 06:00:00	SPY	ETF	127.91	128.0	127.9	127.91	72000.0
2011-01-06 07:00:00	SPY	ETF	127.94	128.07	127.89	127.92	336693.0
2011-01-06 08:00:00	SPY	ETF	127.89	128.0	127.7	127.72	2837062.0
2011-01-06 09:00:00	SPY	ETF	127.72	127.76	127.48	127.49	13547423.0
2011-01-06 10:00:00	SPY	ETF	127.5	127.83	127.4245	127.5	18814553.0
2011-01-06 11:00:00	SPY	ETF	127.5	127.52	127.01	127.25	19245116.0
2011-01-06 12:00:00	SPY	ETF	127.25	127.41	127.1	127.34	9419935.0
2011-01-06 13:00:00	SPY	ETF	127.34	127.51	127.125	127.51	10434114.0
2011-01-06 14:00:00	SPY	ETF	127.51	127.59	127.11	127.23	11858340.0
2011-01-06 15:00:00	SPY	ETF	127.22	127.46	127.05	127.39	22220757.0
2011-01-06 16:00:00	SPY	ETF	127.36	127.715	127.045	127.36	11892960.0
2011-01-06 17:00:00	SPY	ETF	127.34	127.35	127.25	127.29	163837.0
2011-01-06 18:00:00	SPY	ETF	127.32	127.39	127.18	127.29	75567.0
2011-01-06 19:00:00	SPY	ETF	127.3	127.37	127.27	127.29	44562.0
2011-01-06 04:00:00	QQQ	ETF	55.82	55.85	55.82	55.85	380.0
2011-01-06 05:00:00	QQQ	ETF	55.87	55.88	55.87	55.88	300.0
2011-01-06 06:00:00	QQQ	ETF	55.89	55.95	55.89	55.95	3000.0
2011-01-06 07:00:00	QQQ	ETF	55.95	55.98	55.9	55.9	71299.0
2011-01-06 08:00:00	QQQ	ETF	55.9	55.94	55.8	55.81	340920.0
2011-01-06 09:00:00	QQQ	ETF	55.81	55.86	55.69	55.75	5989948.0
2011-01-06 10:00:00	QQQ	ETF	55.755	55.94	55.75	55.805	7972503.0
2011-01-06 11:00:00	QQQ	ETF	55.8	55.86	55.68	55.819	6907555.0
2011-01-06 12:00:00	QQQ	ETF	55.811	55.87	55.75	55.831	3698602.0
2011-01-06 13:00:00	QQQ	ETF	55.83	55.92	55.77	55.92	4550882.0
2011-01-06 14:00:00	QQQ	ETF	55.92	55.96	55.755	55.82	5973406.0
2011-01-06 15:00:00	QQQ	ETF	55.825	55.95	55.765	55.91	8494515.0
2011-01-06 16:00:00	QQQ	ETF	55.92	55.96	55.9	55.92	860241.0
2011-01-06 17:00:00	QQQ	ETF	55.92	55.94	55.88	55.88	26365.0
2011-01-06 18:00:00	QQQ	ETF	55.9	55.92	55.85	55.92	47304.0
2011-01-06 19:00:00	QQQ	ETF	55.91	55.92	55.88	55.89	13510.0
2011-01-06 05:00:00	IWM	ETF	79.55	79.55	79.55	79.55	100.0
2011-01-06 06:00:00	IWM	ETF	79.61	79.63	79.61	79.63	500.0
2011-01-06 07:00:00	IWM	ETF	79.6	79.7	79.53	79.54	39202.0
2011-01-06 08:00:00	IWM	ETF	79.53	79.66	79.44	79.46	796134.0
2011-01-06 09:00:00	IWM	ETF	79.46	79.48	79.0	79.18	4758633.0
2011-01-06 10:00:00	IWM	ETF	79.17	79.53	79.13	79.24	6232879.0
2011-01-06 11:00:00	IWM	ETF	79.23	79.31	78.89	79.22	5881248.0
2011-01-06 12:00:00	IWM	ETF	79.23	79.29	79.12	79.18	2037472.0
2011-01-06 13:00:00	IWM	ETF	79.17	79.2	79.01	79.1985	2031218.0
2011-01-06 14:00:00	IWM	ETF	79.2	79.33	78.68	78.8	4792846.0
2011-01-06 15:00:00	IWM	ETF	78.8	78.99	78.65	78.9681	7908202.0
2011-01-06 16:00:00	IWM	ETF	78.97	79.2191	78.96	79.03	1674966.0
2011-01-06 17:00:00	IWM	ETF	79.02	79.04	79.02	79.03	23400.0
2011-01-06 18:00:00	IWM	ETF	79.01	79.03	79.0	79.01	3200.0
2011-01-06 19:00:00	IWM	ETF	79.08	79.08	79.03	79.03	1300.0
2011-01-06 05:00:00	DIA	ETF	117.2	117.21	117.2	117.21	2600.0
2011-01-06 06:00:00	DIA	ETF	117.21	117.33	117.21	117.33	21000.0
2011-01-06 07:00:00	DIA	ETF	117.27	117.39	117.27	117.3	9750.0

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

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