PREVIEW / etf_1hour / 2020-03-06

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-03-06.parquet
  size:    400 KB
  rows:    13,261

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-06 04:00:00	SPY	ETF	298.71	299.6	295.9	295.91	174542.0
2020-03-06 05:00:00	SPY	ETF	295.87	295.97	293.0	294.35	274518.0
2020-03-06 06:00:00	SPY	ETF	294.22	295.41	293.27	294.54	535744.0
2020-03-06 07:00:00	SPY	ETF	294.5	295.38	291.9	293.27	1384717.0
2020-03-06 08:00:00	SPY	ETF	298.87	302.8	291.9798	293.4	2912092.0
2020-03-06 09:00:00	SPY	ETF	293.3	294.74	291.0	293.35	24689548.0
2020-03-06 10:00:00	SPY	ETF	293.34	297.97	292.61	297.08	32066501.0
2020-03-06 11:00:00	SPY	ETF	297.09	297.47	294.12	294.9401	19398297.0
2020-03-06 12:00:00	SPY	ETF	294.92	296.08	292.99	294.55	17525487.0
2020-03-06 13:00:00	SPY	ETF	294.53	296.72	293.37	293.63	15901317.0
2020-03-06 14:00:00	SPY	ETF	293.65	293.97	290.57	291.01	25956032.0
2020-03-06 15:00:00	SPY	ETF	291.0	298.78	290.23	297.42	64685858.0
2020-03-06 16:00:00	SPY	ETF	297.49	297.49	296.0	296.67	19692016.0
2020-03-06 17:00:00	SPY	ETF	296.6	297.46	295.49	295.5	856648.0
2020-03-06 18:00:00	SPY	ETF	295.6	296.15	295.11	295.4	238289.0
2020-03-06 19:00:00	SPY	ETF	295.35	296.0	295.23	295.5	97298.0
2020-03-06 04:00:00	QQQ	ETF	208.83	209.42	206.68	206.68	105932.0
2020-03-06 05:00:00	QQQ	ETF	206.67	206.76	204.48	205.29	264753.0
2020-03-06 06:00:00	QQQ	ETF	205.27	205.69	204.5	205.1	175051.0
2020-03-06 07:00:00	QQQ	ETF	205.06	205.86	203.5	204.35	739887.0
2020-03-06 08:00:00	QQQ	ETF	205.4701	209.61	203.55	204.84	1160463.0
2020-03-06 09:00:00	QQQ	ETF	204.59	206.5	202.88	205.4299	10653807.0
2020-03-06 10:00:00	QQQ	ETF	205.43	208.51	204.85	207.65	12887333.0
2020-03-06 11:00:00	QQQ	ETF	207.66	207.91	205.47	205.86	8790411.0
2020-03-06 12:00:00	QQQ	ETF	205.86	206.71	204.62	205.49	6230011.0
2020-03-06 13:00:00	QQQ	ETF	205.47	207.0373	204.76	204.88	5061719.0
2020-03-06 14:00:00	QQQ	ETF	204.9	205.2	203.145	203.49	7502212.0
2020-03-06 15:00:00	QQQ	ETF	203.42	209.15	202.91	208.09	18618647.0
2020-03-06 16:00:00	QQQ	ETF	208.14	208.23	206.98	208.02	2356833.0
2020-03-06 17:00:00	QQQ	ETF	207.3	208.02	206.74	206.75	1334638.0
2020-03-06 18:00:00	QQQ	ETF	206.75	206.94	206.2	206.56	20865.0
2020-03-06 19:00:00	QQQ	ETF	206.65	206.7	206.35	206.47	32486.0
2020-03-06 04:00:00	IWM	ETF	145.88	146.13	144.49	144.49	18279.0
2020-03-06 05:00:00	IWM	ETF	144.42	144.42	143.43	144.14	12451.0
2020-03-06 06:00:00	IWM	ETF	143.97	144.41	143.49	144.04	38882.0
2020-03-06 07:00:00	IWM	ETF	144.0	144.38	142.76	143.18	85018.0
2020-03-06 08:00:00	IWM	ETF	143.62	144.15	142.34	142.89	155543.0
2020-03-06 09:00:00	IWM	ETF	142.71	144.35	141.87	143.8	3974912.0
2020-03-06 10:00:00	IWM	ETF	143.8	145.98	143.37	145.84	4858386.0
2020-03-06 11:00:00	IWM	ETF	145.85	145.95	143.4	144.14	3895362.0
2020-03-06 12:00:00	IWM	ETF	144.14	144.46	143.13	143.39	2852082.0
2020-03-06 13:00:00	IWM	ETF	143.37	144.04	142.47	142.55	2730591.0
2020-03-06 14:00:00	IWM	ETF	142.57	142.58	141.0305	141.07	4962546.0
2020-03-06 15:00:00	IWM	ETF	141.07	144.76	140.99	144.4	9559266.0
2020-03-06 16:00:00	IWM	ETF	144.42	144.46	143.65	143.76	1113451.0
2020-03-06 17:00:00	IWM	ETF	143.77	144.4	143.66	143.66	226333.0
2020-03-06 18:00:00	IWM	ETF	143.2	143.6	143.2	143.5	2503.0
2020-03-06 19:00:00	IWM	ETF	143.6	143.76	143.1	143.1	1954.0
2020-03-06 04:00:00	DIA	ETF	260.19	260.19	256.25	256.35	6518.0
2020-03-06 05:00:00	DIA	ETF	256.21	256.21	254.14	254.76	7397.0

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

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