PREVIEW / etf_1hour / 2015-03-05

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-03-05.parquet
  size:    234 KB
  rows:    7,508

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
2015-03-05 04:00:00	SPY	ETF	210.28	210.28	210.16	210.2	1800.0
2015-03-05 05:00:00	SPY	ETF	210.25	210.32	210.21	210.32	6500.0
2015-03-05 06:00:00	SPY	ETF	210.31	210.55	210.31	210.41	14668.0
2015-03-05 07:00:00	SPY	ETF	210.39	210.57	210.34	210.57	417667.0
2015-03-05 08:00:00	SPY	ETF	210.51	210.87	210.31	210.58	838405.0
2015-03-05 09:00:00	SPY	ETF	210.6	210.75	210.12	210.56	9028308.0
2015-03-05 10:00:00	SPY	ETF	210.56	210.8	210.44	210.675	9879232.0
2015-03-05 11:00:00	SPY	ETF	210.68	210.685	210.14	210.62	9194971.0
2015-03-05 12:00:00	SPY	ETF	210.63	210.63	209.85	209.955	9035515.0
2015-03-05 13:00:00	SPY	ETF	209.95	210.39	209.88	210.38	5794019.0
2015-03-05 14:00:00	SPY	ETF	210.38	210.64	210.33	210.53	8135782.0
2015-03-05 15:00:00	SPY	ETF	210.53	210.62	210.28	210.47	18306494.0
2015-03-05 16:00:00	SPY	ETF	210.47	210.56	210.42	210.48	4704787.0
2015-03-05 17:00:00	SPY	ETF	210.47	210.49	207.5	210.48	3199710.0
2015-03-05 18:00:00	SPY	ETF	210.47	210.52	210.46	210.5	16676.0
2015-03-05 19:00:00	SPY	ETF	210.5	210.51	210.48	210.49	16000.0
2015-03-05 04:00:00	QQQ	ETF	108.6	108.6	108.6	108.6	100.0
2015-03-05 06:00:00	QQQ	ETF	108.88	108.88	108.71	108.71	3160.0
2015-03-05 07:00:00	QQQ	ETF	108.6	108.68	108.59	108.63	25616.0
2015-03-05 08:00:00	QQQ	ETF	108.63	108.85	108.62	108.69	213262.0
2015-03-05 09:00:00	QQQ	ETF	108.69	108.8601	108.58	108.76	2466174.0
2015-03-05 10:00:00	QQQ	ETF	108.76	108.965	108.72	108.81	2598633.0
2015-03-05 11:00:00	QQQ	ETF	108.82	108.82	108.43	108.73	2031501.0
2015-03-05 12:00:00	QQQ	ETF	108.73	108.73	108.19	108.2501	1432206.0
2015-03-05 13:00:00	QQQ	ETF	108.25	108.59	108.22	108.59	1343007.0
2015-03-05 14:00:00	QQQ	ETF	108.58	108.79	108.54	108.7399	1021024.0
2015-03-05 15:00:00	QQQ	ETF	108.735	108.74	108.54	108.619	2932801.0
2015-03-05 16:00:00	QQQ	ETF	108.62	108.7255	108.514	108.62	789842.0
2015-03-05 17:00:00	QQQ	ETF	108.61	108.66	108.61	108.65	3800.0
2015-03-05 18:00:00	QQQ	ETF	108.62	108.64	108.6	108.61	15809.0
2015-03-05 19:00:00	QQQ	ETF	108.64	108.64	108.62	108.64	6200.0
2015-03-05 05:00:00	IWM	ETF	122.48	122.48	122.48	122.48	100.0
2015-03-05 06:00:00	IWM	ETF	122.52	122.52	122.52	122.52	100.0
2015-03-05 07:00:00	IWM	ETF	122.47	122.47	122.45	122.45	2845.0
2015-03-05 08:00:00	IWM	ETF	122.519	122.67	122.46	122.58	240365.0
2015-03-05 09:00:00	IWM	ETF	122.53	122.63	121.91	122.5	2812143.0
2015-03-05 10:00:00	IWM	ETF	122.5	122.92	122.44	122.8	2920210.0
2015-03-05 11:00:00	IWM	ETF	122.81	122.83	122.5	122.76	1599614.0
2015-03-05 12:00:00	IWM	ETF	122.77	122.78	122.12	122.14	2285084.0
2015-03-05 13:00:00	IWM	ETF	122.13	122.57	122.1	122.53	1159193.0
2015-03-05 14:00:00	IWM	ETF	122.5235	122.8	122.52	122.75	1350030.0
2015-03-05 15:00:00	IWM	ETF	122.75	122.835	122.55	122.72	2439742.0
2015-03-05 16:00:00	IWM	ETF	122.73	122.78	122.67	122.69	701392.0
2015-03-05 17:00:00	IWM	ETF	122.7	122.7	122.64	122.7	5900.0
2015-03-05 07:00:00	DIA	ETF	181.19	181.19	181.15	181.15	300.0
2015-03-05 08:00:00	DIA	ETF	181.15	181.47	181.11	181.25	7200.0
2015-03-05 09:00:00	DIA	ETF	181.25	181.32	180.83	181.27	321295.0
2015-03-05 10:00:00	DIA	ETF	181.25	181.45	181.12	181.35	351365.0
2015-03-05 11:00:00	DIA	ETF	181.34	181.35	180.96	181.3025	279365.0
2015-03-05 12:00:00	DIA	ETF	181.32	181.32	180.71	180.77	313006.0

> showing 50 of 7,508 rows — these rows as CSV

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