PREVIEW / etf_1hour / 2018-07-06

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-07-06.parquet
  size:    298 KB
  rows:    9,823

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-07-06 04:00:00	SPY	ETF	272.8	273.28	272.74	273.25	23712.0
2018-07-06 05:00:00	SPY	ETF	273.25	273.35	272.74	272.85	19372.0
2018-07-06 06:00:00	SPY	ETF	272.84	272.85	272.62	272.65	24705.0
2018-07-06 07:00:00	SPY	ETF	272.66	272.69	272.36	272.41	109522.0
2018-07-06 08:00:00	SPY	ETF	272.6101	273.72	272.44	273.03	1363102.0
2018-07-06 09:00:00	SPY	ETF	273.03	273.74	272.715	273.71	4938135.0
2018-07-06 10:00:00	SPY	ETF	273.72	274.49	273.561	274.365	6627820.0
2018-07-06 11:00:00	SPY	ETF	274.36	275.6	274.31	275.33	9629669.0
2018-07-06 12:00:00	SPY	ETF	275.33	275.67	275.2116	275.36	6495560.0
2018-07-06 13:00:00	SPY	ETF	275.36	275.72	275.35	275.5	3457362.0
2018-07-06 14:00:00	SPY	ETF	275.5008	275.62	275.21	275.53	5366848.0
2018-07-06 15:00:00	SPY	ETF	275.54	275.84	274.89	275.37	16472327.0
2018-07-06 16:00:00	SPY	ETF	275.36	275.57	275.25	275.47	8627669.0
2018-07-06 17:00:00	SPY	ETF	275.47	275.53	275.42	275.44	958852.0
2018-07-06 18:00:00	SPY	ETF	275.47	275.52	275.38	275.38	47659.0
2018-07-06 19:00:00	SPY	ETF	275.38	275.43	275.38	275.43	13152.0
2018-07-06 04:00:00	QQQ	ETF	172.91	173.09	172.65	173.03	5489.0
2018-07-06 05:00:00	QQQ	ETF	173.1	173.11	172.71	172.82	20333.0
2018-07-06 06:00:00	QQQ	ETF	172.83	172.83	172.68	172.78	25113.0
2018-07-06 07:00:00	QQQ	ETF	172.71	172.79	172.57	172.63	57650.0
2018-07-06 08:00:00	QQQ	ETF	172.92	173.64	172.5801	173.15	626684.0
2018-07-06 09:00:00	QQQ	ETF	173.12	173.95	173.0	173.92	3634576.0
2018-07-06 10:00:00	QQQ	ETF	173.92	174.3385	173.69	174.25	3839287.0
2018-07-06 11:00:00	QQQ	ETF	174.25	175.21	174.23	175.0775	4081064.0
2018-07-06 12:00:00	QQQ	ETF	175.08	175.4	175.05	175.24	3816786.0
2018-07-06 13:00:00	QQQ	ETF	175.2401	175.37	175.21	175.28	1318830.0
2018-07-06 14:00:00	QQQ	ETF	175.28	175.49	175.13	175.41	2048950.0
2018-07-06 15:00:00	QQQ	ETF	175.4016	175.74	175.11	175.52	7409656.0
2018-07-06 16:00:00	QQQ	ETF	175.52	175.66	175.48	175.58	2796142.0
2018-07-06 17:00:00	QQQ	ETF	175.6	175.66	175.51	175.65	16850.0
2018-07-06 18:00:00	QQQ	ETF	175.55	175.63	175.5	175.58	16780.0
2018-07-06 19:00:00	QQQ	ETF	175.57	175.6	175.52	175.57	6902.0
2018-07-06 04:00:00	IWM	ETF	166.74	166.88	166.74	166.88	516.0
2018-07-06 05:00:00	IWM	ETF	166.62	166.65	166.62	166.65	688.0
2018-07-06 06:00:00	IWM	ETF	166.57	166.57	166.48	166.48	1103.0
2018-07-06 07:00:00	IWM	ETF	166.39	166.39	166.28	166.29	6655.0
2018-07-06 08:00:00	IWM	ETF	166.3	167.17	166.3	166.8	160752.0
2018-07-06 09:00:00	IWM	ETF	166.77	167.65	166.52	167.63	1956647.0
2018-07-06 10:00:00	IWM	ETF	167.62	168.18	167.48	168.035	2950737.0
2018-07-06 11:00:00	IWM	ETF	168.05	168.26	167.86	168.2	2431781.0
2018-07-06 12:00:00	IWM	ETF	168.2	168.38	168.1462	168.31	1735611.0
2018-07-06 13:00:00	IWM	ETF	168.3	168.44	168.21	168.23	1107839.0
2018-07-06 14:00:00	IWM	ETF	168.24	168.26	167.98	168.12	1306903.0
2018-07-06 15:00:00	IWM	ETF	168.13	168.29	167.92	168.25	3081103.0
2018-07-06 16:00:00	IWM	ETF	168.25	168.52	168.2149	168.52	936480.0
2018-07-06 17:00:00	IWM	ETF	168.41	168.44	168.41	168.44	1898.0
2018-07-06 18:00:00	IWM	ETF	168.45	168.46	168.43	168.45	400.0
2018-07-06 19:00:00	IWM	ETF	168.43	168.59	168.43	168.59	8481.0
2018-07-06 05:00:00	DIA	ETF	242.84	242.84	242.84	242.84	300.0
2018-07-06 06:00:00	DIA	ETF	242.72	242.72	242.72	242.72	2000.0

> showing 50 of 9,823 rows — these rows as CSV

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