PREVIEW / etf_1hour / 2011-04-01

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-04-01.parquet
  size:    179 KB
  rows:    5,492

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-04-01 04:00:00	SPY	ETF	132.77	132.84	132.77	132.84	13000.0
2011-04-01 05:00:00	SPY	ETF	132.71	132.8	132.7	132.8	3550.0
2011-04-01 06:00:00	SPY	ETF	132.85	133.11	132.8	132.93	11050.0
2011-04-01 07:00:00	SPY	ETF	132.94	133.1	132.94	133.04	1172000.0
2011-04-01 08:00:00	SPY	ETF	133.01	133.44	132.51	133.26	7449689.0
2011-04-01 09:00:00	SPY	ETF	133.28	133.49	132.51	133.1	18624636.0
2011-04-01 10:00:00	SPY	ETF	133.13	133.66	133.07	133.54	24406809.0
2011-04-01 11:00:00	SPY	ETF	133.54	133.77	133.49	133.67	16749679.0
2011-04-01 12:00:00	SPY	ETF	133.68	133.75	133.51	133.57	10141042.0
2011-04-01 13:00:00	SPY	ETF	133.5671	133.57	133.43	133.54	10954382.0
2011-04-01 14:00:00	SPY	ETF	133.55	133.6	133.12	133.22	17167619.0
2011-04-01 15:00:00	SPY	ETF	133.215	133.27	132.83	133.16	33784117.0
2011-04-01 16:00:00	SPY	ETF	133.15	133.74	132.5487	133.19	10001584.0
2011-04-01 17:00:00	SPY	ETF	133.22	133.22	133.16	133.18	96965.0
2011-04-01 18:00:00	SPY	ETF	133.17	133.27	133.14	133.26	101530.0
2011-04-01 19:00:00	SPY	ETF	133.26	133.26	133.13	133.21	32853.0
2011-04-01 04:00:00	QQQ	ETF	57.61	57.61	57.61	57.61	300.0
2011-04-01 05:00:00	QQQ	ETF	57.54	57.54	57.54	57.54	1600.0
2011-04-01 06:00:00	QQQ	ETF	57.58	57.62	57.57	57.62	23500.0
2011-04-01 07:00:00	QQQ	ETF	57.66	57.69	57.65	57.66	456945.0
2011-04-01 08:00:00	QQQ	ETF	57.65	57.78	57.61	57.67	5021669.0
2011-04-01 09:00:00	QQQ	ETF	57.67	57.75	57.46	57.53	7777656.0
2011-04-01 10:00:00	QQQ	ETF	57.52	57.8	57.51	57.73	6993172.0
2011-04-01 11:00:00	QQQ	ETF	57.73	57.9	57.7	57.85	5165381.0
2011-04-01 12:00:00	QQQ	ETF	57.86	57.8699	57.75	57.781	2298562.0
2011-04-01 13:00:00	QQQ	ETF	57.7868	57.8	57.72	57.7619	3061245.0
2011-04-01 14:00:00	QQQ	ETF	57.77	57.78	57.48	57.55	5675335.0
2011-04-01 15:00:00	QQQ	ETF	57.5598	57.56	57.29	57.45	13274223.0
2011-04-01 16:00:00	QQQ	ETF	57.46	57.5787	57.3699	57.44	3200726.0
2011-04-01 17:00:00	QQQ	ETF	57.45	57.47	57.3914	57.47	2025248.0
2011-04-01 18:00:00	QQQ	ETF	57.46	57.49	57.45	57.48	10370.0
2011-04-01 19:00:00	QQQ	ETF	57.48	57.53	57.46	57.53	6997.0
2011-04-01 04:00:00	IWM	ETF	84.5	84.52	84.42	84.46	1319.0
2011-04-01 05:00:00	IWM	ETF	84.42	84.42	84.42	84.42	100.0
2011-04-01 06:00:00	IWM	ETF	84.52	84.52	84.52	84.52	500.0
2011-04-01 07:00:00	IWM	ETF	84.52	84.57	84.51	84.53	65890.0
2011-04-01 08:00:00	IWM	ETF	84.54	84.8	84.17	84.69	955374.0
2011-04-01 09:00:00	IWM	ETF	84.7	84.84	84.17	84.5	7544688.0
2011-04-01 10:00:00	IWM	ETF	84.49	84.98	84.46	84.92	7922985.0
2011-04-01 11:00:00	IWM	ETF	84.92	85.02	84.85	84.9099	2647201.0
2011-04-01 12:00:00	IWM	ETF	84.91	84.93	84.8	84.845	1673686.0
2011-04-01 13:00:00	IWM	ETF	84.84	84.9	84.76	84.89	1897617.0
2011-04-01 14:00:00	IWM	ETF	84.89	84.91	84.46	84.53	5332602.0
2011-04-01 15:00:00	IWM	ETF	84.53	84.56	84.25	84.51	12779149.0
2011-04-01 16:00:00	IWM	ETF	84.51	84.64	84.5	84.58	1715287.0
2011-04-01 17:00:00	IWM	ETF	84.56	84.56	84.56	84.56	500.0
2011-04-01 18:00:00	IWM	ETF	84.57	84.6	84.57	84.58	2900.0
2011-04-01 19:00:00	IWM	ETF	84.58	84.62	84.58	84.62	3100.0
2011-04-01 06:00:00	DIA	ETF	123.31	123.32	123.31	123.32	200.0
2011-04-01 07:00:00	DIA	ETF	123.36	123.42	123.35	123.42	14275.0

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

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