PREVIEW / etf_1hour / 2010-04-26

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-04-26.parquet
  size:    157 KB
  rows:    4,892

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-26 04:00:00	SPY	ETF	121.96	122.02	121.94	122.02	4175.0
2010-04-26 05:00:00	SPY	ETF	121.94	121.94	121.76	121.8	1870.0
2010-04-26 06:00:00	SPY	ETF	121.73	121.92	121.0	121.89	28140.0
2010-04-26 07:00:00	SPY	ETF	121.93	122.02	121.86	121.91	369849.0
2010-04-26 08:00:00	SPY	ETF	121.9	122.01	121.76	121.89	2399685.0
2010-04-26 09:00:00	SPY	ETF	121.9	122.1	121.72	121.76	21993726.0
2010-04-26 10:00:00	SPY	ETF	121.75	122.04	121.63	121.96	27916973.0
2010-04-26 11:00:00	SPY	ETF	121.96	122.12	121.71	121.75	13461354.0
2010-04-26 12:00:00	SPY	ETF	121.74	121.84	121.65	121.82	12250122.0
2010-04-26 13:00:00	SPY	ETF	121.83	121.85	121.6	121.6901	11680305.0
2010-04-26 14:00:00	SPY	ETF	121.69	121.89	121.58	121.58	13632919.0
2010-04-26 15:00:00	SPY	ETF	121.58	121.83	121.23	121.34	31113100.0
2010-04-26 16:00:00	SPY	ETF	121.35	122.03	121.21	121.26	5521226.0
2010-04-26 17:00:00	SPY	ETF	121.27	121.28	121.16	121.22	108034.0
2010-04-26 18:00:00	SPY	ETF	121.22	121.32	121.17	121.22	85785.0
2010-04-26 19:00:00	SPY	ETF	121.22	121.29	121.16	121.25	23563.0
2010-04-26 20:00:00	SPY	ETF	121.23	121.23	121.23	121.23	200.0
2010-04-26 04:00:00	QQQ	ETF	50.64	50.65	50.64	50.65	400.0
2010-04-26 06:00:00	QQQ	ETF	50.55	50.63	50.54	50.54	1800.0
2010-04-26 07:00:00	QQQ	ETF	50.55	50.62	50.55	50.6	29324.0
2010-04-26 08:00:00	QQQ	ETF	50.6	50.62	50.52	50.57	1524658.0
2010-04-26 09:00:00	QQQ	ETF	50.57	50.65	50.4	50.41	13237792.0
2010-04-26 10:00:00	QQQ	ETF	50.41	50.53	50.3	50.49	14644352.0
2010-04-26 11:00:00	QQQ	ETF	50.48	50.56	50.375	50.4	5284310.0
2010-04-26 12:00:00	QQQ	ETF	50.39	50.45	50.34	50.45	4684320.0
2010-04-26 13:00:00	QQQ	ETF	50.45	50.47	50.35	50.4	3597432.0
2010-04-26 14:00:00	QQQ	ETF	50.409	50.56	50.37	50.46	4372800.0
2010-04-26 15:00:00	QQQ	ETF	50.45	50.51	50.31	50.39	9192253.0
2010-04-26 16:00:00	QQQ	ETF	50.4	50.6469	50.31	50.43	8442916.0
2010-04-26 17:00:00	QQQ	ETF	50.4	50.4	50.35	50.35	24241.0
2010-04-26 18:00:00	QQQ	ETF	50.39	50.41	50.39	50.41	14799.0
2010-04-26 19:00:00	QQQ	ETF	50.4	50.4	50.37	50.37	18103.0
2010-04-26 06:00:00	IWM	ETF	74.08	74.09	74.07	74.07	4250.0
2010-04-26 07:00:00	IWM	ETF	74.23	74.26	74.17	74.19	34065.0
2010-04-26 08:00:00	IWM	ETF	74.18	74.26	73.95	74.16	240009.0
2010-04-26 09:00:00	IWM	ETF	74.16	74.43	74.05	74.36	8774826.0
2010-04-26 10:00:00	IWM	ETF	74.365	74.66	74.31	74.5375	10868731.0
2010-04-26 11:00:00	IWM	ETF	74.54	74.64	74.34	74.39	5474569.0
2010-04-26 12:00:00	IWM	ETF	74.38	74.46	74.2	74.36	4460726.0
2010-04-26 13:00:00	IWM	ETF	74.36	74.45	74.08	74.19	6191452.0
2010-04-26 14:00:00	IWM	ETF	74.2	74.47	74.15	74.21	5772752.0
2010-04-26 15:00:00	IWM	ETF	74.21	74.27	73.83	73.85	12382640.0
2010-04-26 16:00:00	IWM	ETF	73.85	74.4034	50.0	73.85	5782135.0
2010-04-26 17:00:00	IWM	ETF	73.84	73.84	73.79	73.79	2501.0
2010-04-26 18:00:00	IWM	ETF	73.83	73.87	73.83	73.85	900.0
2010-04-26 19:00:00	IWM	ETF	73.81	73.83	73.77	73.83	5300.0
2010-04-26 06:00:00	DIA	ETF	112.1	112.1	112.1	112.1	200.0
2010-04-26 07:00:00	DIA	ETF	112.15	112.2	112.15	112.17	2600.0
2010-04-26 08:00:00	DIA	ETF	112.17	112.25	112.14	112.18	31421.0
2010-04-26 09:00:00	DIA	ETF	112.22	112.4	112.03	112.32	1147401.0

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

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