PREVIEW / etf_30min / 2020-02-19

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-02-19.parquet
  size:    540 KB
  rows:    19,251

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-02-19 04:00:00	SPY	ETF	337.35	337.54	337.35	337.5	15422.0
2020-02-19 04:30:00	SPY	ETF	337.52	337.52	337.34	337.38	9221.0
2020-02-19 05:00:00	SPY	ETF	337.42	337.45	337.42	337.45	890.0
2020-02-19 05:30:00	SPY	ETF	337.4	337.43	337.4	337.43	522.0
2020-02-19 06:00:00	SPY	ETF	337.45	337.45	337.3	337.4	14127.0
2020-02-19 06:30:00	SPY	ETF	337.3	337.5	337.3	337.5	8084.0
2020-02-19 07:00:00	SPY	ETF	337.46	337.65	337.45	337.49	90781.0
2020-02-19 07:30:00	SPY	ETF	337.54	337.71	337.5	337.66	84871.0
2020-02-19 08:00:00	SPY	ETF	337.47	337.76	336.73	337.52	104903.0
2020-02-19 08:30:00	SPY	ETF	337.54	337.77	337.51	337.73	211008.0
2020-02-19 09:00:00	SPY	ETF	337.7	337.88	337.68	337.79	160661.0
2020-02-19 09:30:00	SPY	ETF	337.79	338.415	337.48	338.14	5658733.0
2020-02-19 10:00:00	SPY	ETF	338.14	338.32	337.94	338.12	2599767.0
2020-02-19 10:30:00	SPY	ETF	338.13	338.51	338.11	338.43	1684603.0
2020-02-19 11:00:00	SPY	ETF	338.425	338.84	338.4	338.77	2544914.0
2020-02-19 11:30:00	SPY	ETF	338.78	338.81	338.56	338.67	1933473.0
2020-02-19 12:00:00	SPY	ETF	338.66	338.89	338.55	338.7	981567.0
2020-02-19 12:30:00	SPY	ETF	338.7	338.92	338.69	338.74	1658621.0
2020-02-19 13:00:00	SPY	ETF	338.74	338.84	338.66	338.755	1285103.0
2020-02-19 13:30:00	SPY	ETF	338.76	338.79	338.54	338.64	1866993.0
2020-02-19 14:00:00	SPY	ETF	338.64	338.869	338.48	338.78	2987349.0
2020-02-19 14:30:00	SPY	ETF	338.78	339.08	338.75	338.86	1783040.0
2020-02-19 15:00:00	SPY	ETF	338.86	339.0	338.5	338.635	3058340.0
2020-02-19 15:30:00	SPY	ETF	338.64	338.72	338.21	338.31	8035307.0
2020-02-19 16:00:00	SPY	ETF	338.3	338.62	338.27	338.36	7219900.0
2020-02-19 16:30:00	SPY	ETF	338.36	338.5	338.31	338.49	3229909.0
2020-02-19 17:00:00	SPY	ETF	338.44	338.51	338.36	338.36	213759.0
2020-02-19 17:30:00	SPY	ETF	338.36	338.77	338.36	338.67	178213.0
2020-02-19 18:00:00	SPY	ETF	338.74	338.82	338.55	338.68	62764.0
2020-02-19 18:30:00	SPY	ETF	338.7	338.86	338.67	338.82	29934.0
2020-02-19 19:00:00	SPY	ETF	338.89	339.38	338.89	339.25	92164.0
2020-02-19 19:30:00	SPY	ETF	339.21	339.34	339.12	339.22	38131.0
2020-02-19 04:00:00	QQQ	ETF	235.36	235.58	235.36	235.54	24334.0
2020-02-19 04:30:00	QQQ	ETF	235.6	235.62	235.44	235.48	7290.0
2020-02-19 05:00:00	QQQ	ETF	235.41	235.58	235.41	235.58	6645.0
2020-02-19 05:30:00	QQQ	ETF	235.57	235.57	235.5	235.56	1725.0
2020-02-19 06:00:00	QQQ	ETF	235.55	235.56	235.45	235.54	4060.0
2020-02-19 06:30:00	QQQ	ETF	235.54	235.61	235.41	235.56	18933.0
2020-02-19 07:00:00	QQQ	ETF	235.57	235.72	235.55	235.62	36217.0
2020-02-19 07:30:00	QQQ	ETF	235.63	235.93	235.61	235.91	25045.0
2020-02-19 08:00:00	QQQ	ETF	235.6	235.9396	234.73	235.77	101122.0
2020-02-19 08:30:00	QQQ	ETF	235.77	235.93	235.74	235.89	67098.0
2020-02-19 09:00:00	QQQ	ETF	235.87	236.2	235.87	236.05	111872.0
2020-02-19 09:30:00	QQQ	ETF	236.05	236.71	235.85	236.58	3362253.0
2020-02-19 10:00:00	QQQ	ETF	236.56	236.8699	236.43	236.7	1418097.0
2020-02-19 10:30:00	QQQ	ETF	236.74	236.83	236.55	236.815	825416.0
2020-02-19 11:00:00	QQQ	ETF	236.815	237.19	236.79	237.13	1354769.0
2020-02-19 11:30:00	QQQ	ETF	237.135	237.24	236.98	237.13	1039776.0
2020-02-19 12:00:00	QQQ	ETF	237.13	237.25	237.0	237.1039	622551.0
2020-02-19 12:30:00	QQQ	ETF	237.11	237.353	237.1	237.2	669670.0

> showing 50 of 19,251 rows — these rows as CSV

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