PREVIEW / etf_1hour / 2010-07-19

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-07-19.parquet
  size:    161 KB
  rows:    4,931

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-07-19 04:00:00	SPY	ETF	106.93	107.25	106.93	107.23	14950.0
2010-07-19 05:00:00	SPY	ETF	107.23	107.38	107.1	107.21	11210.0
2010-07-19 06:00:00	SPY	ETF	107.25	107.46	107.21	107.38	39390.0
2010-07-19 07:00:00	SPY	ETF	107.34	107.42	107.13	107.2	596540.0
2010-07-19 08:00:00	SPY	ETF	107.21	107.3	107.0	107.13	1803407.0
2010-07-19 09:00:00	SPY	ETF	107.14	107.43	106.7	107.26	20437775.0
2010-07-19 10:00:00	SPY	ETF	107.22	107.33	106.22	106.47	36326871.0
2010-07-19 11:00:00	SPY	ETF	106.48	106.91	106.41	106.82	20220655.0
2010-07-19 12:00:00	SPY	ETF	106.82	107.19	106.56	106.99	16089700.0
2010-07-19 13:00:00	SPY	ETF	106.99	107.02	106.63	106.68	9786186.0
2010-07-19 14:00:00	SPY	ETF	106.67	107.46	106.67	107.26	18920777.0
2010-07-19 15:00:00	SPY	ETF	107.26	107.63	106.99	107.32	44596009.0
2010-07-19 16:00:00	SPY	ETF	107.32	107.425	106.49	106.54	12987797.0
2010-07-19 17:00:00	SPY	ETF	106.53	106.55	106.45	106.48	153400.0
2010-07-19 18:00:00	SPY	ETF	106.46	107.29	106.38	106.44	252814.0
2010-07-19 19:00:00	SPY	ETF	106.41	106.65	106.39	106.65	85565.0
2010-07-19 04:00:00	QQQ	ETF	44.49	44.51	44.49	44.51	2300.0
2010-07-19 05:00:00	QQQ	ETF	44.51	44.51	44.51	44.51	500.0
2010-07-19 06:00:00	QQQ	ETF	44.53	44.61	44.52	44.6	7100.0
2010-07-19 07:00:00	QQQ	ETF	44.58	44.63	44.48	44.51	156253.0
2010-07-19 08:00:00	QQQ	ETF	44.51	44.53	44.4	44.46	556433.0
2010-07-19 09:00:00	QQQ	ETF	44.46	44.74	44.44	44.59	11310214.0
2010-07-19 10:00:00	QQQ	ETF	44.59	44.67	44.1	44.23	20786333.0
2010-07-19 11:00:00	QQQ	ETF	44.22	44.5	44.2	44.4601	9219971.0
2010-07-19 12:00:00	QQQ	ETF	44.4601	44.56	44.27	44.46	5721451.0
2010-07-19 13:00:00	QQQ	ETF	44.46	44.47	44.3	44.342	3743717.0
2010-07-19 14:00:00	QQQ	ETF	44.35	44.72	44.3472	44.64	7152655.0
2010-07-19 15:00:00	QQQ	ETF	44.63	44.81	44.54	44.72	13757821.0
2010-07-19 16:00:00	QQQ	ETF	44.72	44.78	44.22	44.22	5784430.0
2010-07-19 17:00:00	QQQ	ETF	44.22	44.26	44.2	44.21	366897.0
2010-07-19 18:00:00	QQQ	ETF	44.21	44.24	44.17	44.2	54915.0
2010-07-19 19:00:00	QQQ	ETF	44.2	44.28	44.19	44.28	85980.0
2010-07-19 04:00:00	IWM	ETF	61.32	61.32	61.32	61.32	100.0
2010-07-19 05:00:00	IWM	ETF	61.48	61.48	61.48	61.48	200.0
2010-07-19 06:00:00	IWM	ETF	61.41	61.54	61.37	61.49	8200.0
2010-07-19 07:00:00	IWM	ETF	61.46	61.54	61.34	61.41	13400.0
2010-07-19 08:00:00	IWM	ETF	61.41	61.43	61.18	61.24	346023.0
2010-07-19 09:00:00	IWM	ETF	61.26	61.48	61.14	61.23	7475607.0
2010-07-19 10:00:00	IWM	ETF	61.22	61.26	60.15	60.4	14128921.0
2010-07-19 11:00:00	IWM	ETF	60.4	60.84	60.34	60.73	7219710.0
2010-07-19 12:00:00	IWM	ETF	60.73	61.01	60.48	60.88	4817678.0
2010-07-19 13:00:00	IWM	ETF	60.88	60.915	60.59	60.65	4033966.0
2010-07-19 14:00:00	IWM	ETF	60.65	61.2	60.645	61.055	4499999.0
2010-07-19 15:00:00	IWM	ETF	61.05	61.39	60.94	61.3	11246798.0
2010-07-19 16:00:00	IWM	ETF	61.3	61.42	60.4	60.9	5982122.0
2010-07-19 17:00:00	IWM	ETF	60.88	60.88	60.82	60.83	117713.0
2010-07-19 18:00:00	IWM	ETF	60.8	60.81	60.74	60.79	7469.0
2010-07-19 19:00:00	IWM	ETF	60.8	60.85	60.75	60.81	10283.0
2010-07-19 04:00:00	DIA	ETF	101.3	101.3	101.3	101.3	5000.0
2010-07-19 06:00:00	DIA	ETF	101.61	101.61	101.61	101.61	1000.0

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

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