PREVIEW / etf_1hour / 2018-01-16

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-01-16.parquet
  size:    326 KB
  rows:    10,638

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-01-16 04:00:00	SPY	ETF	279.0	279.5	279.0	279.49	23747.0
2018-01-16 05:00:00	SPY	ETF	279.44	279.59	279.44	279.59	42891.0
2018-01-16 06:00:00	SPY	ETF	279.59	279.65	279.4	279.4	32360.0
2018-01-16 07:00:00	SPY	ETF	279.34	279.37	279.15	279.3	313349.0
2018-01-16 08:00:00	SPY	ETF	279.31	279.48	279.15	279.45	438381.0
2018-01-16 09:00:00	SPY	ETF	279.44	280.09	279.26	279.99	9620398.0
2018-01-16 10:00:00	SPY	ETF	280.0	280.01	278.67	278.755	11103229.0
2018-01-16 11:00:00	SPY	ETF	278.76	279.03	278.31	278.479	9510948.0
2018-01-16 12:00:00	SPY	ETF	278.48	278.89	278.25	278.3131	5388527.0
2018-01-16 13:00:00	SPY	ETF	278.31	278.535	277.61	277.69	15645835.0
2018-01-16 14:00:00	SPY	ETF	277.7	277.79	276.18	276.76	17322243.0
2018-01-16 15:00:00	SPY	ETF	276.77	277.59	276.76	276.96	25816133.0
2018-01-16 16:00:00	SPY	ETF	276.93	278.7872	276.93	277.47	10057069.0
2018-01-16 17:00:00	SPY	ETF	277.48	277.5	277.3	277.41	266192.0
2018-01-16 18:00:00	SPY	ETF	277.4	277.48	277.06	277.28	173467.0
2018-01-16 19:00:00	SPY	ETF	277.28	277.52	277.28	277.44	75770.0
2018-01-16 04:00:00	QQQ	ETF	165.2	165.48	165.1	165.48	32722.0
2018-01-16 05:00:00	QQQ	ETF	165.49	165.71	165.46	165.69	25100.0
2018-01-16 06:00:00	QQQ	ETF	165.7	165.77	165.6	165.63	37850.0
2018-01-16 07:00:00	QQQ	ETF	165.61	165.62	165.5	165.57	69219.0
2018-01-16 08:00:00	QQQ	ETF	165.6	165.68	165.5	165.59	94650.0
2018-01-16 09:00:00	QQQ	ETF	165.59	166.415	165.45	166.23	4412025.0
2018-01-16 10:00:00	QQQ	ETF	166.23	166.3161	165.48	165.63	4357429.0
2018-01-16 11:00:00	QQQ	ETF	165.62	165.695	164.98	165.03	5352548.0
2018-01-16 12:00:00	QQQ	ETF	165.04	165.45	164.75	164.8661	2256627.0
2018-01-16 13:00:00	QQQ	ETF	164.87	165.02	164.44	164.4699	2970005.0
2018-01-16 14:00:00	QQQ	ETF	164.47	164.56	163.53	163.91	7055814.0
2018-01-16 15:00:00	QQQ	ETF	163.93	164.49	163.9	163.99	7808546.0
2018-01-16 16:00:00	QQQ	ETF	163.98	164.44	163.97	164.29	935482.0
2018-01-16 17:00:00	QQQ	ETF	164.36	164.36	164.23	164.25	17448.0
2018-01-16 18:00:00	QQQ	ETF	164.28	164.36	163.9	164.03	40520.0
2018-01-16 19:00:00	QQQ	ETF	164.05	164.25	164.05	164.13	17704.0
2018-01-16 04:00:00	IWM	ETF	158.55	158.75	158.55	158.74	16816.0
2018-01-16 05:00:00	IWM	ETF	158.82	158.9	158.82	158.87	4765.0
2018-01-16 06:00:00	IWM	ETF	158.89	158.9	158.84	158.84	10479.0
2018-01-16 07:00:00	IWM	ETF	158.65	158.73	158.6	158.7	40136.0
2018-01-16 08:00:00	IWM	ETF	158.7	158.95	158.63	158.9	82318.0
2018-01-16 09:00:00	IWM	ETF	158.87	159.05	158.75	159.005	1952761.0
2018-01-16 10:00:00	IWM	ETF	159.01	159.41	158.68	158.68	3111655.0
2018-01-16 11:00:00	IWM	ETF	158.68	158.84	158.21	158.27	2076874.0
2018-01-16 12:00:00	IWM	ETF	158.26	158.415	157.65	157.709	1318958.0
2018-01-16 13:00:00	IWM	ETF	157.7	157.76	157.11	157.1338	2110585.0
2018-01-16 14:00:00	IWM	ETF	157.14	157.22	155.8	156.42	4901393.0
2018-01-16 15:00:00	IWM	ETF	156.43	156.96	156.08	156.13	5405000.0
2018-01-16 16:00:00	IWM	ETF	156.2108	156.69	156.14	156.61	1694945.0
2018-01-16 17:00:00	IWM	ETF	156.52	156.63	156.14	156.45	115366.0
2018-01-16 18:00:00	IWM	ETF	156.53	156.61	156.31	156.45	24170.0
2018-01-16 19:00:00	IWM	ETF	156.48	156.66	156.48	156.57	8822.0
2018-01-16 04:00:00	DIA	ETF	258.83	260.6	258.83	260.5	2100.0
2018-01-16 05:00:00	DIA	ETF	260.5	260.56	260.5	260.5	2800.0

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

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