PREVIEW / etf_1hour / 2010-04-14

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-04-14.parquet
  size:    162 KB
  rows:    4,925

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-14 04:00:00	SPY	ETF	120.0	120.1	120.0	120.1	3600.0
2010-04-14 05:00:00	SPY	ETF	120.08	120.08	120.05	120.05	2900.0
2010-04-14 06:00:00	SPY	ETF	120.04	120.2	120.04	120.2	129150.0
2010-04-14 07:00:00	SPY	ETF	120.16	120.32	120.12	120.31	874550.0
2010-04-14 08:00:00	SPY	ETF	120.31	120.49	120.18	120.25	2638809.0
2010-04-14 09:00:00	SPY	ETF	120.25	120.54	120.22	120.31	23959455.0
2010-04-14 10:00:00	SPY	ETF	120.31	120.49	120.08	120.46	33730771.0
2010-04-14 11:00:00	SPY	ETF	120.46	120.65	120.25	120.56	17555420.0
2010-04-14 12:00:00	SPY	ETF	120.55	120.78	120.53	120.72	10794554.0
2010-04-14 13:00:00	SPY	ETF	120.7201	120.89	120.63	120.64	14039675.0
2010-04-14 14:00:00	SPY	ETF	120.64	120.95	120.64	120.92	15437490.0
2010-04-14 15:00:00	SPY	ETF	120.921	121.19	120.83	121.17	26962981.0
2010-04-14 16:00:00	SPY	ETF	121.18	121.23	120.2	121.16	13086194.0
2010-04-14 17:00:00	SPY	ETF	121.18	121.24	121.12	121.18	582664.0
2010-04-14 18:00:00	SPY	ETF	121.16	121.17	121.11	121.14	1147222.0
2010-04-14 19:00:00	SPY	ETF	121.12	121.16	121.11	121.16	33137.0
2010-04-14 04:00:00	QQQ	ETF	49.48	49.49	49.48	49.49	2500.0
2010-04-14 06:00:00	QQQ	ETF	49.51	49.52	49.51	49.52	1800.0
2010-04-14 07:00:00	QQQ	ETF	49.55	49.58	49.52	49.58	188563.0
2010-04-14 08:00:00	QQQ	ETF	49.58	49.65	49.54	49.57	909822.0
2010-04-14 09:00:00	QQQ	ETF	49.57	49.65	49.5	49.59	10501551.0
2010-04-14 10:00:00	QQQ	ETF	49.6	49.65	49.51	49.62	16607112.0
2010-04-14 11:00:00	QQQ	ETF	49.62	49.7	49.58	49.66	5784265.0
2010-04-14 12:00:00	QQQ	ETF	49.66	49.74	49.65	49.725	4527477.0
2010-04-14 13:00:00	QQQ	ETF	49.73	49.8	49.68	49.68	3312245.0
2010-04-14 14:00:00	QQQ	ETF	49.68	49.82	49.68	49.8	4812941.0
2010-04-14 15:00:00	QQQ	ETF	49.799	49.92	49.75	49.9	11044765.0
2010-04-14 16:00:00	QQQ	ETF	49.91	49.9677	49.2868	49.92	6986256.0
2010-04-14 17:00:00	QQQ	ETF	49.93	49.94	49.91	49.91	90464.0
2010-04-14 18:00:00	QQQ	ETF	49.92	49.93	49.9	49.91	49799.0
2010-04-14 19:00:00	QQQ	ETF	49.9	49.94	49.9	49.94	33800.0
2010-04-14 06:00:00	IWM	ETF	70.9	70.9	70.9	70.9	2000.0
2010-04-14 07:00:00	IWM	ETF	70.94	71.03	70.91	71.03	130541.0
2010-04-14 08:00:00	IWM	ETF	71.02	71.15	71.0	71.03	408321.0
2010-04-14 09:00:00	IWM	ETF	71.03	71.33	71.0	71.18	8394506.0
2010-04-14 10:00:00	IWM	ETF	71.18	71.435	70.99	71.41	10010059.0
2010-04-14 11:00:00	IWM	ETF	71.41	71.58	71.355	71.54	6487798.0
2010-04-14 12:00:00	IWM	ETF	71.54	71.78	71.51	71.7301	5469743.0
2010-04-14 13:00:00	IWM	ETF	71.74	71.92	71.67	71.68	6189918.0
2010-04-14 14:00:00	IWM	ETF	71.68	72.06	71.675	72.01	6509002.0
2010-04-14 15:00:00	IWM	ETF	72.015	72.2	71.89	72.19	12346154.0
2010-04-14 16:00:00	IWM	ETF	72.2	72.28	70.7004	72.25	4802145.0
2010-04-14 17:00:00	IWM	ETF	72.19	72.24	72.19	72.22	17103.0
2010-04-14 18:00:00	IWM	ETF	72.3	72.3	72.25	72.29	2608.0
2010-04-14 19:00:00	IWM	ETF	72.29	72.29	72.29	72.29	100.0
2010-04-14 07:00:00	DIA	ETF	110.59	110.64	110.54	110.62	22613.0
2010-04-14 08:00:00	DIA	ETF	110.55	110.78	110.55	110.59	365050.0
2010-04-14 09:00:00	DIA	ETF	110.6	110.8199	110.53	110.67	1310373.0
2010-04-14 10:00:00	DIA	ETF	110.66	110.81	110.43	110.78	1665829.0
2010-04-14 11:00:00	DIA	ETF	110.77	110.88	110.71	110.73	650227.0

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

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