PREVIEW / etf_1hour / 2019-10-15

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-10-15.parquet
  size:    333 KB
  rows:    10,940

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-10-15 04:00:00	SPY	ETF	297.32	297.62	297.05	297.05	19093.0
2019-10-15 05:00:00	SPY	ETF	297.03	297.29	297.03	297.29	4126.0
2019-10-15 06:00:00	SPY	ETF	297.28	297.38	296.56	296.9	47745.0
2019-10-15 07:00:00	SPY	ETF	296.85	297.24	296.68	296.86	132287.0
2019-10-15 08:00:00	SPY	ETF	296.86	297.6	296.65	296.83	165529.0
2019-10-15 09:00:00	SPY	ETF	296.82	297.5763	296.79	297.41	4251483.0
2019-10-15 10:00:00	SPY	ETF	297.42	299.445	297.41	299.44	9732006.0
2019-10-15 11:00:00	SPY	ETF	299.45	299.6	298.87	299.22	6915958.0
2019-10-15 12:00:00	SPY	ETF	299.24	299.39	299.01	299.37	3638488.0
2019-10-15 13:00:00	SPY	ETF	299.38	299.62	299.1	299.48	3671833.0
2019-10-15 14:00:00	SPY	ETF	299.475	299.7	299.16	299.29	3282552.0
2019-10-15 15:00:00	SPY	ETF	299.29	299.43	298.87	298.9	9836925.0
2019-10-15 16:00:00	SPY	ETF	298.91	299.21	298.82	299.1	4245115.0
2019-10-15 17:00:00	SPY	ETF	299.1	299.19	298.88	299.12	393180.0
2019-10-15 18:00:00	SPY	ETF	299.11	299.13	298.85	298.95	75418.0
2019-10-15 19:00:00	SPY	ETF	298.91	298.93	298.75	298.88	45986.0
2019-10-15 04:00:00	QQQ	ETF	192.13	192.4	191.91	191.95	13857.0
2019-10-15 05:00:00	QQQ	ETF	191.95	192.15	191.95	192.13	6036.0
2019-10-15 06:00:00	QQQ	ETF	192.18	192.2	191.64	191.77	56825.0
2019-10-15 07:00:00	QQQ	ETF	191.72	191.86	191.49	191.66	107190.0
2019-10-15 08:00:00	QQQ	ETF	191.67	192.36	191.55	191.65	82034.0
2019-10-15 09:00:00	QQQ	ETF	191.64	192.3	191.56	192.11	2922013.0
2019-10-15 10:00:00	QQQ	ETF	192.12	193.54	192.11	193.54	4282955.0
2019-10-15 11:00:00	QQQ	ETF	193.54	193.63	193.02	193.4	3016931.0
2019-10-15 12:00:00	QQQ	ETF	193.41	193.55	193.23	193.47	1211953.0
2019-10-15 13:00:00	QQQ	ETF	193.48	193.88	193.465	193.81	1425419.0
2019-10-15 14:00:00	QQQ	ETF	193.825	193.97	193.65	193.74	1656809.0
2019-10-15 15:00:00	QQQ	ETF	193.74	193.79	193.43	193.52	4153529.0
2019-10-15 16:00:00	QQQ	ETF	193.52	193.75	193.4063	193.68	656983.0
2019-10-15 17:00:00	QQQ	ETF	193.69	193.74	193.52	193.68	112500.0
2019-10-15 18:00:00	QQQ	ETF	193.68	193.68	193.53	193.53	20650.0
2019-10-15 19:00:00	QQQ	ETF	193.52	193.54	193.4	193.49	30315.0
2019-10-15 04:00:00	IWM	ETF	150.43	150.48	150.15	150.15	7100.0
2019-10-15 05:00:00	IWM	ETF	150.17	150.17	150.17	150.17	400.0
2019-10-15 06:00:00	IWM	ETF	150.2	150.2	149.86	150.06	8938.0
2019-10-15 07:00:00	IWM	ETF	150.09	150.24	149.91	149.98	46835.0
2019-10-15 08:00:00	IWM	ETF	150.07	150.38	149.9	150.05	11619.0
2019-10-15 09:00:00	IWM	ETF	150.04	150.46	149.79	150.38	2282844.0
2019-10-15 10:00:00	IWM	ETF	150.37	151.74	150.37	151.64	2496285.0
2019-10-15 11:00:00	IWM	ETF	151.65	151.78	151.39	151.72	1669923.0
2019-10-15 12:00:00	IWM	ETF	151.71	152.13	151.64	152.02	1335770.0
2019-10-15 13:00:00	IWM	ETF	152.02	152.06	151.74	151.865	920726.0
2019-10-15 14:00:00	IWM	ETF	151.86	151.88	151.31	151.4	1042547.0
2019-10-15 15:00:00	IWM	ETF	151.39	151.55	151.24	151.43	3212870.0
2019-10-15 16:00:00	IWM	ETF	151.44	151.65	151.31	151.51	1565820.0
2019-10-15 17:00:00	IWM	ETF	151.65	151.65	151.39	151.39	158215.0
2019-10-15 18:00:00	IWM	ETF	151.5	151.53	151.5	151.51	8500.0
2019-10-15 19:00:00	IWM	ETF	151.44	151.44	151.35	151.35	5500.0
2019-10-15 05:00:00	DIA	ETF	268.8	268.8	268.8	268.8	300.0
2019-10-15 07:00:00	DIA	ETF	269.05	269.05	268.66	268.66	2406.0

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

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