PREVIEW / etf_1hour / 2018-07-11

all etf 1-hour files

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

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-11 04:00:00	SPY	ETF	276.53	276.88	276.42	276.88	83986.0
2018-07-11 05:00:00	SPY	ETF	276.96	276.96	276.6	276.74	39490.0
2018-07-11 06:00:00	SPY	ETF	276.78	277.27	276.69	277.14	153077.0
2018-07-11 07:00:00	SPY	ETF	277.17	277.3	276.99	277.12	259295.0
2018-07-11 08:00:00	SPY	ETF	277.1738	278.9	276.46	277.05	1515243.0
2018-07-11 09:00:00	SPY	ETF	277.05	278.9	276.93	277.31	9109322.0
2018-07-11 10:00:00	SPY	ETF	277.32	278.04	277.27	277.73	9062253.0
2018-07-11 11:00:00	SPY	ETF	277.735	277.99	276.88	276.91	9242170.0
2018-07-11 12:00:00	SPY	ETF	276.91	277.42	276.83	277.01	5714478.0
2018-07-11 13:00:00	SPY	ETF	277.01	277.56	276.8	276.87	6583033.0
2018-07-11 14:00:00	SPY	ETF	276.8655	277.33	276.52	277.16	6611838.0
2018-07-11 15:00:00	SPY	ETF	277.16	277.4	276.8	276.91	17415696.0
2018-07-11 16:00:00	SPY	ETF	276.9	278.8386	276.64	276.87	9567736.0
2018-07-11 17:00:00	SPY	ETF	276.9	277.07	276.86	277.0	430920.0
2018-07-11 18:00:00	SPY	ETF	276.97	277.14	276.71	276.86	91912.0
2018-07-11 19:00:00	SPY	ETF	276.9	277.12	276.79	277.11	23938.0
2018-07-11 04:00:00	QQQ	ETF	175.4	175.72	175.4	175.72	32207.0
2018-07-11 05:00:00	QQQ	ETF	175.76	175.76	175.58	175.63	16570.0
2018-07-11 06:00:00	QQQ	ETF	175.59	176.0	175.54	175.9	35580.0
2018-07-11 07:00:00	QQQ	ETF	175.84	176.1	175.83	175.88	76714.0
2018-07-11 08:00:00	QQQ	ETF	177.32	177.32	175.75	176.0	463303.0
2018-07-11 09:00:00	QQQ	ETF	175.99	176.65	175.8	176.43	4106077.0
2018-07-11 10:00:00	QQQ	ETF	176.44	177.07	176.4	176.81	3681146.0
2018-07-11 11:00:00	QQQ	ETF	176.82	176.98	176.01	176.2198	4064054.0
2018-07-11 12:00:00	QQQ	ETF	176.22	176.64	175.95	176.39	2190783.0
2018-07-11 13:00:00	QQQ	ETF	176.4	176.85	176.24	176.3799	2337162.0
2018-07-11 14:00:00	QQQ	ETF	176.37	176.69	176.1	176.57	2320715.0
2018-07-11 15:00:00	QQQ	ETF	176.57	176.73	176.37	176.42	4600297.0
2018-07-11 16:00:00	QQQ	ETF	176.42	177.3306	176.1	176.23	2844035.0
2018-07-11 17:00:00	QQQ	ETF	176.27	176.31	176.15	176.28	11539.0
2018-07-11 18:00:00	QQQ	ETF	176.28	176.39	176.1	176.21	29193.0
2018-07-11 19:00:00	QQQ	ETF	176.24	176.36	176.15	176.32	31373.0
2018-07-11 04:00:00	IWM	ETF	167.3	167.31	167.19	167.28	18100.0
2018-07-11 05:00:00	IWM	ETF	167.27	167.28	167.22	167.24	4600.0
2018-07-11 06:00:00	IWM	ETF	167.29	167.57	167.24	167.52	40000.0
2018-07-11 07:00:00	IWM	ETF	167.55	167.63	167.43	167.47	106412.0
2018-07-11 08:00:00	IWM	ETF	167.43	167.81	167.43	167.7	99537.0
2018-07-11 09:00:00	IWM	ETF	167.72	167.98	167.29	167.85	2804793.0
2018-07-11 10:00:00	IWM	ETF	167.84	168.61	167.82	168.11	3079465.0
2018-07-11 11:00:00	IWM	ETF	168.13	168.275	167.34	167.415	1938057.0
2018-07-11 12:00:00	IWM	ETF	167.42	167.91	167.285	167.326	1656670.0
2018-07-11 13:00:00	IWM	ETF	167.33	167.61	167.1	167.26	1987924.0
2018-07-11 14:00:00	IWM	ETF	167.255	167.745	167.045	167.63	2110880.0
2018-07-11 15:00:00	IWM	ETF	167.62	167.85	167.05	167.15	4114769.0
2018-07-11 16:00:00	IWM	ETF	167.15	167.35	167.05	167.32	685944.0
2018-07-11 17:00:00	IWM	ETF	167.38	167.38	167.32	167.32	2141.0
2018-07-11 18:00:00	IWM	ETF	167.3	167.38	167.17	167.17	7294.0
2018-07-11 19:00:00	IWM	ETF	167.25	167.32	167.15	167.32	2352.0
2018-07-11 04:00:00	DIA	ETF	246.9	247.09	246.9	247.09	300.0
2018-07-11 05:00:00	DIA	ETF	247.2	247.2	247.12	247.12	200.0

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

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