PREVIEW / etf_1hour / 2018-06-29

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-06-29.parquet
  size:    305 KB
  rows:    10,078

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-06-29 04:00:00	SPY	ETF	272.48	272.8	272.47	272.67	31976.0
2018-06-29 05:00:00	SPY	ETF	272.68	272.69	272.13	272.16	76909.0
2018-06-29 06:00:00	SPY	ETF	272.12	272.33	271.51	271.79	175274.0
2018-06-29 07:00:00	SPY	ETF	271.78	272.32	271.64	272.26	242988.0
2018-06-29 08:00:00	SPY	ETF	271.88	272.52	270.89	271.81	870692.0
2018-06-29 09:00:00	SPY	ETF	271.83	272.98	271.79	272.755	7227836.0
2018-06-29 10:00:00	SPY	ETF	272.755	273.547	272.54	273.4045	9262379.0
2018-06-29 11:00:00	SPY	ETF	273.4	273.66	272.79	272.93	7387432.0
2018-06-29 12:00:00	SPY	ETF	272.925	273.41	272.62	272.84	5951556.0
2018-06-29 13:00:00	SPY	ETF	272.84	273.24	272.835	272.96	4706729.0
2018-06-29 14:00:00	SPY	ETF	272.95	273.04	272.51	272.98	6187587.0
2018-06-29 15:00:00	SPY	ETF	272.98	273.17	271.19	271.19	29091972.0
2018-06-29 16:00:00	SPY	ETF	271.23	271.73	270.9481	271.23	23112589.0
2018-06-29 17:00:00	SPY	ETF	271.26	271.8	271.08	271.23	187841.0
2018-06-29 18:00:00	SPY	ETF	271.21	271.21	271.05	271.15	71594.0
2018-06-29 19:00:00	SPY	ETF	271.18	271.18	271.08	271.16	17175.0
2018-06-29 04:00:00	QQQ	ETF	172.39	172.63	172.39	172.6	36013.0
2018-06-29 05:00:00	QQQ	ETF	172.6	172.6	172.3	172.3	27090.0
2018-06-29 06:00:00	QQQ	ETF	172.23	172.5	171.63	171.97	122183.0
2018-06-29 07:00:00	QQQ	ETF	171.95	172.28	171.83	172.25	165427.0
2018-06-29 08:00:00	QQQ	ETF	172.25	172.34	171.88	171.95	244420.0
2018-06-29 09:00:00	QQQ	ETF	171.97	172.7	171.93	172.52	2918979.0
2018-06-29 10:00:00	QQQ	ETF	172.51	172.92	172.1	172.71	4298602.0
2018-06-29 11:00:00	QQQ	ETF	172.7	172.83	172.01	172.19	2604430.0
2018-06-29 12:00:00	QQQ	ETF	172.19	172.52	171.85	172.04	2446972.0
2018-06-29 13:00:00	QQQ	ETF	172.05	172.45	171.98	172.39	1962813.0
2018-06-29 14:00:00	QQQ	ETF	172.38	172.48	172.14	172.43	2826324.0
2018-06-29 15:00:00	QQQ	ETF	172.4372	172.54	171.43	171.44	10707745.0
2018-06-29 16:00:00	QQQ	ETF	171.43	171.82	171.4029	171.58	2534818.0
2018-06-29 17:00:00	QQQ	ETF	171.64	171.65	171.54	171.65	43916.0
2018-06-29 18:00:00	QQQ	ETF	171.65	171.65	171.5601	171.6	71308.0
2018-06-29 19:00:00	QQQ	ETF	171.6	171.6	171.56	171.59	17325.0
2018-06-29 04:00:00	IWM	ETF	164.68	164.75	164.63	164.75	6400.0
2018-06-29 05:00:00	IWM	ETF	164.65	164.65	164.61	164.63	2000.0
2018-06-29 06:00:00	IWM	ETF	164.65	164.69	164.23	164.4	22750.0
2018-06-29 07:00:00	IWM	ETF	164.31	164.54	164.23	164.47	59205.0
2018-06-29 08:00:00	IWM	ETF	164.33	164.58	164.13	164.13	65317.0
2018-06-29 09:00:00	IWM	ETF	164.2	164.73	164.2	164.68	1899140.0
2018-06-29 10:00:00	IWM	ETF	164.68	165.02	164.44	164.92	2786391.0
2018-06-29 11:00:00	IWM	ETF	164.91	165.05	164.39	164.52	1839945.0
2018-06-29 12:00:00	IWM	ETF	164.51	164.61	164.19	164.26	1866118.0
2018-06-29 13:00:00	IWM	ETF	164.25	164.6799	164.24	164.41	1137013.0
2018-06-29 14:00:00	IWM	ETF	164.41	164.4885	164.18	164.32	2045160.0
2018-06-29 15:00:00	IWM	ETF	164.32	164.51	163.61	163.69	6005729.0
2018-06-29 16:00:00	IWM	ETF	163.7158	164.03	163.65	163.67	3005527.0
2018-06-29 17:00:00	IWM	ETF	163.73	163.73	163.5	163.52	16886.0
2018-06-29 18:00:00	IWM	ETF	163.77	163.77	163.77	163.77	29000.0
2018-06-29 19:00:00	IWM	ETF	163.59	163.59	163.59	163.59	100.0
2018-06-29 04:00:00	DIA	ETF	243.82	243.92	243.82	243.92	900.0
2018-06-29 06:00:00	DIA	ETF	243.68	243.68	242.86	243.38	1450.0

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

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