PREVIEW / etf_1hour / 2018-08-02

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-08-02.parquet
  size:    302 KB
  rows:    9,878

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-02 04:00:00	SPY	ETF	280.0	280.01	279.47	279.51	82191.0
2018-08-02 05:00:00	SPY	ETF	279.43	279.5	278.85	279.09	90500.0
2018-08-02 06:00:00	SPY	ETF	279.1	279.18	278.81	279.1	158230.0
2018-08-02 07:00:00	SPY	ETF	279.15	279.34	278.99	279.32	317779.0
2018-08-02 08:00:00	SPY	ETF	279.1001	280.86	278.95	279.42	630386.0
2018-08-02 09:00:00	SPY	ETF	279.42	280.05	279.16	279.965	6752278.0
2018-08-02 10:00:00	SPY	ETF	279.97	280.91	279.94	280.279	8014459.0
2018-08-02 11:00:00	SPY	ETF	280.28	281.31	280.23	281.21	5708351.0
2018-08-02 12:00:00	SPY	ETF	281.22	281.95	281.01	281.8	5193185.0
2018-08-02 13:00:00	SPY	ETF	281.8	282.41	281.8	282.37	5703265.0
2018-08-02 14:00:00	SPY	ETF	282.36	282.5	282.03	282.2337	5267609.0
2018-08-02 15:00:00	SPY	ETF	282.24	282.58	281.985	282.34	12003625.0
2018-08-02 16:00:00	SPY	ETF	282.34	282.72	282.3021	282.67	11751418.0
2018-08-02 17:00:00	SPY	ETF	282.67	282.71	282.61	282.71	26488.0
2018-08-02 18:00:00	SPY	ETF	282.64	282.69	282.52	282.61	26408.0
2018-08-02 19:00:00	SPY	ETF	282.55	282.58	282.49	282.52	25126.0
2018-08-02 04:00:00	QQQ	ETF	176.23	176.29	176.02	176.08	27821.0
2018-08-02 05:00:00	QQQ	ETF	176.03	176.03	175.56	175.74	62531.0
2018-08-02 06:00:00	QQQ	ETF	175.74	175.82	175.6	175.72	56974.0
2018-08-02 07:00:00	QQQ	ETF	175.77	176.17	175.67	175.73	294373.0
2018-08-02 08:00:00	QQQ	ETF	175.79	176.7	175.58	175.84	291397.0
2018-08-02 09:00:00	QQQ	ETF	175.83	176.83	175.68	176.7367	4786607.0
2018-08-02 10:00:00	QQQ	ETF	176.74	177.88	176.735	177.395	6562057.0
2018-08-02 11:00:00	QQQ	ETF	177.3975	178.53	177.18	178.275	5097406.0
2018-08-02 12:00:00	QQQ	ETF	178.29	179.02	178.09	178.8	4056006.0
2018-08-02 13:00:00	QQQ	ETF	178.81	179.58	178.81	179.46	3489817.0
2018-08-02 14:00:00	QQQ	ETF	179.465	179.64	179.25	179.4	3212029.0
2018-08-02 15:00:00	QQQ	ETF	179.405	179.74	179.24	179.52	8455329.0
2018-08-02 16:00:00	QQQ	ETF	179.52	179.87	179.5	179.81	1958590.0
2018-08-02 17:00:00	QQQ	ETF	179.8	179.83	179.68	179.73	15933.0
2018-08-02 18:00:00	QQQ	ETF	179.75	179.81	179.65	179.67	23430.0
2018-08-02 19:00:00	QQQ	ETF	179.69	179.74	179.67	179.73	8819.0
2018-08-02 04:00:00	IWM	ETF	165.05	165.15	164.86	164.86	20364.0
2018-08-02 05:00:00	IWM	ETF	164.83	164.83	164.5	164.63	4100.0
2018-08-02 06:00:00	IWM	ETF	164.61	164.67	164.43	164.55	13600.0
2018-08-02 07:00:00	IWM	ETF	164.65	164.8	164.63	164.76	44800.0
2018-08-02 08:00:00	IWM	ETF	164.7501	165.33	164.7	165.06	39504.0
2018-08-02 09:00:00	IWM	ETF	165.0	165.66	164.84	165.52	1843019.0
2018-08-02 10:00:00	IWM	ETF	165.55	166.32	165.49	166.1	2501756.0
2018-08-02 11:00:00	IWM	ETF	166.1	166.31	165.91	166.09	1276632.0
2018-08-02 12:00:00	IWM	ETF	166.11	166.975	165.96	166.66	1661176.0
2018-08-02 13:00:00	IWM	ETF	166.67	167.21	166.67	167.02	2491851.0
2018-08-02 14:00:00	IWM	ETF	167.0	167.21	166.785	167.0	1360430.0
2018-08-02 15:00:00	IWM	ETF	167.01	167.18	166.79	167.0	2873890.0
2018-08-02 16:00:00	IWM	ETF	167.01	167.27	166.97	167.22	1239360.0
2018-08-02 17:00:00	IWM	ETF	167.2	167.2001	167.15	167.2	1550.0
2018-08-02 18:00:00	IWM	ETF	167.21	167.26	167.19	167.26	2610.0
2018-08-02 19:00:00	IWM	ETF	167.21	167.23	167.17	167.23	2758.0
2018-08-02 04:00:00	DIA	ETF	252.08	252.08	252.05	252.05	1468.0
2018-08-02 05:00:00	DIA	ETF	251.73	251.73	251.23	251.23	950.0

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

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