PREVIEW / etf_1hour / 2010-05-04

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-05-04.parquet
  size:    170 KB
  rows:    5,182

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-05-04 04:00:00	SPY	ETF	120.25	120.25	119.85	119.85	2060.0
2010-05-04 05:00:00	SPY	ETF	119.9	119.9	119.58	119.71	20066.0
2010-05-04 06:00:00	SPY	ETF	119.63	119.75	119.53	119.67	36796.0
2010-05-04 07:00:00	SPY	ETF	119.66	119.77	119.34	119.51	891647.0
2010-05-04 08:00:00	SPY	ETF	119.52	120.6	119.12	119.16	3725172.0
2010-05-04 09:00:00	SPY	ETF	119.15	120.09	118.19	118.59	46867505.0
2010-05-04 10:00:00	SPY	ETF	118.6	118.79	117.54	117.56	67232252.0
2010-05-04 11:00:00	SPY	ETF	117.55	117.86	117.21	117.77	41970911.0
2010-05-04 12:00:00	SPY	ETF	117.7705	117.78	117.04	117.62	34882116.0
2010-05-04 13:00:00	SPY	ETF	117.63	117.88	117.37	117.65	25810047.0
2010-05-04 14:00:00	SPY	ETF	117.64	117.71	117.24	117.34	31858549.0
2010-05-04 15:00:00	SPY	ETF	117.3383	117.71	116.92	117.55	73098971.0
2010-05-04 16:00:00	SPY	ETF	117.54	120.3862	117.27	117.6	21583497.0
2010-05-04 17:00:00	SPY	ETF	117.6	120.3861	117.41	117.51	10433649.0
2010-05-04 18:00:00	SPY	ETF	117.48	117.58	117.36	117.4	231834.0
2010-05-04 19:00:00	SPY	ETF	117.4	117.58	117.32	117.55	73560.0
2010-05-04 04:00:00	QQQ	ETF	49.75	49.75	49.73	49.73	4350.0
2010-05-04 05:00:00	QQQ	ETF	49.65	49.66	49.64	49.66	2399.0
2010-05-04 06:00:00	QQQ	ETF	49.67	49.69	49.6	49.6	999.0
2010-05-04 07:00:00	QQQ	ETF	49.65	49.65	49.49	49.57	637570.0
2010-05-04 08:00:00	QQQ	ETF	49.57	49.62	49.35	49.36	1873062.0
2010-05-04 09:00:00	QQQ	ETF	49.35	49.9	48.72	48.8787	20863674.0
2010-05-04 10:00:00	QQQ	ETF	48.88	48.91	48.35	48.4099	22932233.0
2010-05-04 11:00:00	QQQ	ETF	48.41	48.48	48.17	48.46	16652655.0
2010-05-04 12:00:00	QQQ	ETF	48.46	48.46	48.08	48.3384	15837916.0
2010-05-04 13:00:00	QQQ	ETF	48.34	48.51	48.25	48.449	10712078.0
2010-05-04 14:00:00	QQQ	ETF	48.449	48.47	48.24	48.31	11091777.0
2010-05-04 15:00:00	QQQ	ETF	48.31	48.5	48.18	48.43	23213763.0
2010-05-04 16:00:00	QQQ	ETF	48.43	49.9675	48.22	48.5	4478524.0
2010-05-04 17:00:00	QQQ	ETF	49.9675	49.9675	48.4	48.43	5316356.0
2010-05-04 18:00:00	QQQ	ETF	48.44	48.46	48.42	48.46	57820.0
2010-05-04 19:00:00	QQQ	ETF	48.43	48.48	48.4	48.46	55296.0
2010-05-04 05:00:00	IWM	ETF	72.81	72.81	72.71	72.71	500.0
2010-05-04 06:00:00	IWM	ETF	72.72	72.72	72.53	72.53	4400.0
2010-05-04 07:00:00	IWM	ETF	72.57	72.69	72.43	72.54	303213.0
2010-05-04 08:00:00	IWM	ETF	72.52	72.59	72.31	72.33	686506.0
2010-05-04 09:00:00	IWM	ETF	72.32	72.9	71.26	71.65	14920550.0
2010-05-04 10:00:00	IWM	ETF	71.65	71.81	71.09	71.1001	17549523.0
2010-05-04 11:00:00	IWM	ETF	71.1	71.34	70.86	71.27	13677360.0
2010-05-04 12:00:00	IWM	ETF	71.27	71.29	70.71	71.092	11752515.0
2010-05-04 13:00:00	IWM	ETF	71.11	71.28	70.94	71.18	7106567.0
2010-05-04 14:00:00	IWM	ETF	71.175	71.26	70.6471	70.81	9414183.0
2010-05-04 15:00:00	IWM	ETF	70.81	71.16	70.53	70.96	21044278.0
2010-05-04 16:00:00	IWM	ETF	70.95	71.26	70.7166	71.07	3050122.0
2010-05-04 17:00:00	IWM	ETF	73.2996	73.2996	70.92	70.92	2539741.0
2010-05-04 18:00:00	IWM	ETF	71.01	71.02	70.94	70.94	2880.0
2010-05-04 19:00:00	IWM	ETF	70.96	71.0	70.83	70.87	3700.0
2010-05-04 06:00:00	DIA	ETF	111.01	111.01	111.01	111.01	200.0
2010-05-04 07:00:00	DIA	ETF	111.11	111.11	110.81	110.81	15201.0
2010-05-04 08:00:00	DIA	ETF	110.9	111.0	110.65	110.65	18650.0

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

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