PREVIEW / etf_1hour / 2018-02-23

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-02-23.parquet
  size:    298 KB
  rows:    9,719

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
2018-02-23 04:00:00	SPY	ETF	271.73	272.08	271.62	271.96	12842.0
2018-02-23 05:00:00	SPY	ETF	271.95	271.95	271.3	271.49	15807.0
2018-02-23 06:00:00	SPY	ETF	271.51	272.06	271.51	272.04	38855.0
2018-02-23 07:00:00	SPY	ETF	272.04	272.34	271.95	271.95	223727.0
2018-02-23 08:00:00	SPY	ETF	271.99	272.44	271.71	271.78	403961.0
2018-02-23 09:00:00	SPY	ETF	271.83	272.27	271.43	271.89	5678633.0
2018-02-23 10:00:00	SPY	ETF	271.8999	272.21	271.25	271.97	6866167.0
2018-02-23 11:00:00	SPY	ETF	271.96	272.9	271.89	272.8	8179419.0
2018-02-23 12:00:00	SPY	ETF	272.81	272.95	272.24	272.53	6182495.0
2018-02-23 13:00:00	SPY	ETF	272.54	272.8	272.13	272.76	8402193.0
2018-02-23 14:00:00	SPY	ETF	272.76	273.64	272.37	273.509	7740675.0
2018-02-23 15:00:00	SPY	ETF	273.505	274.7	273.495	274.69	24894829.0
2018-02-23 16:00:00	SPY	ETF	274.71	274.95	273.65	274.5	15714562.0
2018-02-23 17:00:00	SPY	ETF	274.5	274.85	274.17	274.76	4316539.0
2018-02-23 18:00:00	SPY	ETF	274.76	274.78	274.62	274.7	319204.0
2018-02-23 19:00:00	SPY	ETF	274.72	274.74	274.62	274.7	23730.0
2018-02-23 04:00:00	QQQ	ETF	165.8	166.07	165.71	165.98	45472.0
2018-02-23 05:00:00	QQQ	ETF	165.9	165.93	165.58	165.72	43881.0
2018-02-23 06:00:00	QQQ	ETF	165.72	166.08	165.72	166.05	20175.0
2018-02-23 07:00:00	QQQ	ETF	166.06	166.21	166.05	166.1	149527.0
2018-02-23 08:00:00	QQQ	ETF	166.14	166.43	165.73	166.1	420931.0
2018-02-23 09:00:00	QQQ	ETF	166.14	166.3	165.7	165.99	2940831.0
2018-02-23 10:00:00	QQQ	ETF	165.99	166.15	165.45	166.06	3089831.0
2018-02-23 11:00:00	QQQ	ETF	166.08	166.6699	166.04	166.61	3270799.0
2018-02-23 12:00:00	QQQ	ETF	166.61	166.73	166.41	166.63	2656398.0
2018-02-23 13:00:00	QQQ	ETF	166.63	166.835	166.33	166.81	1886271.0
2018-02-23 14:00:00	QQQ	ETF	166.81	167.59	166.64	167.5082	3901675.0
2018-02-23 15:00:00	QQQ	ETF	167.5	168.13	167.5	168.12	11177207.0
2018-02-23 16:00:00	QQQ	ETF	168.13	168.4	167.89	168.18	3159765.0
2018-02-23 17:00:00	QQQ	ETF	168.37	168.37	168.11	168.29	364256.0
2018-02-23 18:00:00	QQQ	ETF	168.29	168.29	168.17	168.28	43801.0
2018-02-23 19:00:00	QQQ	ETF	168.25	168.28	168.18	168.27	9935.0
2018-02-23 04:00:00	IWM	ETF	153.16	153.22	153.16	153.22	1000.0
2018-02-23 05:00:00	IWM	ETF	153.08	153.08	152.76	152.84	9600.0
2018-02-23 06:00:00	IWM	ETF	153.1	153.15	153.09	153.15	11142.0
2018-02-23 07:00:00	IWM	ETF	153.14	153.29	153.14	153.16	11970.0
2018-02-23 08:00:00	IWM	ETF	153.16	153.48	152.97	153.0	77859.0
2018-02-23 09:00:00	IWM	ETF	153.04	153.25	152.735	153.07	1582974.0
2018-02-23 10:00:00	IWM	ETF	153.05	153.11	152.15	152.36	2516946.0
2018-02-23 11:00:00	IWM	ETF	152.36	152.95	152.28	152.87	1456939.0
2018-02-23 12:00:00	IWM	ETF	152.87	153.11	152.59	152.92	1346643.0
2018-02-23 13:00:00	IWM	ETF	152.93	153.12	152.73	153.1	1089943.0
2018-02-23 14:00:00	IWM	ETF	153.09	153.51	152.9	153.38	1666413.0
2018-02-23 15:00:00	IWM	ETF	153.38	154.02	153.34	153.98	4521423.0
2018-02-23 16:00:00	IWM	ETF	153.97	154.25	153.92	154.02	1064604.0
2018-02-23 17:00:00	IWM	ETF	154.15	154.15	153.95	153.97	19659.0
2018-02-23 18:00:00	IWM	ETF	154.05	154.05	154.05	154.05	200.0
2018-02-23 19:00:00	IWM	ETF	154.05	154.1	154.0	154.1	2426.0
2018-02-23 04:00:00	DIA	ETF	250.09	251.3	250.09	251.3	1050.0
2018-02-23 07:00:00	DIA	ETF	251.46	251.46	251.15	251.15	4824.0

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

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