PREVIEW / etf_1hour / 2015-04-20

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-04-20.parquet
  size:    242 KB
  rows:    7,725

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-04-20 04:00:00	SPY	ETF	209.17	209.39	209.17	209.19	29556.0
2015-04-20 05:00:00	SPY	ETF	209.16	209.3	209.1	209.19	103419.0
2015-04-20 06:00:00	SPY	ETF	209.17	209.45	209.14	209.35	213425.0
2015-04-20 07:00:00	SPY	ETF	209.36	209.36	208.71	209.0	407384.0
2015-04-20 08:00:00	SPY	ETF	208.51	209.31	207.98	209.24	660570.0
2015-04-20 09:00:00	SPY	ETF	209.24	209.91	208.96	209.8	14656565.0
2015-04-20 10:00:00	SPY	ETF	209.8	210.09	209.53	210.05	14545018.0
2015-04-20 11:00:00	SPY	ETF	210.05	210.25	209.97	210.16	9847108.0
2015-04-20 12:00:00	SPY	ETF	210.15	210.17	209.95	210.03	4156279.0
2015-04-20 13:00:00	SPY	ETF	210.03	210.18	209.85	209.86	6800315.0
2015-04-20 14:00:00	SPY	ETF	209.875	209.97	209.71	209.96	5855633.0
2015-04-20 15:00:00	SPY	ETF	209.96	210.2	209.77	209.85	17248713.0
2015-04-20 16:00:00	SPY	ETF	209.84	209.9	209.11	209.58	11711050.0
2015-04-20 17:00:00	SPY	ETF	209.58	209.58	209.46	209.5	948466.0
2015-04-20 18:00:00	SPY	ETF	209.5	209.68	209.5	209.65	75907.0
2015-04-20 19:00:00	SPY	ETF	209.65	209.77	209.631	209.77	23665.0
2015-04-20 04:00:00	QQQ	ETF	106.53	106.65	106.53	106.62	1168.0
2015-04-20 06:00:00	QQQ	ETF	106.61	106.7	106.59	106.66	22709.0
2015-04-20 07:00:00	QQQ	ETF	106.64	106.69	106.44	106.47	72869.0
2015-04-20 08:00:00	QQQ	ETF	106.47	106.62	106.01	106.58	238124.0
2015-04-20 09:00:00	QQQ	ETF	106.59	107.14	106.5	107.14	5132266.0
2015-04-20 10:00:00	QQQ	ETF	107.14	107.425	107.0	107.38	3415265.0
2015-04-20 11:00:00	QQQ	ETF	107.39	107.56	107.38	107.55	3583640.0
2015-04-20 12:00:00	QQQ	ETF	107.55	107.56	107.4101	107.48	1408382.0
2015-04-20 13:00:00	QQQ	ETF	107.48	107.62	107.43	107.57	1464768.0
2015-04-20 14:00:00	QQQ	ETF	107.56	107.64	107.46	107.61	1443905.0
2015-04-20 15:00:00	QQQ	ETF	107.605	107.79	107.565	107.59	5904237.0
2015-04-20 16:00:00	QQQ	ETF	107.6	107.67	107.48	107.55	585788.0
2015-04-20 17:00:00	QQQ	ETF	107.54	107.54	107.47	107.49	24452.0
2015-04-20 18:00:00	QQQ	ETF	107.51	107.55	107.5	107.53	14736.0
2015-04-20 19:00:00	QQQ	ETF	107.54	107.59	107.54	107.58	11400.0
2015-04-20 04:00:00	IWM	ETF	124.98	125.17	124.98	125.17	1108.0
2015-04-20 06:00:00	IWM	ETF	125.2	125.2	125.2	125.2	700.0
2015-04-20 07:00:00	IWM	ETF	125.09	125.09	124.87	125.01	19400.0
2015-04-20 08:00:00	IWM	ETF	124.94	125.14	124.43	125.13	200541.0
2015-04-20 09:00:00	IWM	ETF	125.13	125.36	124.83	125.21	2510003.0
2015-04-20 10:00:00	IWM	ETF	125.21	125.4915	124.94	125.455	2278654.0
2015-04-20 11:00:00	IWM	ETF	125.455	125.95	125.455	125.85	2756752.0
2015-04-20 12:00:00	IWM	ETF	125.845	125.88	125.64	125.68	1012450.0
2015-04-20 13:00:00	IWM	ETF	125.69	125.735	125.54	125.58	1145544.0
2015-04-20 14:00:00	IWM	ETF	125.575	125.69	125.49	125.5505	1364677.0
2015-04-20 15:00:00	IWM	ETF	125.55	125.7	125.45	125.62	2846826.0
2015-04-20 16:00:00	IWM	ETF	125.63	125.86	124.3385	125.57	3911101.0
2015-04-20 17:00:00	IWM	ETF	125.53	125.57	125.5	125.57	4564.0
2015-04-20 18:00:00	IWM	ETF	125.51	125.51	125.51	125.51	392.0
2015-04-20 19:00:00	IWM	ETF	125.51	125.51	125.51	125.51	400.0
2015-04-20 04:00:00	DIA	ETF	179.25	179.25	179.25	179.25	300.0
2015-04-20 06:00:00	DIA	ETF	179.25	179.25	179.25	179.25	500.0
2015-04-20 07:00:00	DIA	ETF	179.09	179.37	179.09	179.11	500.0
2015-04-20 08:00:00	DIA	ETF	178.91	179.39	178.861	179.35	12715.0

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

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