PREVIEW / etf_1hour / 2018-03-02

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-03-02.parquet
  size:    309 KB
  rows:    10,059

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-03-02 04:00:00	SPY	ETF	267.79	267.79	267.0	267.04	42826.0
2018-03-02 05:00:00	SPY	ETF	267.08	267.43	266.48	266.61	126759.0
2018-03-02 06:00:00	SPY	ETF	266.46	266.84	266.02	266.67	146770.0
2018-03-02 07:00:00	SPY	ETF	266.68	266.9	265.7	265.8	615785.0
2018-03-02 08:00:00	SPY	ETF	267.24	268.32	265.42	266.32	1588873.0
2018-03-02 09:00:00	SPY	ETF	266.33	266.59	264.82	265.57	17273449.0
2018-03-02 10:00:00	SPY	ETF	265.58	266.859	264.93	265.97	16757406.0
2018-03-02 11:00:00	SPY	ETF	265.97	267.88	265.4514	267.84	14780600.0
2018-03-02 12:00:00	SPY	ETF	267.84	268.66	267.1	268.41	11493377.0
2018-03-02 13:00:00	SPY	ETF	268.41	268.48	266.53	267.21	13120881.0
2018-03-02 14:00:00	SPY	ETF	267.22	268.43	267.22	267.735	11648366.0
2018-03-02 15:00:00	SPY	ETF	267.73	269.72	267.08	269.13	25389310.0
2018-03-02 16:00:00	SPY	ETF	269.15	269.45	267.8553	269.13	20663911.0
2018-03-02 17:00:00	SPY	ETF	269.11	269.4	269.04	269.37	163106.0
2018-03-02 18:00:00	SPY	ETF	269.39	269.45	269.33	269.35	30443.0
2018-03-02 19:00:00	SPY	ETF	269.39	269.47	269.3	269.32	35876.0
2018-03-02 04:00:00	QQQ	ETF	164.59	164.59	164.12	164.18	84238.0
2018-03-02 05:00:00	QQQ	ETF	164.17	164.36	163.73	163.79	101133.0
2018-03-02 06:00:00	QQQ	ETF	163.69	164.45	163.08	163.42	159396.0
2018-03-02 07:00:00	QQQ	ETF	163.44	163.75	162.71	162.77	702634.0
2018-03-02 08:00:00	QQQ	ETF	162.79	163.69	162.54	163.07	725655.0
2018-03-02 09:00:00	QQQ	ETF	163.02	163.37	161.96	162.92	8351550.0
2018-03-02 10:00:00	QQQ	ETF	162.93	163.96	162.48	163.3459	7284559.0
2018-03-02 11:00:00	QQQ	ETF	163.34	164.75	163.09	164.74	7160395.0
2018-03-02 12:00:00	QQQ	ETF	164.74	165.3	164.33	165.13	4320452.0
2018-03-02 13:00:00	QQQ	ETF	165.1101	165.2	163.76	164.37	6926402.0
2018-03-02 14:00:00	QQQ	ETF	164.37	165.42	164.37	164.84	3992763.0
2018-03-02 15:00:00	QQQ	ETF	164.84	166.28	164.45	165.98	9517661.0
2018-03-02 16:00:00	QQQ	ETF	165.98	166.0359	163.0723	165.88	4609131.0
2018-03-02 17:00:00	QQQ	ETF	166.0	166.05	165.92	166.0	33982.0
2018-03-02 18:00:00	QQQ	ETF	165.99	166.1	165.95	166.1	4119.0
2018-03-02 19:00:00	QQQ	ETF	166.14	166.14	165.99	166.13	13649.0
2018-03-02 04:00:00	IWM	ETF	149.27	149.27	149.14	149.21	3000.0
2018-03-02 05:00:00	IWM	ETF	149.13	149.37	148.9	148.98	44441.0
2018-03-02 06:00:00	IWM	ETF	148.9	149.0	148.56	149.0	46071.0
2018-03-02 07:00:00	IWM	ETF	148.96	149.1	148.45	148.46	75168.0
2018-03-02 08:00:00	IWM	ETF	148.49	149.87	148.29	148.77	161454.0
2018-03-02 09:00:00	IWM	ETF	148.75	149.3	148.4	149.18	4000500.0
2018-03-02 10:00:00	IWM	ETF	149.22	150.11	149.0	149.79	3789066.0
2018-03-02 11:00:00	IWM	ETF	149.79	151.26	149.69	151.26	3847612.0
2018-03-02 12:00:00	IWM	ETF	151.25	152.05	150.0	151.89	2814325.0
2018-03-02 13:00:00	IWM	ETF	151.87	151.96	150.96	151.58	2264708.0
2018-03-02 14:00:00	IWM	ETF	151.58	152.06	151.48	151.68	2420991.0
2018-03-02 15:00:00	IWM	ETF	151.67	152.75	151.32	152.365	6078686.0
2018-03-02 16:00:00	IWM	ETF	152.35	152.4543	149.2615	152.13	1744136.0
2018-03-02 17:00:00	IWM	ETF	152.24	152.35	152.22	152.3	2663.0
2018-03-02 18:00:00	IWM	ETF	152.3	152.45	152.3	152.45	600.0
2018-03-02 19:00:00	IWM	ETF	152.45	152.45	152.45	152.45	100.0
2018-03-02 05:00:00	DIA	ETF	245.01	245.1	244.39	244.39	709.0
2018-03-02 06:00:00	DIA	ETF	244.01	244.28	243.91	244.26	3850.0

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

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