PREVIEW / etf_1hour / 2018-06-19

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-06-19.parquet
  size:    308 KB
  rows:    10,238

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-06-19 04:00:00	SPY	ETF	273.45	273.8	272.8	273.44	73350.0
2018-06-19 05:00:00	SPY	ETF	273.4	273.69	273.37	273.61	34248.0
2018-06-19 06:00:00	SPY	ETF	273.73	274.0	273.6	273.78	161163.0
2018-06-19 07:00:00	SPY	ETF	273.78	274.08	273.25	274.08	601596.0
2018-06-19 08:00:00	SPY	ETF	274.07	274.5	272.55	274.12	1038092.0
2018-06-19 09:00:00	SPY	ETF	274.11	274.76	273.861	274.14	10399757.0
2018-06-19 10:00:00	SPY	ETF	274.1375	274.74	273.53	274.47	17217068.0
2018-06-19 11:00:00	SPY	ETF	274.49	275.27	274.395	275.05	9174821.0
2018-06-19 12:00:00	SPY	ETF	275.055	275.11	274.46	274.7348	5516835.0
2018-06-19 13:00:00	SPY	ETF	274.73	275.14	274.33	275.04	7360410.0
2018-06-19 14:00:00	SPY	ETF	275.04	275.75	275.04	275.62	7500612.0
2018-06-19 15:00:00	SPY	ETF	275.62	275.64	275.01	275.51	14948015.0
2018-06-19 16:00:00	SPY	ETF	275.51	275.58	275.25	275.51	20223131.0
2018-06-19 17:00:00	SPY	ETF	275.49	275.52	275.39	275.4	943957.0
2018-06-19 18:00:00	SPY	ETF	275.43	275.47	275.14	275.26	75273.0
2018-06-19 19:00:00	SPY	ETF	275.3	275.65	275.25	275.4879	109939.0
2018-06-19 04:00:00	QQQ	ETF	173.95	174.61	173.95	174.55	47755.0
2018-06-19 05:00:00	QQQ	ETF	174.62	174.77	174.47	174.55	45100.0
2018-06-19 06:00:00	QQQ	ETF	174.69	174.87	174.61	174.64	35650.0
2018-06-19 07:00:00	QQQ	ETF	174.64	174.77	174.01	174.45	262015.0
2018-06-19 08:00:00	QQQ	ETF	174.43	175.3	174.03	174.39	911906.0
2018-06-19 09:00:00	QQQ	ETF	174.39	175.309	174.22	174.58	4573390.0
2018-06-19 10:00:00	QQQ	ETF	174.57	174.82	173.71	174.61	7902822.0
2018-06-19 11:00:00	QQQ	ETF	174.62	175.33	174.52	175.17	4143904.0
2018-06-19 12:00:00	QQQ	ETF	175.17	175.24	174.8101	175.02	2263140.0
2018-06-19 13:00:00	QQQ	ETF	175.02	175.45	174.82	175.39	2334937.0
2018-06-19 14:00:00	QQQ	ETF	175.39	175.98	175.39	175.91	3201831.0
2018-06-19 15:00:00	QQQ	ETF	175.92	176.04	175.52	176.01	4414554.0
2018-06-19 16:00:00	QQQ	ETF	176.02	176.1	175.84	176.05	898925.0
2018-06-19 17:00:00	QQQ	ETF	176.1	176.1	175.97	175.98	5758.0
2018-06-19 18:00:00	QQQ	ETF	176.02	176.07	175.83	175.85	24170.0
2018-06-19 19:00:00	QQQ	ETF	175.87	176.22	175.87	176.22	32190.0
2018-06-19 04:00:00	IWM	ETF	166.99	166.99	166.5	166.85	4700.0
2018-06-19 05:00:00	IWM	ETF	166.85	167.08	166.85	167.08	2250.0
2018-06-19 06:00:00	IWM	ETF	167.26	167.4	167.22	167.3	16400.0
2018-06-19 07:00:00	IWM	ETF	167.31	167.52	167.15	167.49	44132.0
2018-06-19 08:00:00	IWM	ETF	167.3	168.6	167.21	167.78	373725.0
2018-06-19 09:00:00	IWM	ETF	167.75	168.01	167.18	167.26	4175320.0
2018-06-19 10:00:00	IWM	ETF	167.24	167.46	166.54	167.29	3589612.0
2018-06-19 11:00:00	IWM	ETF	167.3073	167.76	167.23	167.66	1886680.0
2018-06-19 12:00:00	IWM	ETF	167.66	168.17	167.5	168.1	1795345.0
2018-06-19 13:00:00	IWM	ETF	168.09	168.34	167.88	168.24	2286293.0
2018-06-19 14:00:00	IWM	ETF	168.25	168.6375	168.19	168.59	2433340.0
2018-06-19 15:00:00	IWM	ETF	168.59	168.77	168.38	168.65	4493365.0
2018-06-19 16:00:00	IWM	ETF	168.61	168.75	168.41	168.72	1216250.0
2018-06-19 17:00:00	IWM	ETF	168.73	168.73	168.61	168.63	1285.0
2018-06-19 18:00:00	IWM	ETF	168.7	168.7	168.55	168.61	8379.0
2018-06-19 19:00:00	IWM	ETF	168.65	168.79	168.65	168.79	5306.0
2018-06-19 04:00:00	DIA	ETF	245.99	246.0	245.85	246.0	300.0
2018-06-19 05:00:00	DIA	ETF	246.48	246.48	246.34	246.34	4200.0

> showing 50 of 10,238 rows — these rows as CSV

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