PREVIEW / etf_1hour / 2018-07-25

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-07-25.parquet
  size:    302 KB
  rows:    9,894

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-07-25 04:00:00	SPY	ETF	281.4	281.52	281.2	281.33	11710.0
2018-07-25 05:00:00	SPY	ETF	281.3	281.43	281.28	281.43	15950.0
2018-07-25 06:00:00	SPY	ETF	281.53	281.62	281.25	281.25	48004.0
2018-07-25 07:00:00	SPY	ETF	281.22	281.23	280.81	281.12	202314.0
2018-07-25 08:00:00	SPY	ETF	281.1901	281.34	280.84	281.32	186732.0
2018-07-25 09:00:00	SPY	ETF	281.32	282.05	281.19	281.88	4612345.0
2018-07-25 10:00:00	SPY	ETF	281.88	281.97	281.41	281.575	8036890.0
2018-07-25 11:00:00	SPY	ETF	281.5715	282.19	281.37	282.19	4632888.0
2018-07-25 12:00:00	SPY	ETF	282.19	282.44	282.01	282.4332	5303734.0
2018-07-25 13:00:00	SPY	ETF	282.43	282.62	282.1	282.525	4756794.0
2018-07-25 14:00:00	SPY	ETF	282.525	283.02	282.46	282.78	10102845.0
2018-07-25 15:00:00	SPY	ETF	282.77	284.37	282.56	284.13	24355440.0
2018-07-25 16:00:00	SPY	ETF	284.14	284.2	281.5753	283.84	13674980.0
2018-07-25 17:00:00	SPY	ETF	283.85	284.01	282.21	282.6	1221632.0
2018-07-25 18:00:00	SPY	ETF	282.66	284.01	282.66	283.0	405275.0
2018-07-25 19:00:00	SPY	ETF	282.94	283.09	282.78	283.02	117996.0
2018-07-25 04:00:00	QQQ	ETF	180.17	180.39	180.17	180.27	9849.0
2018-07-25 05:00:00	QQQ	ETF	180.32	180.44	180.31	180.44	3200.0
2018-07-25 06:00:00	QQQ	ETF	180.43	180.51	180.34	180.35	27310.0
2018-07-25 07:00:00	QQQ	ETF	180.39	180.39	180.01	180.19	66661.0
2018-07-25 08:00:00	QQQ	ETF	180.34	180.39	180.05	180.38	373868.0
2018-07-25 09:00:00	QQQ	ETF	180.35	181.0	180.23	180.79	2649510.0
2018-07-25 10:00:00	QQQ	ETF	180.79	180.9	180.32	180.56	3161030.0
2018-07-25 11:00:00	QQQ	ETF	180.57	181.265	180.45	181.24	3703228.0
2018-07-25 12:00:00	QQQ	ETF	181.25	181.69	181.145	181.62	2198804.0
2018-07-25 13:00:00	QQQ	ETF	181.61	181.75	181.355	181.69	1729936.0
2018-07-25 14:00:00	QQQ	ETF	181.6939	182.05	181.67	181.87	2684225.0
2018-07-25 15:00:00	QQQ	ETF	181.875	182.93	181.715	182.82	8090193.0
2018-07-25 16:00:00	QQQ	ETF	182.82	183.02	180.69	181.9301	2533417.0
2018-07-25 17:00:00	QQQ	ETF	181.85	182.82	178.69	179.0	1588965.0
2018-07-25 18:00:00	QQQ	ETF	179.0	181.75	178.97	180.12	976483.0
2018-07-25 19:00:00	QQQ	ETF	180.05	180.3	180.04	180.17	484855.0
2018-07-25 04:00:00	IWM	ETF	166.8	166.8	166.8	166.8	2012.0
2018-07-25 05:00:00	IWM	ETF	166.9	166.9	166.9	166.9	500.0
2018-07-25 06:00:00	IWM	ETF	166.86	166.86	166.8	166.8	2050.0
2018-07-25 07:00:00	IWM	ETF	166.58	166.59	166.58	166.59	350.0
2018-07-25 08:00:00	IWM	ETF	166.71	166.88	166.68	166.84	64990.0
2018-07-25 09:00:00	IWM	ETF	166.82	167.35	166.76	167.18	1569598.0
2018-07-25 10:00:00	IWM	ETF	167.18	167.27	166.14	166.52	2731649.0
2018-07-25 11:00:00	IWM	ETF	166.53	166.9	166.29	166.89	1686511.0
2018-07-25 12:00:00	IWM	ETF	166.89	167.19	166.755	167.08	983817.0
2018-07-25 13:00:00	IWM	ETF	167.08	167.15	166.52	166.71	1378257.0
2018-07-25 14:00:00	IWM	ETF	166.72	167.045	166.66	166.945	1347722.0
2018-07-25 15:00:00	IWM	ETF	166.94	167.47	166.71	167.44	4255632.0
2018-07-25 16:00:00	IWM	ETF	167.46	167.66	167.2	167.6	1125092.0
2018-07-25 17:00:00	IWM	ETF	167.65	167.69	167.0	167.0	46903.0
2018-07-25 18:00:00	IWM	ETF	167.0	167.59	167.0	167.45	34089.0
2018-07-25 19:00:00	IWM	ETF	167.38	167.5	167.38	167.42	10151.0
2018-07-25 05:00:00	DIA	ETF	252.1	252.1	252.1	252.1	300.0
2018-07-25 06:00:00	DIA	ETF	252.28	252.28	252.28	252.28	293.0

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

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