PREVIEW / etf_1hour / 2018-09-19

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-09-19.parquet
  size:    303 KB
  rows:    9,996

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-09-19 04:00:00	SPY	ETF	290.89	291.04	290.78	290.83	5954.0
2018-09-19 05:00:00	SPY	ETF	290.82	290.85	290.76	290.83	6500.0
2018-09-19 06:00:00	SPY	ETF	290.81	290.89	290.76	290.89	9450.0
2018-09-19 07:00:00	SPY	ETF	290.84	290.86	290.63	290.64	41557.0
2018-09-19 08:00:00	SPY	ETF	290.71	291.1	290.38	290.69	317917.0
2018-09-19 09:00:00	SPY	ETF	290.69	291.53	290.63	291.2	4955286.0
2018-09-19 10:00:00	SPY	ETF	291.2	291.48	290.825	291.09	9121535.0
2018-09-19 11:00:00	SPY	ETF	291.1	291.69	291.01	291.4899	6740815.0
2018-09-19 12:00:00	SPY	ETF	291.49	291.56	291.06	291.39	3486884.0
2018-09-19 13:00:00	SPY	ETF	291.39	291.42	291.1	291.26	3198827.0
2018-09-19 14:00:00	SPY	ETF	291.25	291.38	291.11	291.12	4050213.0
2018-09-19 15:00:00	SPY	ETF	291.13	291.47	291.08	291.25	10001815.0
2018-09-19 16:00:00	SPY	ETF	291.25	291.47	291.19	291.47	4888970.0
2018-09-19 17:00:00	SPY	ETF	291.46	291.46	291.37	291.43	395967.0
2018-09-19 18:00:00	SPY	ETF	291.44	291.45	291.38	291.44	58014.0
2018-09-19 19:00:00	SPY	ETF	291.44	291.59	291.41	291.58	45389.0
2018-09-19 04:00:00	QQQ	ETF	182.9	183.0	182.82	182.83	6481.0
2018-09-19 05:00:00	QQQ	ETF	182.84	182.9	182.8	182.8	10829.0
2018-09-19 06:00:00	QQQ	ETF	182.79	182.84	182.75	182.84	6552.0
2018-09-19 07:00:00	QQQ	ETF	182.81	182.86	182.5	182.5	20909.0
2018-09-19 08:00:00	QQQ	ETF	182.61	182.83	182.37	182.6999	334892.0
2018-09-19 09:00:00	QQQ	ETF	182.66	183.3	182.035	182.19	4287314.0
2018-09-19 10:00:00	QQQ	ETF	182.18	182.48	181.51	181.74	7502019.0
2018-09-19 11:00:00	QQQ	ETF	181.74	182.66	181.62	182.41	3892214.0
2018-09-19 12:00:00	QQQ	ETF	182.401	182.5	181.841	182.21	2186657.0
2018-09-19 13:00:00	QQQ	ETF	182.2	182.35	181.9202	182.32	2314402.0
2018-09-19 14:00:00	QQQ	ETF	182.31	182.47	182.202	182.31	1656509.0
2018-09-19 15:00:00	QQQ	ETF	182.3	182.89	182.3	182.7	4890842.0
2018-09-19 16:00:00	QQQ	ETF	182.7	182.9	182.3096	182.9	1114322.0
2018-09-19 17:00:00	QQQ	ETF	182.9	182.9	182.77	182.85	6505.0
2018-09-19 18:00:00	QQQ	ETF	182.88	182.93	182.85	182.87	28500.0
2018-09-19 19:00:00	QQQ	ETF	182.87	183.05	182.87	183.03	44259.0
2018-09-19 05:00:00	IWM	ETF	170.25	170.25	170.15	170.16	4118.0
2018-09-19 06:00:00	IWM	ETF	170.16	170.21	170.13	170.2	7400.0
2018-09-19 07:00:00	IWM	ETF	170.2	170.2	170.07	170.1	21000.0
2018-09-19 08:00:00	IWM	ETF	170.08	170.08	169.9	170.02	132143.0
2018-09-19 09:00:00	IWM	ETF	170.05	170.91	170.04	170.75	1208417.0
2018-09-19 10:00:00	IWM	ETF	170.75	171.07	170.31	170.51	2159411.0
2018-09-19 11:00:00	IWM	ETF	170.51	170.9	169.95	170.2	2193866.0
2018-09-19 12:00:00	IWM	ETF	170.19	170.2	169.07	169.56	2427158.0
2018-09-19 13:00:00	IWM	ETF	169.57	169.59	169.11	169.36	1807571.0
2018-09-19 14:00:00	IWM	ETF	169.365	169.53	169.23	169.295	1035457.0
2018-09-19 15:00:00	IWM	ETF	169.295	169.63	169.19	169.63	2513589.0
2018-09-19 16:00:00	IWM	ETF	169.65	169.82	169.4906	169.79	799009.0
2018-09-19 17:00:00	IWM	ETF	169.8	169.8	169.8	169.8	192.0
2018-09-19 18:00:00	IWM	ETF	169.79	169.82	169.78	169.8	7308.0
2018-09-19 19:00:00	IWM	ETF	169.83	169.9	169.8	169.9	4800.0
2018-09-19 08:00:00	DIA	ETF	262.9	262.9	262.7	262.7	771.0
2018-09-19 09:00:00	DIA	ETF	262.85	264.17	262.81	264.1	560338.0
2018-09-19 10:00:00	DIA	ETF	264.1	264.72	264.03	264.52	697912.0

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

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