PREVIEW / etf_1hour / 2010-02-05

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-02-05.parquet
  size:    167 KB
  rows:    5,078

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-02-05 04:00:00	SPY	ETF	106.6	106.6	105.96	106.0	14900.0
2010-02-05 05:00:00	SPY	ETF	105.96	106.05	105.61	105.61	89866.0
2010-02-05 06:00:00	SPY	ETF	105.6	106.2	105.55	106.19	209500.0
2010-02-05 07:00:00	SPY	ETF	106.16	106.26	105.9	105.97	1376662.0
2010-02-05 08:00:00	SPY	ETF	106.23	106.87	105.61	106.84	17609177.0
2010-02-05 09:00:00	SPY	ETF	106.83	106.88	105.92	106.01	59561731.0
2010-02-05 10:00:00	SPY	ETF	106.0	106.78	105.49	106.41	62291379.0
2010-02-05 11:00:00	SPY	ETF	106.42	106.47	105.56	105.84	53815164.0
2010-02-05 12:00:00	SPY	ETF	105.85	106.49	105.65	105.91	32613659.0
2010-02-05 13:00:00	SPY	ETF	105.908	105.9117	104.58	104.64	55759496.0
2010-02-05 14:00:00	SPY	ETF	104.645	106.4641	104.64	105.28	65539622.0
2010-02-05 15:00:00	SPY	ETF	105.28	106.865	105.2162	106.75	107581898.0
2010-02-05 16:00:00	SPY	ETF	106.74	106.823	105.2834	106.52	34114941.0
2010-02-05 17:00:00	SPY	ETF	106.53	106.68	106.51	106.64	173915.0
2010-02-05 18:00:00	SPY	ETF	106.64	106.7	106.62	106.65	58031.0
2010-02-05 19:00:00	SPY	ETF	106.69	106.69	106.58	106.64	43853.0
2010-02-05 04:00:00	QQQ	ETF	42.79	42.79	42.79	42.79	1000.0
2010-02-05 05:00:00	QQQ	ETF	42.6	42.6	42.58	42.58	1300.0
2010-02-05 06:00:00	QQQ	ETF	42.57	42.73	42.57	42.73	52409.0
2010-02-05 07:00:00	QQQ	ETF	42.69	42.75	42.63	42.64	448714.0
2010-02-05 08:00:00	QQQ	ETF	42.65	42.94	42.47	42.91	6905985.0
2010-02-05 09:00:00	QQQ	ETF	42.91	42.91	42.42	42.49	30563124.0
2010-02-05 10:00:00	QQQ	ETF	42.49	42.92	42.36	42.75	38832236.0
2010-02-05 11:00:00	QQQ	ETF	42.75	42.77	42.45	42.5981	19064900.0
2010-02-05 12:00:00	QQQ	ETF	42.6	42.71	42.53	42.64	10151087.0
2010-02-05 13:00:00	QQQ	ETF	42.64	42.645	42.12	42.16	20342503.0
2010-02-05 14:00:00	QQQ	ETF	42.16	42.46	42.155	42.42	22697601.0
2010-02-05 15:00:00	QQQ	ETF	42.42	43.02	42.42	42.93	49122457.0
2010-02-05 16:00:00	QQQ	ETF	42.93	43.03	42.1466	42.98	5531168.0
2010-02-05 17:00:00	QQQ	ETF	42.99	43.0	42.95	42.95	61225.0
2010-02-05 18:00:00	QQQ	ETF	43.0	43.0	42.95	43.0	17600.0
2010-02-05 19:00:00	QQQ	ETF	42.98	43.03	42.98	43.02	23720.0
2010-02-05 05:00:00	IWM	ETF	59.34	59.34	58.38	58.85	2200.0
2010-02-05 07:00:00	IWM	ETF	58.83	58.92	58.69	58.71	148982.0
2010-02-05 08:00:00	IWM	ETF	58.72	59.34	58.53	59.3	1841683.0
2010-02-05 09:00:00	IWM	ETF	59.31	59.41	58.46	58.48	11825803.0
2010-02-05 10:00:00	IWM	ETF	58.48	59.12	58.38	58.99	19227929.0
2010-02-05 11:00:00	IWM	ETF	58.99	59.04	58.32	58.57	10615834.0
2010-02-05 12:00:00	IWM	ETF	58.58	58.84	58.505	58.775	4194723.0
2010-02-05 13:00:00	IWM	ETF	58.78	58.79	58.0	58.06	10219995.0
2010-02-05 14:00:00	IWM	ETF	58.06	58.49	58.04	58.431	11848419.0
2010-02-05 15:00:00	IWM	ETF	58.43	59.33	58.43	59.26	26529196.0
2010-02-05 16:00:00	IWM	ETF	59.26	59.35	58.068	59.24	3115068.0
2010-02-05 17:00:00	IWM	ETF	59.21	59.43	58.87	59.24	39161.0
2010-02-05 18:00:00	IWM	ETF	59.3	59.31	59.26	59.31	5250.0
2010-02-05 19:00:00	IWM	ETF	59.3	59.32	59.26	59.32	600.0
2010-02-05 07:00:00	DIA	ETF	99.8	99.8	99.69	99.69	900.0
2010-02-05 08:00:00	DIA	ETF	99.72	100.43	99.3	100.41	124617.0
2010-02-05 09:00:00	DIA	ETF	100.4	100.41	99.5	99.6125	3933262.0
2010-02-05 10:00:00	DIA	ETF	99.58	100.18	99.302	99.89	3005710.0

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

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