PREVIEW / etf_1hour / 2019-03-26

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-03-26.parquet
  size:    320 KB
  rows:    10,608

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-26 04:00:00	SPY	ETF	279.98	280.18	279.66	279.66	15280.0
2019-03-26 05:00:00	SPY	ETF	279.69	280.44	279.68	280.37	52943.0
2019-03-26 06:00:00	SPY	ETF	280.39	280.8	280.39	280.74	45831.0
2019-03-26 07:00:00	SPY	ETF	280.73	280.88	280.62	280.77	135038.0
2019-03-26 08:00:00	SPY	ETF	280.74	281.04	279.04	280.53	637315.0
2019-03-26 09:00:00	SPY	ETF	280.54	281.98	280.54	281.97	9387264.0
2019-03-26 10:00:00	SPY	ETF	281.98	282.18	281.22	282.09	8841613.0
2019-03-26 11:00:00	SPY	ETF	282.09	282.18	280.8	281.0752	9197939.0
2019-03-26 12:00:00	SPY	ETF	281.09	281.34	280.22	280.62	6426200.0
2019-03-26 13:00:00	SPY	ETF	280.61	280.93	279.92	279.98	4821341.0
2019-03-26 14:00:00	SPY	ETF	279.975	280.33	279.56	280.3	6908534.0
2019-03-26 15:00:00	SPY	ETF	280.3	281.09	279.86	281.03	13205685.0
2019-03-26 16:00:00	SPY	ETF	281.02	281.14	280.78	281.06	7009946.0
2019-03-26 17:00:00	SPY	ETF	281.07	281.14	281.02	281.05	114161.0
2019-03-26 18:00:00	SPY	ETF	281.05	281.05	280.72	280.75	108018.0
2019-03-26 19:00:00	SPY	ETF	280.74	281.0	280.62	280.98	68486.0
2019-03-26 04:00:00	QQQ	ETF	178.85	178.85	178.55	178.55	5000.0
2019-03-26 05:00:00	QQQ	ETF	178.64	179.08	178.64	179.06	20000.0
2019-03-26 06:00:00	QQQ	ETF	179.08	179.29	179.02	179.26	59763.0
2019-03-26 07:00:00	QQQ	ETF	179.26	179.43	179.22	179.35	208887.0
2019-03-26 08:00:00	QQQ	ETF	179.3699	179.62	178.22	179.27	381800.0
2019-03-26 09:00:00	QQQ	ETF	179.2993	180.55	179.29	180.55	4720423.0
2019-03-26 10:00:00	QQQ	ETF	180.55	180.69	179.59	180.2452	5747916.0
2019-03-26 11:00:00	QQQ	ETF	180.25	180.34	179.27	179.51	3339136.0
2019-03-26 12:00:00	QQQ	ETF	179.54	179.8	178.99	179.35	3320340.0
2019-03-26 13:00:00	QQQ	ETF	179.34	179.61	178.65	178.69	2412676.0
2019-03-26 14:00:00	QQQ	ETF	178.6809	178.83	178.26	178.62	3220067.0
2019-03-26 15:00:00	QQQ	ETF	178.62	179.07	178.14	179.05	4503028.0
2019-03-26 16:00:00	QQQ	ETF	179.05	179.25	178.93	179.15	704666.0
2019-03-26 17:00:00	QQQ	ETF	179.15	179.21	179.08	179.14	9712.0
2019-03-26 18:00:00	QQQ	ETF	179.08	179.08	178.92	178.97	36714.0
2019-03-26 19:00:00	QQQ	ETF	178.91	179.07	178.8	179.05	39215.0
2019-03-26 05:00:00	IWM	ETF	150.98	151.0	150.98	151.0	500.0
2019-03-26 06:00:00	IWM	ETF	151.13	151.33	151.13	151.33	2702.0
2019-03-26 07:00:00	IWM	ETF	151.3	151.35	151.27	151.32	35415.0
2019-03-26 08:00:00	IWM	ETF	151.32	151.46	151.09	151.18	48257.0
2019-03-26 09:00:00	IWM	ETF	151.2	152.14	151.2	152.06	3200239.0
2019-03-26 10:00:00	IWM	ETF	152.09	152.82	151.51	152.62	3825731.0
2019-03-26 11:00:00	IWM	ETF	152.62	152.66	151.44	151.705	2338510.0
2019-03-26 12:00:00	IWM	ETF	151.71	151.9	150.98	151.12	1870899.0
2019-03-26 13:00:00	IWM	ETF	151.11	151.56	150.85	150.89	1658824.0
2019-03-26 14:00:00	IWM	ETF	150.89	151.61	150.79	151.61	1596511.0
2019-03-26 15:00:00	IWM	ETF	151.6	151.91	151.19	151.85	3507374.0
2019-03-26 16:00:00	IWM	ETF	151.86	151.93	151.5	151.82	1297918.0
2019-03-26 17:00:00	IWM	ETF	151.8	151.8	151.8	151.8	189.0
2019-03-26 18:00:00	IWM	ETF	151.76	151.76	151.66	151.75	17011.0
2019-03-26 19:00:00	IWM	ETF	151.63	151.77	151.6	151.77	1800.0
2019-03-26 06:00:00	DIA	ETF	256.6	256.6	256.5	256.54	1950.0
2019-03-26 07:00:00	DIA	ETF	256.72	256.89	256.72	256.89	3381.0
2019-03-26 08:00:00	DIA	ETF	256.74	256.93	256.29	256.6	6941.0

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

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