PREVIEW / etf_1hour / 2018-10-12

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-10-12.parquet
  size:    337 KB
  rows:    10,987

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-10-12 04:00:00	SPY	ETF	276.5	277.0	275.74	275.76	122772.0
2018-10-12 05:00:00	SPY	ETF	275.77	276.21	275.42	276.0	104828.0
2018-10-12 06:00:00	SPY	ETF	275.94	276.55	275.56	276.45	221598.0
2018-10-12 07:00:00	SPY	ETF	276.49	276.81	276.07	276.24	639798.0
2018-10-12 08:00:00	SPY	ETF	276.4	277.32	272.17	276.37	1022000.0
2018-10-12 09:00:00	SPY	ETF	276.37	277.09	275.67	276.6331	19913047.0
2018-10-12 10:00:00	SPY	ETF	276.62	276.95	275.07	276.1111	22326029.0
2018-10-12 11:00:00	SPY	ETF	276.12	276.5	274.22	274.87	18160065.0
2018-10-12 12:00:00	SPY	ETF	274.87	274.91	272.37	273.57	23736055.0
2018-10-12 13:00:00	SPY	ETF	273.56	274.74	272.88	273.85	19634282.0
2018-10-12 14:00:00	SPY	ETF	273.849	274.63	272.66	274.45	18528908.0
2018-10-12 15:00:00	SPY	ETF	274.45	277.015	273.9	276.01	39023951.0
2018-10-12 16:00:00	SPY	ETF	276.015	276.5	275.62	276.35	16809496.0
2018-10-12 17:00:00	SPY	ETF	276.36	276.36	275.94	276.13	887213.0
2018-10-12 18:00:00	SPY	ETF	276.11	276.34	276.08	276.34	65183.0
2018-10-12 19:00:00	SPY	ETF	276.33	277.16	275.95	277.12	190068.0
2018-10-12 04:00:00	QQQ	ETF	173.59	173.9	172.8	172.8	152999.0
2018-10-12 05:00:00	QQQ	ETF	172.81	173.56	172.64	173.3	79799.0
2018-10-12 06:00:00	QQQ	ETF	173.23	173.65	172.85	173.5	113689.0
2018-10-12 07:00:00	QQQ	ETF	173.52	173.66	173.08	173.25	561842.0
2018-10-12 08:00:00	QQQ	ETF	173.5	173.93	172.35	173.29	928453.0
2018-10-12 09:00:00	QQQ	ETF	173.25	174.28	172.94	173.72	16549686.0
2018-10-12 10:00:00	QQQ	ETF	173.7	174.33	172.99	173.55	13833137.0
2018-10-12 11:00:00	QQQ	ETF	173.555	173.91	172.15	172.6064	8942468.0
2018-10-12 12:00:00	QQQ	ETF	172.61	172.66	170.9328	172.13	11763060.0
2018-10-12 13:00:00	QQQ	ETF	172.13	172.99	171.77	172.52	9513858.0
2018-10-12 14:00:00	QQQ	ETF	172.51	173.19	171.58	173.03	8284333.0
2018-10-12 15:00:00	QQQ	ETF	173.03	174.86	172.73	174.33	13537608.0
2018-10-12 16:00:00	QQQ	ETF	174.32	174.54	173.0455	174.5001	3463033.0
2018-10-12 17:00:00	QQQ	ETF	174.55	174.6	174.25	174.42	664660.0
2018-10-12 18:00:00	QQQ	ETF	174.38	174.42	174.34	174.37	17319.0
2018-10-12 19:00:00	QQQ	ETF	174.5	175.01	174.32	174.97	444371.0
2018-10-12 04:00:00	IWM	ETF	155.86	155.91	155.44	155.44	8530.0
2018-10-12 05:00:00	IWM	ETF	155.3	155.55	155.3	155.4	4000.0
2018-10-12 06:00:00	IWM	ETF	155.4	155.7	155.3	155.67	15692.0
2018-10-12 07:00:00	IWM	ETF	155.67	155.92	155.42	155.46	101871.0
2018-10-12 08:00:00	IWM	ETF	155.58	155.69	155.15	155.26	310824.0
2018-10-12 09:00:00	IWM	ETF	155.28	155.76	154.67	155.56	5940493.0
2018-10-12 10:00:00	IWM	ETF	155.5501	155.76	154.49	154.57	4979878.0
2018-10-12 11:00:00	IWM	ETF	154.575	154.79	153.65	154.05	3745219.0
2018-10-12 12:00:00	IWM	ETF	154.05	154.06	151.885	152.45	6873945.0
2018-10-12 13:00:00	IWM	ETF	152.45	153.25	152.25	152.93	4903891.0
2018-10-12 14:00:00	IWM	ETF	152.98	153.02	152.03	152.94	4395450.0
2018-10-12 15:00:00	IWM	ETF	152.93	153.96	152.7	153.62	10406246.0
2018-10-12 16:00:00	IWM	ETF	153.61	154.1	153.41	154.05	2198319.0
2018-10-12 17:00:00	IWM	ETF	153.96	154.05	153.76	153.91	672844.0
2018-10-12 18:00:00	IWM	ETF	153.98	153.98	153.95	153.98	1780.0
2018-10-12 19:00:00	IWM	ETF	154.05	154.3	153.6	154.3	104375.0
2018-10-12 04:00:00	DIA	ETF	254.37	254.41	254.23	254.23	2200.0
2018-10-12 05:00:00	DIA	ETF	253.58	253.58	253.58	253.58	100.0

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

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