PREVIEW / etf_1hour / 2020-03-26

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-03-26.parquet
  size:    398 KB
  rows:    13,549

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
2020-03-26 04:00:00	SPY	ETF	242.23	243.85	241.12	242.77	281706.0
2020-03-26 05:00:00	SPY	ETF	242.85	243.75	241.96	243.37	287439.0
2020-03-26 06:00:00	SPY	ETF	243.37	245.35	242.9	244.36	407821.0
2020-03-26 07:00:00	SPY	ETF	244.45	244.75	242.11	242.3	1484081.0
2020-03-26 08:00:00	SPY	ETF	242.41	246.9	240.33	246.1	5150231.0
2020-03-26 09:00:00	SPY	ETF	246.1	254.14	245.16	253.71	28215976.0
2020-03-26 10:00:00	SPY	ETF	253.71	257.5	252.82	255.56	42275194.0
2020-03-26 11:00:00	SPY	ETF	255.58	259.03	254.36	258.4	30282105.0
2020-03-26 12:00:00	SPY	ETF	258.48	259.18	256.62	258.72	21035503.0
2020-03-26 13:00:00	SPY	ETF	258.72	259.36	254.82	256.75	24952366.0
2020-03-26 14:00:00	SPY	ETF	256.73	259.09	255.46	258.5601	21170267.0
2020-03-26 15:00:00	SPY	ETF	258.57	262.8	256.54	261.39	56901188.0
2020-03-26 16:00:00	SPY	ETF	261.4	262.15	260.29	262.15	19743684.0
2020-03-26 17:00:00	SPY	ETF	262.17	262.79	261.2	262.77	636004.0
2020-03-26 18:00:00	SPY	ETF	262.76	263.0	260.69	260.7	899560.0
2020-03-26 19:00:00	SPY	ETF	260.75	263.7	260.34	263.35	623301.0
2020-03-26 04:00:00	QQQ	ETF	179.51	180.61	178.98	179.74	103898.0
2020-03-26 05:00:00	QQQ	ETF	179.94	180.39	179.1	180.06	217956.0
2020-03-26 06:00:00	QQQ	ETF	180.02	181.45	179.79	180.9	142796.0
2020-03-26 07:00:00	QQQ	ETF	180.96	181.51	179.58	179.74	339909.0
2020-03-26 08:00:00	QQQ	ETF	179.69	182.5	178.6	182.23	1047436.0
2020-03-26 09:00:00	QQQ	ETF	182.27	186.77	181.7	186.29	8287841.0
2020-03-26 10:00:00	QQQ	ETF	186.28	188.46	185.8079	187.36	10181923.0
2020-03-26 11:00:00	QQQ	ETF	187.36	189.21	186.57	188.85	8251705.0
2020-03-26 12:00:00	QQQ	ETF	188.92	189.61	187.7701	189.38	5791445.0
2020-03-26 13:00:00	QQQ	ETF	189.35	189.75	186.68	188.09	6994858.0
2020-03-26 14:00:00	QQQ	ETF	188.08	189.84	187.6425	189.5	5819345.0
2020-03-26 15:00:00	QQQ	ETF	189.48	192.72	188.2	192.16	15032420.0
2020-03-26 16:00:00	QQQ	ETF	192.13	192.28	190.9586	191.95	1644875.0
2020-03-26 17:00:00	QQQ	ETF	191.97	192.41	191.5	192.32	613889.0
2020-03-26 18:00:00	QQQ	ETF	192.49	192.54	190.87	190.9	212364.0
2020-03-26 19:00:00	QQQ	ETF	190.91	192.64	190.65	192.29	166089.0
2020-03-26 04:00:00	IWM	ETF	107.22	107.9	106.99	107.02	7279.0
2020-03-26 05:00:00	IWM	ETF	107.75	107.78	106.81	107.49	12434.0
2020-03-26 06:00:00	IWM	ETF	107.49	108.3	107.33	108.18	8078.0
2020-03-26 07:00:00	IWM	ETF	107.97	108.65	107.65	107.67	122627.0
2020-03-26 08:00:00	IWM	ETF	108.12	109.9	106.82	109.59	561734.0
2020-03-26 09:00:00	IWM	ETF	109.59	114.4799	109.3	114.2	4349404.0
2020-03-26 10:00:00	IWM	ETF	114.25	116.375	113.75	115.67	7380539.0
2020-03-26 11:00:00	IWM	ETF	115.66	117.6	114.87	116.8	6616707.0
2020-03-26 12:00:00	IWM	ETF	116.83	117.21	115.225	116.5	3420970.0
2020-03-26 13:00:00	IWM	ETF	116.51	117.06	114.23	114.94	4677044.0
2020-03-26 14:00:00	IWM	ETF	114.9	116.17	113.88	115.85	3812250.0
2020-03-26 15:00:00	IWM	ETF	115.84	117.43	114.775	116.87	10989765.0
2020-03-26 16:00:00	IWM	ETF	116.88	117.14	116.03	116.73	2129261.0
2020-03-26 17:00:00	IWM	ETF	116.81	116.99	116.17	116.99	530547.0
2020-03-26 18:00:00	IWM	ETF	116.99	117.15	115.93	115.93	106104.0
2020-03-26 19:00:00	IWM	ETF	115.91	116.69	115.9	116.62	48668.0
2020-03-26 04:00:00	DIA	ETF	207.44	209.25	207.0	208.92	41307.0
2020-03-26 05:00:00	DIA	ETF	209.39	209.68	208.2	209.68	3000.0

> showing 50 of 13,549 rows — these rows as CSV

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