PREVIEW / etf_1hour / 2019-02-13

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-02-13.parquet
  size:    322 KB
  rows:    10,632

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
2019-02-13 04:00:00	SPY	ETF	274.82	274.88	274.49	274.49	4836.0
2019-02-13 05:00:00	SPY	ETF	274.44	274.66	274.44	274.65	35889.0
2019-02-13 06:00:00	SPY	ETF	274.69	274.93	274.53	274.93	37543.0
2019-02-13 07:00:00	SPY	ETF	274.91	275.04	274.88	274.89	97963.0
2019-02-13 08:00:00	SPY	ETF	274.91	275.35	274.5	275.14	272521.0
2019-02-13 09:00:00	SPY	ETF	275.14	275.93	274.87	275.53	9340789.0
2019-02-13 10:00:00	SPY	ETF	275.52	275.84	275.1	275.59	8517050.0
2019-02-13 11:00:00	SPY	ETF	275.59	275.84	274.56	275.01	8290426.0
2019-02-13 12:00:00	SPY	ETF	275.02	275.08	274.61	274.83	4110797.0
2019-02-13 13:00:00	SPY	ETF	274.84	275.1	274.77	274.97	3994237.0
2019-02-13 14:00:00	SPY	ETF	274.98	275.49	274.97	275.43	5819344.0
2019-02-13 15:00:00	SPY	ETF	275.42	275.71	274.85	274.98	16929134.0
2019-02-13 16:00:00	SPY	ETF	274.98	275.08	274.64	274.71	5638186.0
2019-02-13 17:00:00	SPY	ETF	274.71	274.71	274.46	274.64	223390.0
2019-02-13 18:00:00	SPY	ETF	274.63	274.81	274.5	274.81	100682.0
2019-02-13 19:00:00	SPY	ETF	274.81	275.02	274.35	274.47	107563.0
2019-02-13 04:00:00	QQQ	ETF	171.58	171.64	171.3	171.33	5870.0
2019-02-13 05:00:00	QQQ	ETF	171.47	171.55	171.37	171.55	11110.0
2019-02-13 06:00:00	QQQ	ETF	171.53	171.73	171.43	171.7	12701.0
2019-02-13 07:00:00	QQQ	ETF	171.69	171.84	171.65	171.7	81484.0
2019-02-13 08:00:00	QQQ	ETF	171.69	171.98	171.46	171.81	256490.0
2019-02-13 09:00:00	QQQ	ETF	171.79	172.16	171.4801	171.77	3980791.0
2019-02-13 10:00:00	QQQ	ETF	171.76	171.9698	171.17	171.58	4938132.0
2019-02-13 11:00:00	QQQ	ETF	171.58	171.7401	170.96	171.345	3765054.0
2019-02-13 12:00:00	QQQ	ETF	171.34	171.44	171.14	171.2825	1595571.0
2019-02-13 13:00:00	QQQ	ETF	171.2732	171.53	171.2326	171.42	1033499.0
2019-02-13 14:00:00	QQQ	ETF	171.42	171.73	171.41	171.625	1658442.0
2019-02-13 15:00:00	QQQ	ETF	171.62	171.66	170.82	170.97	3709455.0
2019-02-13 16:00:00	QQQ	ETF	170.98	171.08	170.76	170.9	1626895.0
2019-02-13 17:00:00	QQQ	ETF	170.88	171.0	170.8	170.85	25219.0
2019-02-13 18:00:00	QQQ	ETF	170.88	171.01	170.8	170.86	43519.0
2019-02-13 19:00:00	QQQ	ETF	170.98	171.1	170.57	170.66	69490.0
2019-02-13 04:00:00	IWM	ETF	153.3	153.31	153.18	153.18	1500.0
2019-02-13 05:00:00	IWM	ETF	153.12	153.19	153.12	153.19	700.0
2019-02-13 06:00:00	IWM	ETF	153.24	153.36	153.24	153.3	2400.0
2019-02-13 07:00:00	IWM	ETF	153.35	153.41	153.31	153.33	16426.0
2019-02-13 08:00:00	IWM	ETF	153.41	153.54	153.22	153.54	35544.0
2019-02-13 09:00:00	IWM	ETF	153.53	153.74	153.27	153.5	1930506.0
2019-02-13 10:00:00	IWM	ETF	153.49	153.53	153.08	153.21	2620341.0
2019-02-13 11:00:00	IWM	ETF	153.22	153.5	152.7	153.07	1678761.0
2019-02-13 12:00:00	IWM	ETF	153.07	153.14	152.805	152.88	982124.0
2019-02-13 13:00:00	IWM	ETF	152.88	153.2625	152.83	153.23	1125910.0
2019-02-13 14:00:00	IWM	ETF	153.24	153.67	153.21	153.65	1752247.0
2019-02-13 15:00:00	IWM	ETF	153.64	153.76	153.36	153.43	3420681.0
2019-02-13 16:00:00	IWM	ETF	153.43	153.5214	153.2	153.29	779056.0
2019-02-13 17:00:00	IWM	ETF	153.25	153.35	153.22	153.22	1212.0
2019-02-13 18:00:00	IWM	ETF	153.2	153.3	153.14	153.24	3912.0
2019-02-13 19:00:00	IWM	ETF	153.3	153.42	153.04	153.16	31700.0
2019-02-13 07:00:00	DIA	ETF	255.45	255.5	255.38	255.5	3801.0
2019-02-13 08:00:00	DIA	ETF	255.35	255.73	255.32	255.6	2500.0

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

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