PREVIEW / etf_1hour / 2019-03-01

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-03-01.parquet
  size:    327 KB
  rows:    10,766

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-03-01 04:00:00	SPY	ETF	280.1	280.24	280.08	280.21	8910.0
2019-03-01 05:00:00	SPY	ETF	280.16	280.17	280.06	280.11	10880.0
2019-03-01 06:00:00	SPY	ETF	280.06	280.23	280.06	280.23	25484.0
2019-03-01 07:00:00	SPY	ETF	280.22	280.38	280.19	280.3	165135.0
2019-03-01 08:00:00	SPY	ETF	280.28	280.37	279.61	280.15	371248.0
2019-03-01 09:00:00	SPY	ETF	280.13	280.88	280.1	280.79	8530169.0
2019-03-01 10:00:00	SPY	ETF	280.73	280.79	279.52	279.82	10379111.0
2019-03-01 11:00:00	SPY	ETF	279.82	279.93	278.82	279.1	7781793.0
2019-03-01 12:00:00	SPY	ETF	279.1	279.75	279.04	279.68	5495283.0
2019-03-01 13:00:00	SPY	ETF	279.68	279.88	279.62	279.7385	4321134.0
2019-03-01 14:00:00	SPY	ETF	279.735	280.45	279.69	280.33	7457135.0
2019-03-01 15:00:00	SPY	ETF	280.325	280.76	280.07	280.49	20029818.0
2019-03-01 16:00:00	SPY	ETF	280.49	280.75	280.115	280.7	10209707.0
2019-03-01 17:00:00	SPY	ETF	280.71	280.75	280.53	280.65	241450.0
2019-03-01 18:00:00	SPY	ETF	280.64	280.75	280.56	280.74	1117872.0
2019-03-01 19:00:00	SPY	ETF	280.7	280.76	280.68	280.73	25097.0
2019-03-01 04:00:00	QQQ	ETF	174.29	174.49	174.29	174.34	22187.0
2019-03-01 05:00:00	QQQ	ETF	174.38	174.39	174.27	174.38	7700.0
2019-03-01 06:00:00	QQQ	ETF	174.38	174.49	174.32	174.44	28925.0
2019-03-01 07:00:00	QQQ	ETF	174.43	174.48	174.33	174.4	152942.0
2019-03-01 08:00:00	QQQ	ETF	174.41	174.47	173.94	174.25	332158.0
2019-03-01 09:00:00	QQQ	ETF	174.28	174.57	174.16	174.3525	4837507.0
2019-03-01 10:00:00	QQQ	ETF	174.35	174.35	173.55	173.94	4721236.0
2019-03-01 11:00:00	QQQ	ETF	173.95	173.9817	173.18	173.44	2402918.0
2019-03-01 12:00:00	QQQ	ETF	173.44	173.98	173.4	173.9251	2502758.0
2019-03-01 13:00:00	QQQ	ETF	173.92	174.17	173.87	174.13	2248638.0
2019-03-01 14:00:00	QQQ	ETF	174.13	174.6384	174.05	174.435	3674019.0
2019-03-01 15:00:00	QQQ	ETF	174.44	174.65	174.23	174.42	5879966.0
2019-03-01 16:00:00	QQQ	ETF	174.42	174.55	174.37	174.52	1232900.0
2019-03-01 17:00:00	QQQ	ETF	174.47	174.54	174.42	174.46	8151.0
2019-03-01 18:00:00	QQQ	ETF	174.47	174.55	174.47	174.55	7996.0
2019-03-01 19:00:00	QQQ	ETF	174.55	174.59	174.48	174.55	9082.0
2019-03-01 04:00:00	IWM	ETF	157.68	157.76	157.68	157.76	500.0
2019-03-01 05:00:00	IWM	ETF	157.72	157.75	157.71	157.71	2900.0
2019-03-01 06:00:00	IWM	ETF	157.72	157.89	157.7	157.89	5050.0
2019-03-01 07:00:00	IWM	ETF	157.85	157.92	157.77	157.92	38155.0
2019-03-01 08:00:00	IWM	ETF	157.86	157.86	157.49	157.73	42217.0
2019-03-01 09:00:00	IWM	ETF	157.73	158.25	157.63	157.84	2260797.0
2019-03-01 10:00:00	IWM	ETF	157.82	157.83	157.1	157.49	3214153.0
2019-03-01 11:00:00	IWM	ETF	157.495	157.58	156.7501	157.0	1746774.0
2019-03-01 12:00:00	IWM	ETF	157.0	157.89	157.0	157.76	2171080.0
2019-03-01 13:00:00	IWM	ETF	157.77	157.93	157.68	157.79	1009640.0
2019-03-01 14:00:00	IWM	ETF	157.8	158.25	157.75	158.17	1863520.0
2019-03-01 15:00:00	IWM	ETF	158.165	158.34	158.04	158.23	3723276.0
2019-03-01 16:00:00	IWM	ETF	158.24	158.31	156.8262	158.28	976531.0
2019-03-01 17:00:00	IWM	ETF	158.26	158.3	158.26	158.2999	1300.0
2019-03-01 18:00:00	IWM	ETF	158.24	158.3	158.24	158.3	3930.0
2019-03-01 19:00:00	IWM	ETF	158.27	158.32	158.27	158.32	1221.0
2019-03-01 04:00:00	DIA	ETF	260.0	260.77	260.0	260.77	550.0
2019-03-01 06:00:00	DIA	ETF	260.88	261.03	260.88	261.03	4600.0

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

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