PREVIEW / etf_1hour / 2018-02-05

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-02-05.parquet
  size:    343 KB
  rows:    11,308

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-02-05 04:00:00	SPY	ETF	274.56	275.1	274.48	275.07	62410.0
2018-02-05 05:00:00	SPY	ETF	274.88	275.0	274.38	274.38	45460.0
2018-02-05 06:00:00	SPY	ETF	274.49	274.49	273.75	273.79	136148.0
2018-02-05 07:00:00	SPY	ETF	273.82	273.93	273.04	273.91	857992.0
2018-02-05 08:00:00	SPY	ETF	273.86	274.6	273.11	274.19	2010708.0
2018-02-05 09:00:00	SPY	ETF	274.19	274.26	272.96	274.0	19055906.0
2018-02-05 10:00:00	SPY	ETF	274.0	275.85	273.62	275.39	22770812.0
2018-02-05 11:00:00	SPY	ETF	275.4	275.76	274.01	274.5	13852148.0
2018-02-05 12:00:00	SPY	ETF	274.505	274.56	272.82	273.19	13686915.0
2018-02-05 13:00:00	SPY	ETF	273.18	273.19	271.1	272.64	35748593.0
2018-02-05 14:00:00	SPY	ETF	272.65	272.71	268.4	268.54	43103815.0
2018-02-05 15:00:00	SPY	ETF	268.55	269.41	263.31	264.18	103448153.0
2018-02-05 16:00:00	SPY	ETF	264.2	273.4	259.35	261.31	30456007.0
2018-02-05 17:00:00	SPY	ETF	261.4	267.08	260.4	261.64	1200544.0
2018-02-05 18:00:00	SPY	ETF	261.64	270.4263	260.12	261.44	1347502.0
2018-02-05 19:00:00	SPY	ETF	261.43	273.44	260.66	261.1	632141.0
2018-02-05 04:00:00	QQQ	ETF	164.12	164.37	164.12	164.32	56421.0
2018-02-05 05:00:00	QQQ	ETF	164.31	164.4	164.2	164.24	31416.0
2018-02-05 06:00:00	QQQ	ETF	164.06	164.06	163.58	163.58	49577.0
2018-02-05 07:00:00	QQQ	ETF	163.6	163.6	162.68	163.14	846439.0
2018-02-05 08:00:00	QQQ	ETF	163.11	164.42	162.77	163.65	577167.0
2018-02-05 09:00:00	QQQ	ETF	163.58	164.1001	162.53	164.1001	9390280.0
2018-02-05 10:00:00	QQQ	ETF	164.1	165.75	163.74	165.0383	9981810.0
2018-02-05 11:00:00	QQQ	ETF	165.04	165.36	164.01	164.4499	5174897.0
2018-02-05 12:00:00	QQQ	ETF	164.44	164.49	163.43	163.92	5429548.0
2018-02-05 13:00:00	QQQ	ETF	163.91	163.95	162.75	163.885	10707285.0
2018-02-05 14:00:00	QQQ	ETF	163.9	163.9268	161.1001	161.32	11587361.0
2018-02-05 15:00:00	QQQ	ETF	161.32	161.66	158.0	158.15	37957577.0
2018-02-05 16:00:00	QQQ	ETF	158.13	163.3833	155.53	157.35	4118293.0
2018-02-05 17:00:00	QQQ	ETF	157.2	158.12	156.6	157.15	651944.0
2018-02-05 18:00:00	QQQ	ETF	157.3	158.0	156.15	156.98	205724.0
2018-02-05 19:00:00	QQQ	ETF	156.88	157.49	156.54	156.6	90737.0
2018-02-05 04:00:00	IWM	ETF	152.76	153.09	152.76	153.07	10537.0
2018-02-05 05:00:00	IWM	ETF	152.98	152.98	152.77	152.77	1858.0
2018-02-05 06:00:00	IWM	ETF	152.61	152.66	152.27	152.44	38500.0
2018-02-05 07:00:00	IWM	ETF	152.35	152.49	151.96	152.49	241020.0
2018-02-05 08:00:00	IWM	ETF	153.83	153.83	152.31	153.03	185855.0
2018-02-05 09:00:00	IWM	ETF	153.0	153.05	151.92	152.94	4312570.0
2018-02-05 10:00:00	IWM	ETF	152.96	153.79	152.79	153.35	4377258.0
2018-02-05 11:00:00	IWM	ETF	153.37	153.5	152.72	152.97	2420201.0
2018-02-05 12:00:00	IWM	ETF	152.96	153.01	152.15	152.24	2267697.0
2018-02-05 13:00:00	IWM	ETF	152.22	152.22	151.17	152.15	4134312.0
2018-02-05 14:00:00	IWM	ETF	152.16	152.19	150.09	150.15	4857926.0
2018-02-05 15:00:00	IWM	ETF	150.15	150.8	147.86	148.0	18221314.0
2018-02-05 16:00:00	IWM	ETF	147.98	153.7002	144.25	146.0	5085048.0
2018-02-05 17:00:00	IWM	ETF	145.8	148.1364	145.3	146.11	323736.0
2018-02-05 18:00:00	IWM	ETF	145.8	152.59	145.2	145.81	118956.0
2018-02-05 19:00:00	IWM	ETF	145.95	146.57	145.45	145.76	117523.0
2018-02-05 05:00:00	DIA	ETF	253.8	253.8	253.61	253.61	10100.0
2018-02-05 06:00:00	DIA	ETF	253.06	253.14	252.58	252.58	4833.0

> showing 50 of 11,308 rows — these rows as CSV

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