PREVIEW / etf_1hour / 2018-08-16

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-08-16.parquet
  size:    311 KB
  rows:    10,071

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-08-16 04:00:00	SPY	ETF	282.5	283.07	282.5	283.07	17657.0
2018-08-16 05:00:00	SPY	ETF	283.05	283.11	282.9	283.03	39320.0
2018-08-16 06:00:00	SPY	ETF	283.03	283.53	283.03	283.52	85404.0
2018-08-16 07:00:00	SPY	ETF	283.47	283.61	283.2	283.3	348588.0
2018-08-16 08:00:00	SPY	ETF	283.5099	283.61	281.78	283.12	490093.0
2018-08-16 09:00:00	SPY	ETF	283.09	283.77	283.05	283.54	6664993.0
2018-08-16 10:00:00	SPY	ETF	283.55	284.13	283.5403	283.95	7177136.0
2018-08-16 11:00:00	SPY	ETF	283.95	284.62	283.94	284.6	6118620.0
2018-08-16 12:00:00	SPY	ETF	284.6	285.04	284.4	284.53	8505855.0
2018-08-16 13:00:00	SPY	ETF	284.53	284.8	284.4	284.4685	6112807.0
2018-08-16 14:00:00	SPY	ETF	284.47	284.61	283.95	284.35	9841274.0
2018-08-16 15:00:00	SPY	ETF	284.36	284.49	283.72	284.1	15732917.0
2018-08-16 16:00:00	SPY	ETF	284.07	284.36	281.8178	284.2	7294440.0
2018-08-16 17:00:00	SPY	ETF	284.21	284.25	284.06	284.2	130355.0
2018-08-16 18:00:00	SPY	ETF	284.15	284.15	283.91	284.13	160393.0
2018-08-16 19:00:00	SPY	ETF	284.15	284.15	283.96	284.08	46457.0
2018-08-16 04:00:00	QQQ	ETF	180.21	180.57	180.11	180.57	12966.0
2018-08-16 05:00:00	QQQ	ETF	180.45	180.62	180.4	180.5	14291.0
2018-08-16 06:00:00	QQQ	ETF	180.6	180.9	180.6	180.88	49853.0
2018-08-16 07:00:00	QQQ	ETF	180.85	180.89	180.57	180.65	229479.0
2018-08-16 08:00:00	QQQ	ETF	180.57	180.82	179.23	180.36	249905.0
2018-08-16 09:00:00	QQQ	ETF	180.38	180.68	180.07	180.14	4282814.0
2018-08-16 10:00:00	QQQ	ETF	180.14	180.7	180.14	180.31	2668517.0
2018-08-16 11:00:00	QQQ	ETF	180.3	180.87	180.3	180.78	2189267.0
2018-08-16 12:00:00	QQQ	ETF	180.77	180.99	180.52	180.63	2202167.0
2018-08-16 13:00:00	QQQ	ETF	180.635	180.76	180.28	180.31	1527251.0
2018-08-16 14:00:00	QQQ	ETF	180.31	180.43	179.77	180.13	2982924.0
2018-08-16 15:00:00	QQQ	ETF	180.14	180.2	179.47	179.82	4979760.0
2018-08-16 16:00:00	QQQ	ETF	179.81	179.91	179.51	179.7	1842072.0
2018-08-16 17:00:00	QQQ	ETF	179.67	179.82	179.67	179.75	23650.0
2018-08-16 18:00:00	QQQ	ETF	179.72	179.72	179.38	179.56	79216.0
2018-08-16 19:00:00	QQQ	ETF	179.54	179.61	179.45	179.51	20032.0
2018-08-16 20:00:00	QQQ	ETF	179.53	179.53	179.53	179.53	1050.0
2018-08-16 04:00:00	IWM	ETF	166.48	166.84	166.48	166.84	2250.0
2018-08-16 05:00:00	IWM	ETF	166.81	166.81	166.81	166.81	1000.0
2018-08-16 06:00:00	IWM	ETF	166.9	167.08	166.9	167.08	2950.0
2018-08-16 07:00:00	IWM	ETF	167.13	167.13	166.93	166.95	16874.0
2018-08-16 08:00:00	IWM	ETF	167.05	167.05	166.09	166.69	94290.0
2018-08-16 09:00:00	IWM	ETF	166.8	167.15	166.69	166.98	1649538.0
2018-08-16 10:00:00	IWM	ETF	166.99	167.63	166.99	167.36	2025518.0
2018-08-16 11:00:00	IWM	ETF	167.36	168.065	167.36	167.98	1757648.0
2018-08-16 12:00:00	IWM	ETF	167.9703	168.17	167.745	167.8	1626968.0
2018-08-16 13:00:00	IWM	ETF	167.79	167.905	167.36	167.45	1563478.0
2018-08-16 14:00:00	IWM	ETF	167.455	167.645	167.21	167.51	1065500.0
2018-08-16 15:00:00	IWM	ETF	167.51	167.74	167.41	167.59	3234777.0
2018-08-16 16:00:00	IWM	ETF	167.59	167.83	167.5691	167.72	895403.0
2018-08-16 17:00:00	IWM	ETF	167.76	167.78	167.71	167.78	4143.0
2018-08-16 18:00:00	IWM	ETF	167.72	167.74	167.5	167.57	19109.0
2018-08-16 19:00:00	IWM	ETF	167.63	167.65	167.62	167.65	3300.0
2018-08-16 04:00:00	DIA	ETF	252.66	253.08	252.66	253.08	300.0

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

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