PREVIEW / etf_1hour / 2017-10-18

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-10-18.parquet
  size:    283 KB
  rows:    9,368

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
2017-10-18 04:00:00	SPY	ETF	255.5	255.5	255.49	255.49	5000.0
2017-10-18 05:00:00	SPY	ETF	255.54	255.77	255.54	255.77	13280.0
2017-10-18 06:00:00	SPY	ETF	255.73	255.83	255.67	255.83	17300.0
2017-10-18 07:00:00	SPY	ETF	255.85	255.86	255.79	255.82	68741.0
2017-10-18 08:00:00	SPY	ETF	255.81	255.92	255.75	255.83	801482.0
2017-10-18 09:00:00	SPY	ETF	255.83	255.98	255.64	255.72	4405499.0
2017-10-18 10:00:00	SPY	ETF	255.7189	255.8	255.5	255.68	4634405.0
2017-10-18 11:00:00	SPY	ETF	255.68	255.73	255.5	255.62	4720804.0
2017-10-18 12:00:00	SPY	ETF	255.62	255.84	255.6	255.77	2116879.0
2017-10-18 13:00:00	SPY	ETF	255.77	255.95	255.77	255.875	4289368.0
2017-10-18 14:00:00	SPY	ETF	255.875	255.95	255.7701	255.79	2853735.0
2017-10-18 15:00:00	SPY	ETF	255.79	255.93	255.58	255.69	8693810.0
2017-10-18 16:00:00	SPY	ETF	255.69	255.8	255.65	255.76	6921457.0
2017-10-18 17:00:00	SPY	ETF	255.76	255.84	255.6625	255.78	256765.0
2017-10-18 18:00:00	SPY	ETF	255.77	255.77	255.69	255.72	175296.0
2017-10-18 19:00:00	SPY	ETF	255.73	255.76	255.73	255.76	29336.0
2017-10-18 04:00:00	QQQ	ETF	149.02	149.05	149.02	149.02	5500.0
2017-10-18 05:00:00	QQQ	ETF	149.01	149.2	149.01	149.2	3700.0
2017-10-18 06:00:00	QQQ	ETF	149.14	149.17	149.14	149.17	700.0
2017-10-18 07:00:00	QQQ	ETF	149.19	149.19	149.12	149.12	16124.0
2017-10-18 08:00:00	QQQ	ETF	149.04	149.21	149.04	149.16	53830.0
2017-10-18 09:00:00	QQQ	ETF	149.17	149.24	148.77	148.8352	2656005.0
2017-10-18 10:00:00	QQQ	ETF	148.85	149.05	148.64	148.96	3340057.0
2017-10-18 11:00:00	QQQ	ETF	148.95	148.98	148.79	148.84	1905957.0
2017-10-18 12:00:00	QQQ	ETF	148.83	149.13	148.82	149.05	1174184.0
2017-10-18 13:00:00	QQQ	ETF	149.05	149.11	149.0	149.075	800416.0
2017-10-18 14:00:00	QQQ	ETF	149.075	149.13	148.9661	149.02	1180545.0
2017-10-18 15:00:00	QQQ	ETF	149.02	149.1	148.77	148.86	3245348.0
2017-10-18 16:00:00	QQQ	ETF	148.86	148.95	148.8442	148.93	1221524.0
2017-10-18 17:00:00	QQQ	ETF	148.91	148.97	148.91	148.94	7800.0
2017-10-18 18:00:00	QQQ	ETF	148.95	148.95	148.91	148.95	23417.0
2017-10-18 19:00:00	QQQ	ETF	148.95	148.95	148.86	148.89	37630.0
2017-10-18 05:00:00	IWM	ETF	149.01	149.35	149.01	149.35	10340.0
2017-10-18 06:00:00	IWM	ETF	149.3	149.41	149.18	149.41	15443.0
2017-10-18 07:00:00	IWM	ETF	149.43	149.47	149.39	149.41	30034.0
2017-10-18 08:00:00	IWM	ETF	149.7	149.7	149.35	149.4	91249.0
2017-10-18 09:00:00	IWM	ETF	149.39	149.6	149.29	149.52	2140904.0
2017-10-18 10:00:00	IWM	ETF	149.52	149.57	149.08	149.4	2326685.0
2017-10-18 11:00:00	IWM	ETF	149.41	149.48	149.15	149.45	1502607.0
2017-10-18 12:00:00	IWM	ETF	149.46	149.82	149.44	149.71	1633200.0
2017-10-18 13:00:00	IWM	ETF	149.72	149.9	149.69	149.81	1429554.0
2017-10-18 14:00:00	IWM	ETF	149.8	149.91	149.77	149.79	1280774.0
2017-10-18 15:00:00	IWM	ETF	149.79	149.86	149.5	149.52	2726358.0
2017-10-18 16:00:00	IWM	ETF	149.52	149.6	149.45	149.52	1374543.0
2017-10-18 18:00:00	IWM	ETF	149.55	149.55	149.52	149.52	8378.0
2017-10-18 19:00:00	IWM	ETF	149.59	149.59	149.59	149.59	1000.0
2017-10-18 05:00:00	DIA	ETF	230.36	230.43	230.36	230.4	3200.0
2017-10-18 07:00:00	DIA	ETF	230.56	230.81	230.56	230.78	16635.0
2017-10-18 08:00:00	DIA	ETF	230.8	230.95	230.75	230.94	22470.0
2017-10-18 09:00:00	DIA	ETF	230.88	231.1485	230.87	231.07	510242.0

> showing 50 of 9,368 rows — these rows as CSV

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