PREVIEW / etf_1hour / 2011-01-21

all etf 1-hour files

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

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-21 04:00:00	SPY	ETF	127.95	128.0	127.85	128.0	1300.0
2011-01-21 05:00:00	SPY	ETF	128.07	128.27	128.07	128.27	2300.0
2011-01-21 06:00:00	SPY	ETF	128.19	128.46	128.16	128.42	37767.0
2011-01-21 07:00:00	SPY	ETF	128.42	128.7	128.31	128.64	597085.0
2011-01-21 08:00:00	SPY	ETF	128.62	128.74	128.23	128.71	2169797.0
2011-01-21 09:00:00	SPY	ETF	128.72	129.13	128.72	129.11	22306223.0
2011-01-21 10:00:00	SPY	ETF	129.11	129.17	128.57	128.65	25883630.0
2011-01-21 11:00:00	SPY	ETF	128.66	128.77	128.3	128.43	18899561.0
2011-01-21 12:00:00	SPY	ETF	128.42	128.67	128.26	128.4774	13157393.0
2011-01-21 13:00:00	SPY	ETF	128.48	128.62	128.36	128.56	8855230.0
2011-01-21 14:00:00	SPY	ETF	128.56	128.7	128.47	128.54	13108534.0
2011-01-21 15:00:00	SPY	ETF	128.54	128.65	128.23	128.4	29606420.0
2011-01-21 16:00:00	SPY	ETF	128.39	128.985	128.28	128.3	13683952.0
2011-01-21 17:00:00	SPY	ETF	128.32	128.37	128.25	128.27	484273.0
2011-01-21 18:00:00	SPY	ETF	128.27	128.28	128.25	128.28	46000.0
2011-01-21 19:00:00	SPY	ETF	128.28	128.37	128.25	128.29	44737.0
2011-01-21 04:00:00	QQQ	ETF	56.03	56.03	56.0	56.0	940.0
2011-01-21 06:00:00	QQQ	ETF	56.15	56.21	56.15	56.21	7550.0
2011-01-21 07:00:00	QQQ	ETF	56.22	56.36	56.22	56.36	235252.0
2011-01-21 08:00:00	QQQ	ETF	56.35	56.44	56.28	56.42	1212208.0
2011-01-21 09:00:00	QQQ	ETF	56.43	56.49	56.32	56.46	6672245.0
2011-01-21 10:00:00	QQQ	ETF	56.45	56.49	56.15	56.155	9202239.0
2011-01-21 11:00:00	QQQ	ETF	56.15	56.23	55.95	55.999	6919936.0
2011-01-21 12:00:00	QQQ	ETF	55.995	56.08	55.82	55.92	6000374.0
2011-01-21 13:00:00	QQQ	ETF	55.93	55.96	55.82	55.8898	3738707.0
2011-01-21 14:00:00	QQQ	ETF	55.89	55.98	55.85	55.9089	4359268.0
2011-01-21 15:00:00	QQQ	ETF	55.9	55.94	55.65	55.68	12657306.0
2011-01-21 16:00:00	QQQ	ETF	55.68	55.72	55.65	55.68	4780645.0
2011-01-21 17:00:00	QQQ	ETF	55.68	55.7	55.66	55.67	53560.0
2011-01-21 18:00:00	QQQ	ETF	55.69	55.69	55.67	55.68	13616.0
2011-01-21 19:00:00	QQQ	ETF	55.68	55.68	55.66	55.67	10500.0
2011-01-21 04:00:00	IWM	ETF	77.51	77.69	77.51	77.69	200.0
2011-01-21 05:00:00	IWM	ETF	77.75	77.75	77.75	77.75	100.0
2011-01-21 06:00:00	IWM	ETF	77.87	77.95	77.87	77.92	900.0
2011-01-21 07:00:00	IWM	ETF	77.94	78.13	77.87	78.11	50385.0
2011-01-21 08:00:00	IWM	ETF	78.1	78.13	77.96	78.11	141668.0
2011-01-21 09:00:00	IWM	ETF	78.11	78.33	77.76	78.0	8056921.0
2011-01-21 10:00:00	IWM	ETF	78.0	78.07	77.69	77.79	7070013.0
2011-01-21 11:00:00	IWM	ETF	77.79	77.88	77.32	77.47	6761850.0
2011-01-21 12:00:00	IWM	ETF	77.47	77.55	77.3	77.4701	5217756.0
2011-01-21 13:00:00	IWM	ETF	77.4701	77.57	77.32	77.43	4849261.0
2011-01-21 14:00:00	IWM	ETF	77.435	77.57	77.2599	77.37	5616736.0
2011-01-21 15:00:00	IWM	ETF	77.37	77.48	77.12	77.17	11747844.0
2011-01-21 16:00:00	IWM	ETF	77.16	77.78	76.6696	77.22	3545563.0
2011-01-21 17:00:00	IWM	ETF	77.17	77.21	77.15	77.15	3000.0
2011-01-21 18:00:00	IWM	ETF	77.17	77.19	77.13	77.19	1000.0
2011-01-21 19:00:00	IWM	ETF	77.19	77.19	77.15	77.17	700.0
2011-01-21 06:00:00	DIA	ETF	118.18	118.2	118.18	118.2	200.0
2011-01-21 07:00:00	DIA	ETF	118.27	118.41	118.27	118.37	10400.0
2011-01-21 08:00:00	DIA	ETF	118.4	118.47	118.26	118.4	364665.0

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

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