PREVIEW / etf_1hour / 2018-03-06

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-03-06.parquet
  size:    308 KB
  rows:    10,155

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-03-06 04:00:00	SPY	ETF	272.43	272.64	272.39	272.62	17232.0
2018-03-06 05:00:00	SPY	ETF	272.64	272.71	272.37	272.66	46133.0
2018-03-06 06:00:00	SPY	ETF	272.67	273.57	272.61	273.37	85627.0
2018-03-06 07:00:00	SPY	ETF	273.38	273.38	272.92	273.18	212043.0
2018-03-06 08:00:00	SPY	ETF	273.21	273.38	271.94	272.83	516691.0
2018-03-06 09:00:00	SPY	ETF	272.94	273.39	272.1289	272.675	8116164.0
2018-03-06 10:00:00	SPY	ETF	272.68	273.0	271.46	271.6486	12228438.0
2018-03-06 11:00:00	SPY	ETF	271.65	272.2093	271.18	272.12	12373629.0
2018-03-06 12:00:00	SPY	ETF	272.105	272.94	271.5825	272.93	6884356.0
2018-03-06 13:00:00	SPY	ETF	272.93	273.155	272.22	272.42	6094516.0
2018-03-06 14:00:00	SPY	ETF	272.4	273.2	272.16	272.93	5763713.0
2018-03-06 15:00:00	SPY	ETF	272.94	273.04	272.33	272.89	15223032.0
2018-03-06 16:00:00	SPY	ETF	272.94	273.3239	272.48	272.53	5257774.0
2018-03-06 17:00:00	SPY	ETF	272.6	272.6	269.18	269.61	3796253.0
2018-03-06 18:00:00	SPY	ETF	269.65	270.15	269.16	269.43	1444325.0
2018-03-06 19:00:00	SPY	ETF	269.4	269.62	268.32	268.83	660565.0
2018-03-06 04:00:00	QQQ	ETF	168.0	168.3	168.0	168.27	33758.0
2018-03-06 05:00:00	QQQ	ETF	168.1	168.44	168.08	168.38	16066.0
2018-03-06 06:00:00	QQQ	ETF	168.38	168.78	168.35	168.64	44068.0
2018-03-06 07:00:00	QQQ	ETF	168.71	168.73	168.47	168.71	149820.0
2018-03-06 08:00:00	QQQ	ETF	168.71	168.75	168.37	168.48	384343.0
2018-03-06 09:00:00	QQQ	ETF	168.5	168.98	168.12	168.86	4424493.0
2018-03-06 10:00:00	QQQ	ETF	168.86	169.11	167.87	167.96	4440250.0
2018-03-06 11:00:00	QQQ	ETF	167.97	168.24	167.48	168.23	3342048.0
2018-03-06 12:00:00	QQQ	ETF	168.224	168.71	167.92	168.7	2207835.0
2018-03-06 13:00:00	QQQ	ETF	168.7	168.83	168.03	168.175	2772953.0
2018-03-06 14:00:00	QQQ	ETF	168.17	168.695	167.98	168.51	2619703.0
2018-03-06 15:00:00	QQQ	ETF	168.515	168.555	168.12	168.52	4197090.0
2018-03-06 16:00:00	QQQ	ETF	168.53	168.6	168.3	168.4	1066389.0
2018-03-06 17:00:00	QQQ	ETF	168.37	168.41	166.5	166.78	213644.0
2018-03-06 18:00:00	QQQ	ETF	166.85	168.54	166.22	166.35	211038.0
2018-03-06 19:00:00	QQQ	ETF	166.35	166.42	165.73	166.03	166027.0
2018-03-06 04:00:00	IWM	ETF	154.11	154.19	154.05	154.19	6303.0
2018-03-06 05:00:00	IWM	ETF	154.09	154.36	154.09	154.36	5888.0
2018-03-06 06:00:00	IWM	ETF	154.51	154.74	154.46	154.57	8411.0
2018-03-06 07:00:00	IWM	ETF	154.62	154.62	154.38	154.38	43862.0
2018-03-06 08:00:00	IWM	ETF	154.5	154.63	154.29	154.33	27757.0
2018-03-06 09:00:00	IWM	ETF	154.25	154.48	153.76	153.95	1287993.0
2018-03-06 10:00:00	IWM	ETF	153.955	154.245	152.8	152.94	1941616.0
2018-03-06 11:00:00	IWM	ETF	152.95	154.07	152.84	154.06	1409073.0
2018-03-06 12:00:00	IWM	ETF	154.06	154.99	153.99	154.955	1770714.0
2018-03-06 13:00:00	IWM	ETF	154.95	155.0599	154.42	154.63	1165637.0
2018-03-06 14:00:00	IWM	ETF	154.63	155.16	154.5601	155.045	1102190.0
2018-03-06 15:00:00	IWM	ETF	155.05	155.39	154.83	155.36	3484335.0
2018-03-06 16:00:00	IWM	ETF	155.37	155.4	154.96	155.0	977457.0
2018-03-06 17:00:00	IWM	ETF	155.19	155.19	153.35	153.64	81405.0
2018-03-06 18:00:00	IWM	ETF	153.64	155.37	153.28	153.52	53848.0
2018-03-06 19:00:00	IWM	ETF	153.55	153.6	153.06	153.26	24115.0
2018-03-06 04:00:00	DIA	ETF	249.44	249.44	249.44	249.44	100.0
2018-03-06 05:00:00	DIA	ETF	249.3	249.3	249.3	249.3	200.0

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

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