PREVIEW / etf_1hour / 2019-08-13

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-08-13.parquet
  size:    341 KB
  rows:    11,177

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-08-13 04:00:00	SPY	ETF	287.2	288.02	287.12	288.02	13785.0
2019-08-13 05:00:00	SPY	ETF	287.88	287.88	286.5	286.78	34937.0
2019-08-13 06:00:00	SPY	ETF	286.82	287.67	286.66	287.66	69937.0
2019-08-13 07:00:00	SPY	ETF	287.68	287.88	286.99	287.18	319479.0
2019-08-13 08:00:00	SPY	ETF	287.7799	288.43	286.55	287.2	806112.0
2019-08-13 09:00:00	SPY	ETF	287.22	293.5	287.02	292.97	21961913.0
2019-08-13 10:00:00	SPY	ETF	292.93	294.15	292.0	292.34	18014818.0
2019-08-13 11:00:00	SPY	ETF	292.32	292.98	291.48	292.89	10012850.0
2019-08-13 12:00:00	SPY	ETF	292.91	293.459	292.36	292.65	5292751.0
2019-08-13 13:00:00	SPY	ETF	292.66	293.17	291.98	292.67	6887875.0
2019-08-13 14:00:00	SPY	ETF	292.68	293.33	292.56	292.89	6038265.0
2019-08-13 15:00:00	SPY	ETF	292.87	293.02	292.11	292.43	14622758.0
2019-08-13 16:00:00	SPY	ETF	292.42	293.15	292.32	292.91	7234486.0
2019-08-13 17:00:00	SPY	ETF	292.9	292.9	292.55	292.77	809259.0
2019-08-13 18:00:00	SPY	ETF	292.82	292.98	292.61	292.92	154813.0
2019-08-13 19:00:00	SPY	ETF	292.93	293.07	292.73	292.94	63817.0
2019-08-13 04:00:00	QQQ	ETF	183.64	184.28	183.64	184.27	20390.0
2019-08-13 05:00:00	QQQ	ETF	183.98	184.0	183.02	183.39	41035.0
2019-08-13 06:00:00	QQQ	ETF	183.3	184.1	183.18	184.08	32913.0
2019-08-13 07:00:00	QQQ	ETF	184.09	184.27	183.6	183.77	84504.0
2019-08-13 08:00:00	QQQ	ETF	184.14	184.47	183.37	183.79	262812.0
2019-08-13 09:00:00	QQQ	ETF	183.79	189.32	183.63	189.07	8031865.0
2019-08-13 10:00:00	QQQ	ETF	189.03	189.68	188.18	188.23	7842437.0
2019-08-13 11:00:00	QQQ	ETF	188.21	188.66	187.37	188.5	4795434.0
2019-08-13 12:00:00	QQQ	ETF	188.52	188.77	188.02	188.235	2399525.0
2019-08-13 13:00:00	QQQ	ETF	188.24	188.63	187.86	188.45	2274465.0
2019-08-13 14:00:00	QQQ	ETF	188.46	189.08	188.3701	188.74	1854656.0
2019-08-13 15:00:00	QQQ	ETF	188.73	188.825	188.21	188.44	5127548.0
2019-08-13 16:00:00	QQQ	ETF	188.44	188.87	188.31	188.78	2701038.0
2019-08-13 17:00:00	QQQ	ETF	188.84	188.84	188.54	188.6	53400.0
2019-08-13 18:00:00	QQQ	ETF	188.64	188.86	188.53	188.77	46714.0
2019-08-13 19:00:00	QQQ	ETF	188.85	188.92	188.67	188.79	22125.0
2019-08-13 04:00:00	IWM	ETF	148.5	148.5	148.49	148.49	1127.0
2019-08-13 05:00:00	IWM	ETF	148.0	148.06	147.82	147.82	10800.0
2019-08-13 06:00:00	IWM	ETF	148.13	148.28	148.11	148.25	6161.0
2019-08-13 07:00:00	IWM	ETF	148.35	148.38	148.01	148.19	103944.0
2019-08-13 08:00:00	IWM	ETF	148.28	148.38	147.81	147.97	111224.0
2019-08-13 09:00:00	IWM	ETF	148.02	151.33	147.67	151.12	5714044.0
2019-08-13 10:00:00	IWM	ETF	151.11	151.79	150.45	150.58	3541589.0
2019-08-13 11:00:00	IWM	ETF	150.56	150.87	149.75	150.58	2176532.0
2019-08-13 12:00:00	IWM	ETF	150.6	150.8	150.08	150.27	829694.0
2019-08-13 13:00:00	IWM	ETF	150.27	150.54	149.96	150.5	1333382.0
2019-08-13 14:00:00	IWM	ETF	150.49	150.54	150.235	150.32	766613.0
2019-08-13 15:00:00	IWM	ETF	150.31	150.395	150.0601	150.29	3016772.0
2019-08-13 16:00:00	IWM	ETF	150.3	150.81	150.2	150.58	828586.0
2019-08-13 17:00:00	IWM	ETF	150.46	150.58	150.42	150.58	7630.0
2019-08-13 18:00:00	IWM	ETF	150.5	150.6	150.4	150.55	14680.0
2019-08-13 19:00:00	IWM	ETF	150.56	150.61	150.45	150.53	1900.0
2019-08-13 04:00:00	DIA	ETF	259.4	259.4	259.4	259.4	400.0
2019-08-13 05:00:00	DIA	ETF	259.1	259.1	258.05	258.46	3800.0

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

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