PREVIEW / etf_1hour / 2018-11-27

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-11-27.parquet
  size:    311 KB
  rows:    10,271

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-11-27 04:00:00	SPY	ETF	266.8	267.5	266.65	266.84	59067.0
2018-11-27 05:00:00	SPY	ETF	266.85	266.99	266.46	266.58	43929.0
2018-11-27 06:00:00	SPY	ETF	266.44	266.5	266.06	266.5	77413.0
2018-11-27 07:00:00	SPY	ETF	266.53	266.55	265.87	265.87	281250.0
2018-11-27 08:00:00	SPY	ETF	266.15	268.45	265.66	266.05	572523.0
2018-11-27 09:00:00	SPY	ETF	266.05	266.92	265.66	266.6	7787757.0
2018-11-27 10:00:00	SPY	ETF	266.6	267.87	266.15	267.4714	10585181.0
2018-11-27 11:00:00	SPY	ETF	267.47	268.03	267.02	267.63	10675437.0
2018-11-27 12:00:00	SPY	ETF	267.64	267.71	266.5	266.8357	5910367.0
2018-11-27 13:00:00	SPY	ETF	266.8315	267.72	266.53	267.72	10236863.0
2018-11-27 14:00:00	SPY	ETF	267.72	268.18	267.595	267.785	5564935.0
2018-11-27 15:00:00	SPY	ETF	267.78	268.37	267.53	268.34	14345308.0
2018-11-27 16:00:00	SPY	ETF	268.32	268.73	268.18	268.63	5189872.0
2018-11-27 17:00:00	SPY	ETF	268.66	268.78	268.4	268.77	519989.0
2018-11-27 18:00:00	SPY	ETF	268.72	268.89	268.6	268.68	120403.0
2018-11-27 19:00:00	SPY	ETF	268.65	268.84	268.56	268.64	83711.0
2018-11-27 20:00:00	SPY	ETF	268.4	268.61	268.4	268.61	1000.0
2018-11-27 04:00:00	QQQ	ETF	161.74	162.61	161.74	162.26	14817.0
2018-11-27 05:00:00	QQQ	ETF	162.25	162.34	161.88	162.06	61939.0
2018-11-27 06:00:00	QQQ	ETF	162.02	162.02	161.66	161.98	79548.0
2018-11-27 07:00:00	QQQ	ETF	161.99	161.99	161.44	161.53	116275.0
2018-11-27 08:00:00	QQQ	ETF	162.89	163.1	161.43	161.82	358412.0
2018-11-27 09:00:00	QQQ	ETF	161.83	162.58	161.18	162.49	4705383.0
2018-11-27 10:00:00	QQQ	ETF	162.48	163.58	162.08	163.35	6932636.0
2018-11-27 11:00:00	QQQ	ETF	163.35	163.85	162.91	163.46	4173153.0
2018-11-27 12:00:00	QQQ	ETF	163.47	163.51	162.5	162.65	2626298.0
2018-11-27 13:00:00	QQQ	ETF	162.65	163.42	162.36	163.3973	3609016.0
2018-11-27 14:00:00	QQQ	ETF	163.41	163.78	163.175	163.19	2589084.0
2018-11-27 15:00:00	QQQ	ETF	163.19	163.49	162.88	163.47	4629741.0
2018-11-27 16:00:00	QQQ	ETF	163.46	163.81	163.36	163.79	981635.0
2018-11-27 17:00:00	QQQ	ETF	163.85	163.96	163.44	163.9	112897.0
2018-11-27 18:00:00	QQQ	ETF	163.89	164.0	163.76	163.86	50840.0
2018-11-27 19:00:00	QQQ	ETF	163.84	163.98	163.8	163.91	37248.0
2018-11-27 04:00:00	IWM	ETF	149.48	149.72	149.48	149.67	2749.0
2018-11-27 05:00:00	IWM	ETF	149.49	149.49	149.3	149.3	700.0
2018-11-27 06:00:00	IWM	ETF	149.02	149.15	149.02	149.14	1800.0
2018-11-27 07:00:00	IWM	ETF	149.07	149.1	149.0	149.0	2671.0
2018-11-27 08:00:00	IWM	ETF	149.86	149.86	148.88	149.14	23526.0
2018-11-27 09:00:00	IWM	ETF	149.04	149.51	148.58	149.29	1652500.0
2018-11-27 10:00:00	IWM	ETF	149.29	149.73	148.6	149.29	1988213.0
2018-11-27 11:00:00	IWM	ETF	149.28	149.71	148.97	149.4	1192619.0
2018-11-27 12:00:00	IWM	ETF	149.3938	149.46	148.29	148.56	1161537.0
2018-11-27 13:00:00	IWM	ETF	148.5699	148.95	148.29	148.94	1607984.0
2018-11-27 14:00:00	IWM	ETF	148.97	149.15	148.675	148.7096	1424013.0
2018-11-27 15:00:00	IWM	ETF	148.7	148.79	148.31	148.59	3022065.0
2018-11-27 16:00:00	IWM	ETF	148.59	148.78	148.47	148.76	642798.0
2018-11-27 17:00:00	IWM	ETF	148.78	148.78	148.57	148.63	11984.0
2018-11-27 18:00:00	IWM	ETF	148.81	148.81	148.69	148.69	1300.0
2018-11-27 19:00:00	IWM	ETF	148.74	148.8	148.7	148.7	8600.0
2018-11-27 04:00:00	DIA	ETF	246.7	246.71	246.7	246.71	372.0

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

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