PREVIEW / etf_1hour / 2019-03-04

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-03-04.parquet
  size:    332 KB
  rows:    11,085

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
2019-03-04 04:00:00	SPY	ETF	281.59	281.64	280.9	281.24	22970.0
2019-03-04 05:00:00	SPY	ETF	281.1	281.31	281.08	281.21	16751.0
2019-03-04 06:00:00	SPY	ETF	281.15	281.36	281.1	281.21	20684.0
2019-03-04 07:00:00	SPY	ETF	281.3	281.45	281.28	281.39	56332.0
2019-03-04 08:00:00	SPY	ETF	281.34	281.81	281.34	281.55	290075.0
2019-03-04 09:00:00	SPY	ETF	281.56	281.87	281.2	281.6	8958501.0
2019-03-04 10:00:00	SPY	ETF	281.6	281.69	280.65	280.69	9082777.0
2019-03-04 11:00:00	SPY	ETF	280.685	280.76	277.66	277.95	16809263.0
2019-03-04 12:00:00	SPY	ETF	277.95	278.43	276.91	277.4	16542652.0
2019-03-04 13:00:00	SPY	ETF	277.39	278.545	276.84	278.47	11517530.0
2019-03-04 14:00:00	SPY	ETF	278.47	279.06	278.21	278.69	9450881.0
2019-03-04 15:00:00	SPY	ETF	278.68	279.49	278.39	279.41	17533659.0
2019-03-04 16:00:00	SPY	ETF	279.42	279.42	279.17	279.21	13219816.0
2019-03-04 17:00:00	SPY	ETF	279.16	279.4	279.11	279.15	188139.0
2019-03-04 18:00:00	SPY	ETF	279.15	279.4	278.9	279.16	95714.0
2019-03-04 19:00:00	SPY	ETF	279.19	279.31	278.91	279.07	83758.0
2019-03-04 04:00:00	QQQ	ETF	174.95	175.47	174.95	175.2	37971.0
2019-03-04 05:00:00	QQQ	ETF	175.16	175.28	175.08	175.14	35800.0
2019-03-04 06:00:00	QQQ	ETF	175.05	175.26	175.05	175.15	67818.0
2019-03-04 07:00:00	QQQ	ETF	175.18	175.33	175.18	175.3	79386.0
2019-03-04 08:00:00	QQQ	ETF	175.24	175.61	175.085	175.42	125823.0
2019-03-04 09:00:00	QQQ	ETF	175.45	175.79	175.3	175.69	3244092.0
2019-03-04 10:00:00	QQQ	ETF	175.7	175.75	174.87	174.875	4198460.0
2019-03-04 11:00:00	QQQ	ETF	174.88	174.98	172.8	173.0074	7462139.0
2019-03-04 12:00:00	QQQ	ETF	173.0	173.4	172.47	173.06	6511519.0
2019-03-04 13:00:00	QQQ	ETF	173.07	173.8876	172.64	173.82	3809809.0
2019-03-04 14:00:00	QQQ	ETF	173.81	174.08	173.51	173.86	2994171.0
2019-03-04 15:00:00	QQQ	ETF	173.858	174.49	173.74	174.44	5203362.0
2019-03-04 16:00:00	QQQ	ETF	174.44	174.4411	174.14	174.18	786717.0
2019-03-04 17:00:00	QQQ	ETF	174.18	174.22	174.09	174.15	22698.0
2019-03-04 18:00:00	QQQ	ETF	174.14	174.14	173.93	174.1	75137.0
2019-03-04 19:00:00	QQQ	ETF	174.11	174.24	173.98	174.05	136560.0
2019-03-04 04:00:00	IWM	ETF	158.62	158.72	158.43	158.43	2450.0
2019-03-04 06:00:00	IWM	ETF	158.49	158.49	158.49	158.49	250.0
2019-03-04 07:00:00	IWM	ETF	158.5	158.53	158.47	158.47	29233.0
2019-03-04 08:00:00	IWM	ETF	158.5	158.53	158.45	158.48	73022.0
2019-03-04 09:00:00	IWM	ETF	158.48	158.775	157.965	158.25	1979003.0
2019-03-04 10:00:00	IWM	ETF	158.24	158.42	157.34	157.35	2983051.0
2019-03-04 11:00:00	IWM	ETF	157.35	157.4	156.05	156.13	4037058.0
2019-03-04 12:00:00	IWM	ETF	156.14	156.4499	155.64	155.9	3992019.0
2019-03-04 13:00:00	IWM	ETF	155.89	156.63	155.59	156.58	1660631.0
2019-03-04 14:00:00	IWM	ETF	156.57	156.85	156.42	156.66	1602366.0
2019-03-04 15:00:00	IWM	ETF	156.65	156.88	156.51	156.81	3511243.0
2019-03-04 16:00:00	IWM	ETF	156.79	156.8867	156.67	156.68	987172.0
2019-03-04 17:00:00	IWM	ETF	156.8	156.8	156.66	156.66	1733.0
2019-03-04 18:00:00	IWM	ETF	156.66	156.66	156.51	156.55	8852.0
2019-03-04 19:00:00	IWM	ETF	156.7	156.7	156.53	156.61	10550.0
2019-03-04 04:00:00	DIA	ETF	261.39	261.4	261.3	261.32	3400.0
2019-03-04 06:00:00	DIA	ETF	261.16	261.18	261.16	261.18	5300.0
2019-03-04 07:00:00	DIA	ETF	261.24	261.32	261.24	261.32	2540.0

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

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