PREVIEW / etf_30min / 2020-06-19

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-06-19.parquet
  size:    548 KB
  rows:    20,484

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-06-19 04:00:00	SPY	ETF	312.12	312.12	311.27	311.57	24893.0
2020-06-19 04:30:00	SPY	ETF	311.69	312.0	311.33	311.92	22197.0
2020-06-19 05:00:00	SPY	ETF	312.05	312.64	311.8	312.3	27133.0
2020-06-19 05:30:00	SPY	ETF	312.44	313.09	312.39	312.64	36461.0
2020-06-19 06:00:00	SPY	ETF	312.59	313.18	312.36	312.39	34535.0
2020-06-19 06:30:00	SPY	ETF	312.29	312.48	312.08	312.48	45138.0
2020-06-19 07:00:00	SPY	ETF	312.47	312.7	312.2	312.59	83316.0
2020-06-19 07:30:00	SPY	ETF	312.55	313.13	312.52	313.11	130269.0
2020-06-19 08:00:00	SPY	ETF	313.09	313.77	311.5	313.2	536581.0
2020-06-19 08:30:00	SPY	ETF	313.19	313.78	313.19	313.64	247687.0
2020-06-19 09:00:00	SPY	ETF	313.6	314.49	313.31	314.17	1071791.0
2020-06-19 09:30:00	SPY	ETF	314.17	314.38	312.71	312.96	11429803.0
2020-06-19 10:00:00	SPY	ETF	312.96	313.3796	312.71	313.04	4287029.0
2020-06-19 10:30:00	SPY	ETF	313.045	313.0899	312.08	312.275	4730296.0
2020-06-19 11:00:00	SPY	ETF	312.27	312.9581	311.6	312.25	14170696.0
2020-06-19 11:30:00	SPY	ETF	312.24	312.33	311.56	311.69	4662240.0
2020-06-19 12:00:00	SPY	ETF	311.685	311.76	307.95	309.215	14013477.0
2020-06-19 12:30:00	SPY	ETF	309.205	310.54	308.54	310.4245	8312123.0
2020-06-19 13:00:00	SPY	ETF	310.43	310.47	308.655	308.91	4570707.0
2020-06-19 13:30:00	SPY	ETF	308.89	309.43	307.89	307.9	5993325.0
2020-06-19 14:00:00	SPY	ETF	307.91	308.7	306.53	307.6	8872149.0
2020-06-19 14:30:00	SPY	ETF	307.6101	309.63	307.21	309.42	6607836.0
2020-06-19 15:00:00	SPY	ETF	309.43	310.54	308.7	309.91	7471731.0
2020-06-19 15:30:00	SPY	ETF	309.905	310.3	308.54	308.56	16018906.0
2020-06-19 16:00:00	SPY	ETF	308.56	309.3941	305.9	306.67	10540387.0
2020-06-19 16:30:00	SPY	ETF	306.68	308.718	305.85	305.95	4557388.0
2020-06-19 17:00:00	SPY	ETF	306.0	308.64	305.94	306.5	3762475.0
2020-06-19 17:30:00	SPY	ETF	306.45	308.64	306.36	306.76	1089124.0
2020-06-19 18:00:00	SPY	ETF	306.76	306.84	306.49	306.75	90157.0
2020-06-19 18:30:00	SPY	ETF	306.8	306.85	306.7	306.7	80327.0
2020-06-19 19:00:00	SPY	ETF	306.7	306.75	306.39	306.47	80574.0
2020-06-19 19:30:00	SPY	ETF	306.45	306.5	306.05	306.1	85606.0
2020-06-19 04:00:00	QQQ	ETF	245.92	245.98	245.38	245.55	32711.0
2020-06-19 04:30:00	QQQ	ETF	245.63	245.74	245.56	245.73	5765.0
2020-06-19 05:00:00	QQQ	ETF	245.81	246.01	245.63	245.77	21652.0
2020-06-19 05:30:00	QQQ	ETF	245.84	246.1	245.73	245.82	27834.0
2020-06-19 06:00:00	QQQ	ETF	245.78	246.15	245.75	245.8	13827.0
2020-06-19 06:30:00	QQQ	ETF	245.85	245.93	245.68	245.93	20551.0
2020-06-19 07:00:00	QQQ	ETF	245.95	245.98	245.77	245.92	53747.0
2020-06-19 07:30:00	QQQ	ETF	245.92	246.22	245.92	246.22	45461.0
2020-06-19 08:00:00	QQQ	ETF	245.99	246.52	244.41	246.28	230087.0
2020-06-19 08:30:00	QQQ	ETF	246.29	246.68	246.27	246.56	230543.0
2020-06-19 09:00:00	QQQ	ETF	246.55	247.1	246.22	246.78	1327018.0
2020-06-19 09:30:00	QQQ	ETF	246.74	247.0	246.18	246.45	3532491.0
2020-06-19 10:00:00	QQQ	ETF	246.47	246.97	246.26	246.77	1857296.0
2020-06-19 10:30:00	QQQ	ETF	246.78	246.8298	245.95	246.22	1672378.0
2020-06-19 11:00:00	QQQ	ETF	246.23	246.68	245.69	246.17	1735530.0
2020-06-19 11:30:00	QQQ	ETF	246.16	246.22	245.57	245.62	1173449.0
2020-06-19 12:00:00	QQQ	ETF	245.62	245.685	242.81	243.795	3523866.0
2020-06-19 12:30:00	QQQ	ETF	243.77	244.94	243.44	244.84	2087670.0

> showing 50 of 20,484 rows — these rows as CSV

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