PREVIEW / etf_1hour / 2019-06-10

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-06-10.parquet
  size:    327 KB
  rows:    10,984

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
2019-06-10 04:00:00	SPY	ETF	288.8	288.94	288.51	288.62	16595.0
2019-06-10 05:00:00	SPY	ETF	288.51	288.67	288.5	288.67	15734.0
2019-06-10 06:00:00	SPY	ETF	288.71	288.95	288.67	288.67	29535.0
2019-06-10 07:00:00	SPY	ETF	288.72	289.19	288.57	289.19	171847.0
2019-06-10 08:00:00	SPY	ETF	288.99	289.38	288.65	289.13	697716.0
2019-06-10 09:00:00	SPY	ETF	289.12	289.85	289.02	289.68	6931919.0
2019-06-10 10:00:00	SPY	ETF	289.685	290.19	289.52	289.96	8952503.0
2019-06-10 11:00:00	SPY	ETF	289.97	290.82	289.93	290.6903	6905017.0
2019-06-10 12:00:00	SPY	ETF	290.7	290.75	289.8	289.82	6818850.0
2019-06-10 13:00:00	SPY	ETF	289.82	290.24	289.51	289.67	4292639.0
2019-06-10 14:00:00	SPY	ETF	289.66	289.74	288.92	289.7	7392670.0
2019-06-10 15:00:00	SPY	ETF	289.7	289.81	288.8734	288.94	12782706.0
2019-06-10 16:00:00	SPY	ETF	288.94	289.791	288.88	289.23	4480260.0
2019-06-10 17:00:00	SPY	ETF	289.24	289.27	288.97	289.2	53440.0
2019-06-10 18:00:00	SPY	ETF	289.26	289.26	288.97	289.13	102524.0
2019-06-10 19:00:00	SPY	ETF	289.14	289.18	288.88	288.88	69452.0
2019-06-10 04:00:00	QQQ	ETF	181.71	181.81	181.5	181.61	15323.0
2019-06-10 05:00:00	QQQ	ETF	181.58	181.66	181.49	181.65	21801.0
2019-06-10 06:00:00	QQQ	ETF	181.64	181.81	181.58	181.63	10913.0
2019-06-10 07:00:00	QQQ	ETF	181.62	182.21	181.56	182.14	108760.0
2019-06-10 08:00:00	QQQ	ETF	181.63	182.24	181.55	182.09	573162.0
2019-06-10 09:00:00	QQQ	ETF	182.07	183.46	182.06	183.25	6050298.0
2019-06-10 10:00:00	QQQ	ETF	183.245	184.25	183.12	183.9325	6019018.0
2019-06-10 11:00:00	QQQ	ETF	183.9325	184.85	183.89	184.7	4007748.0
2019-06-10 12:00:00	QQQ	ETF	184.71	184.75	183.77	183.82	4283081.0
2019-06-10 13:00:00	QQQ	ETF	183.82	184.17	183.58	183.7335	2471542.0
2019-06-10 14:00:00	QQQ	ETF	183.73	183.75	182.971	183.68	4047187.0
2019-06-10 15:00:00	QQQ	ETF	183.67	183.78	183.0001	183.09	6552282.0
2019-06-10 16:00:00	QQQ	ETF	183.1	183.46	183.07	183.38	1928780.0
2019-06-10 17:00:00	QQQ	ETF	183.49	183.49	183.28	183.3	13650.0
2019-06-10 18:00:00	QQQ	ETF	183.36	183.42	183.21	183.27	104936.0
2019-06-10 19:00:00	QQQ	ETF	183.28	183.29	183.15	183.15	73687.0
2019-06-10 05:00:00	IWM	ETF	151.1	151.1	150.93	151.1	8500.0
2019-06-10 07:00:00	IWM	ETF	151.14	151.36	151.13	151.31	63385.0
2019-06-10 08:00:00	IWM	ETF	151.1299	151.45	151.1	151.34	49747.0
2019-06-10 09:00:00	IWM	ETF	151.4	152.82	151.25	152.79	2644559.0
2019-06-10 10:00:00	IWM	ETF	152.815	152.94	152.48	152.8	3139590.0
2019-06-10 11:00:00	IWM	ETF	152.8	153.14	152.35	153.04	1613050.0
2019-06-10 12:00:00	IWM	ETF	153.05	153.08	152.14	152.22	1461747.0
2019-06-10 13:00:00	IWM	ETF	152.23	152.49	151.99	152.135	1035824.0
2019-06-10 14:00:00	IWM	ETF	152.13	152.17	151.51	152.12	1686849.0
2019-06-10 15:00:00	IWM	ETF	152.11	152.285	151.57	151.75	2935855.0
2019-06-10 16:00:00	IWM	ETF	151.74	152.82	151.64	151.89	1341320.0
2019-06-10 17:00:00	IWM	ETF	151.78	151.78	151.75	151.75	53577.0
2019-06-10 18:00:00	IWM	ETF	151.81	151.85	151.75	151.82	5900.0
2019-06-10 19:00:00	IWM	ETF	151.77	151.77	151.77	151.77	300.0
2019-06-10 04:00:00	DIA	ETF	261.35	261.35	261.3	261.3	300.0
2019-06-10 06:00:00	DIA	ETF	261.4	261.4	261.35	261.35	477.0
2019-06-10 07:00:00	DIA	ETF	261.36	261.75	261.36	261.75	2761.0
2019-06-10 08:00:00	DIA	ETF	261.51	261.9	261.37	261.52	14852.0

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

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