PREVIEW / etf_1hour / 2018-01-22

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-01-22.parquet
  size:    312 KB
  rows:    10,267

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-01-22 04:00:00	SPY	ETF	280.0	280.0	279.8	279.94	18142.0
2018-01-22 05:00:00	SPY	ETF	279.89	279.96	279.84	279.94	15776.0
2018-01-22 06:00:00	SPY	ETF	279.97	280.13	279.97	280.13	57176.0
2018-01-22 07:00:00	SPY	ETF	280.1	280.29	280.05	280.25	198941.0
2018-01-22 08:00:00	SPY	ETF	280.27	280.44	279.77	280.04	489844.0
2018-01-22 09:00:00	SPY	ETF	280.05	280.76	279.95	280.665	4211350.0
2018-01-22 10:00:00	SPY	ETF	280.66	281.43	280.59	281.0	10210018.0
2018-01-22 11:00:00	SPY	ETF	281.0	281.49	280.89	281.45	5380139.0
2018-01-22 12:00:00	SPY	ETF	281.44	281.96	281.35	281.71	6306310.0
2018-01-22 13:00:00	SPY	ETF	281.71	281.89	281.611	281.82	7007853.0
2018-01-22 14:00:00	SPY	ETF	281.82	281.87	281.45	281.71	5804438.0
2018-01-22 15:00:00	SPY	ETF	281.71	282.68	281.68	282.67	18095512.0
2018-01-22 16:00:00	SPY	ETF	282.66	282.91	282.62	282.71	11862993.0
2018-01-22 17:00:00	SPY	ETF	282.7	282.76	281.2194	282.7	8410769.0
2018-01-22 18:00:00	SPY	ETF	282.7	282.77	282.58	282.63	97766.0
2018-01-22 19:00:00	SPY	ETF	282.66	282.77	282.58	282.75	48929.0
2018-01-22 04:00:00	QQQ	ETF	166.21	166.25	166.16	166.23	4116.0
2018-01-22 05:00:00	QQQ	ETF	166.2	166.25	166.16	166.21	26337.0
2018-01-22 06:00:00	QQQ	ETF	166.27	166.36	166.25	166.36	3712.0
2018-01-22 07:00:00	QQQ	ETF	166.27	166.36	166.26	166.36	34018.0
2018-01-22 08:00:00	QQQ	ETF	166.35	166.45	166.25	166.28	112199.0
2018-01-22 09:00:00	QQQ	ETF	166.31	166.67	166.09	166.6	2726860.0
2018-01-22 10:00:00	QQQ	ETF	166.59	167.405	166.5233	167.1562	4336173.0
2018-01-22 11:00:00	QQQ	ETF	167.15	167.5252	167.13	167.51	1708611.0
2018-01-22 12:00:00	QQQ	ETF	167.5	167.77	167.425	167.625	2350012.0
2018-01-22 13:00:00	QQQ	ETF	167.63	167.74	167.57	167.68	1174272.0
2018-01-22 14:00:00	QQQ	ETF	167.68	167.7	167.4201	167.52	1560320.0
2018-01-22 15:00:00	QQQ	ETF	167.5252	168.12	167.51	168.11	4420783.0
2018-01-22 16:00:00	QQQ	ETF	168.1	168.68	167.3341	168.46	1401630.0
2018-01-22 17:00:00	QQQ	ETF	168.43	168.54	166.9941	168.46	57677.0
2018-01-22 18:00:00	QQQ	ETF	168.44	168.47	168.39	168.39	40372.0
2018-01-22 19:00:00	QQQ	ETF	168.4	168.59	168.4	168.57	14318.0
2018-01-22 04:00:00	IWM	ETF	158.21	158.27	158.13	158.24	6750.0
2018-01-22 05:00:00	IWM	ETF	158.26	158.26	158.18	158.18	1300.0
2018-01-22 06:00:00	IWM	ETF	158.24	158.32	158.24	158.27	300.0
2018-01-22 07:00:00	IWM	ETF	158.32	158.37	158.28	158.37	17553.0
2018-01-22 08:00:00	IWM	ETF	157.56	158.6	157.56	158.27	74399.0
2018-01-22 09:00:00	IWM	ETF	158.27	158.71	158.15	158.47	1146695.0
2018-01-22 10:00:00	IWM	ETF	158.49	158.9768	158.34	158.6	2599877.0
2018-01-22 11:00:00	IWM	ETF	158.6	158.845	158.39	158.825	1075249.0
2018-01-22 12:00:00	IWM	ETF	158.82	159.185	158.77	158.89	1712237.0
2018-01-22 13:00:00	IWM	ETF	158.89	159.061	158.775	159.061	871197.0
2018-01-22 14:00:00	IWM	ETF	159.06	159.1	158.81	158.97	836901.0
2018-01-22 15:00:00	IWM	ETF	158.97	159.44	158.95	159.43	2524164.0
2018-01-22 16:00:00	IWM	ETF	159.43	159.54	159.3	159.3	552210.0
2018-01-22 17:00:00	IWM	ETF	158.807	159.45	158.807	159.33	24817.0
2018-01-22 18:00:00	IWM	ETF	159.33	159.39	159.27	159.3	15541.0
2018-01-22 19:00:00	IWM	ETF	159.33	159.38	159.29	159.34	9161.0
2018-01-22 04:00:00	DIA	ETF	260.1	260.1	259.73	259.73	500.0
2018-01-22 07:00:00	DIA	ETF	259.8	259.9	259.8	259.88	1676.0

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

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