PREVIEW / etf_1hour / 2020-03-04

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-03-04.parquet
  size:    382 KB
  rows:    12,686

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-04 04:00:00	SPY	ETF	304.99	306.3	304.75	305.82	220537.0
2020-03-04 05:00:00	SPY	ETF	305.65	306.43	305.57	305.69	63506.0
2020-03-04 06:00:00	SPY	ETF	305.86	306.3	305.18	306.21	214655.0
2020-03-04 07:00:00	SPY	ETF	306.19	307.6	305.67	306.22	1201783.0
2020-03-04 08:00:00	SPY	ETF	306.9375	307.59	300.24	305.75	2425722.0
2020-03-04 09:00:00	SPY	ETF	305.75	307.27	303.33	304.23	20564814.0
2020-03-04 10:00:00	SPY	ETF	304.24	307.31	303.49	304.72	26154776.0
2020-03-04 11:00:00	SPY	ETF	304.71	306.39	304.06	304.98	20181337.0
2020-03-04 12:00:00	SPY	ETF	304.9992	307.97	304.99	307.895	12858208.0
2020-03-04 13:00:00	SPY	ETF	307.91	309.46	307.75	308.98	13229904.0
2020-03-04 14:00:00	SPY	ETF	308.98	310.0	308.18	309.37	15089275.0
2020-03-04 15:00:00	SPY	ETF	309.36	313.1	309.18	312.91	40057210.0
2020-03-04 16:00:00	SPY	ETF	312.91	313.07	300.3723	311.34	20456523.0
2020-03-04 17:00:00	SPY	ETF	311.45	312.86	311.25	311.3	985701.0
2020-03-04 18:00:00	SPY	ETF	311.2	311.51	310.16	310.91	429054.0
2020-03-04 19:00:00	SPY	ETF	310.79	311.03	309.92	310.33	278849.0
2020-03-04 04:00:00	QQQ	ETF	213.15	214.0	212.89	213.81	143057.0
2020-03-04 05:00:00	QQQ	ETF	213.54	214.18	213.48	213.64	34059.0
2020-03-04 06:00:00	QQQ	ETF	213.72	213.91	213.3	213.79	104495.0
2020-03-04 07:00:00	QQQ	ETF	213.78	214.88	213.28	214.0	591858.0
2020-03-04 08:00:00	QQQ	ETF	214.3202	214.85	209.48	213.29	1126378.0
2020-03-04 09:00:00	QQQ	ETF	213.33	214.25	211.37	212.09	9537670.0
2020-03-04 10:00:00	QQQ	ETF	212.09	214.63	211.74	212.71	11209876.0
2020-03-04 11:00:00	QQQ	ETF	212.71	213.94	212.23	212.72	5782475.0
2020-03-04 12:00:00	QQQ	ETF	212.74	215.09	212.74	215.075	4142935.0
2020-03-04 13:00:00	QQQ	ETF	215.08	216.12	215.0	215.514	5220498.0
2020-03-04 14:00:00	QQQ	ETF	215.51	216.29	214.885	215.479	5413758.0
2020-03-04 15:00:00	QQQ	ETF	215.47	218.33	215.34	218.18	12463485.0
2020-03-04 16:00:00	QQQ	ETF	218.2	218.29	209.6395	216.9	2700235.0
2020-03-04 17:00:00	QQQ	ETF	216.91	217.15	216.85	216.95	138075.0
2020-03-04 18:00:00	QQQ	ETF	216.9	217.12	216.16	216.6701	247736.0
2020-03-04 19:00:00	QQQ	ETF	216.64	216.8	216.0	216.32	159331.0
2020-03-04 04:00:00	IWM	ETF	149.74	150.27	149.74	150.27	5020.0
2020-03-04 05:00:00	IWM	ETF	150.15	150.37	150.15	150.16	2600.0
2020-03-04 06:00:00	IWM	ETF	150.0	150.4	149.99	150.38	9700.0
2020-03-04 07:00:00	IWM	ETF	150.33	150.95	150.11	150.32	97626.0
2020-03-04 08:00:00	IWM	ETF	150.56	150.93	149.32	150.2	106557.0
2020-03-04 09:00:00	IWM	ETF	150.0	150.85	148.93	149.32	3075654.0
2020-03-04 10:00:00	IWM	ETF	149.41	150.68	148.62	148.74	5191733.0
2020-03-04 11:00:00	IWM	ETF	148.73	149.415	148.52	148.97	3123805.0
2020-03-04 12:00:00	IWM	ETF	148.97	150.6	148.855	150.565	2625581.0
2020-03-04 13:00:00	IWM	ETF	150.56	151.51	150.41	151.25	3728894.0
2020-03-04 14:00:00	IWM	ETF	151.25	151.67	150.8	151.46	3505889.0
2020-03-04 15:00:00	IWM	ETF	151.45	152.45	151.27	152.23	6068314.0
2020-03-04 16:00:00	IWM	ETF	152.23	152.4529	151.43	151.66	1555878.0
2020-03-04 17:00:00	IWM	ETF	151.64	152.16	151.46	151.75	186293.0
2020-03-04 18:00:00	IWM	ETF	151.72	152.16	151.21	151.21	78294.0
2020-03-04 19:00:00	IWM	ETF	151.45	152.16	151.0	151.23	42171.0
2020-03-04 04:00:00	DIA	ETF	264.06	264.72	263.87	264.72	2500.0
2020-03-04 05:00:00	DIA	ETF	264.71	265.08	264.71	264.81	6303.0

> showing 50 of 12,686 rows — these rows as CSV

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