PREVIEW / etf_30min / 2020-12-28

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-12-28.parquet
  size:    604 KB
  rows:    22,918

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-12-28 04:00:00	SPY	ETF	371.16	371.24	371.07	371.08	8964.0
2020-12-28 04:30:00	SPY	ETF	371.1	371.32	371.0	371.29	8093.0
2020-12-28 05:00:00	SPY	ETF	371.32	371.35	371.17	371.21	3215.0
2020-12-28 05:30:00	SPY	ETF	371.21	371.36	371.17	371.33	7841.0
2020-12-28 06:00:00	SPY	ETF	371.4	372.11	371.4	371.51	11400.0
2020-12-28 06:30:00	SPY	ETF	371.65	371.7	371.54	371.69	12707.0
2020-12-28 07:00:00	SPY	ETF	371.52	371.57	371.28	371.43	91188.0
2020-12-28 07:30:00	SPY	ETF	371.46	371.61	371.38	371.52	67780.0
2020-12-28 08:00:00	SPY	ETF	371.51	371.65	371.13	371.6	96046.0
2020-12-28 08:30:00	SPY	ETF	371.6	371.81	371.56	371.73	168310.0
2020-12-28 09:00:00	SPY	ETF	371.68	371.89	371.62	371.77	288865.0
2020-12-28 09:30:00	SPY	ETF	371.74	371.83	371.07	371.38	3687439.0
2020-12-28 10:00:00	SPY	ETF	371.38	372.09	371.11	372.0136	3124020.0
2020-12-28 10:30:00	SPY	ETF	372.02	372.309	371.95	372.1	1939966.0
2020-12-28 11:00:00	SPY	ETF	372.11	372.13	371.78	371.92	1566048.0
2020-12-28 11:30:00	SPY	ETF	371.9299	372.06	371.76	371.845	3894236.0
2020-12-28 12:00:00	SPY	ETF	371.83	372.05	371.81	372.03	1025566.0
2020-12-28 12:30:00	SPY	ETF	372.03	372.14	371.87	372.02	1967854.0
2020-12-28 13:00:00	SPY	ETF	372.02	372.14	371.9601	372.07	1254023.0
2020-12-28 13:30:00	SPY	ETF	372.08	372.3	372.07	372.2399	1035411.0
2020-12-28 14:00:00	SPY	ETF	372.23	372.519	372.17	372.405	1241413.0
2020-12-28 14:30:00	SPY	ETF	372.4	372.59	372.36	372.46	1291633.0
2020-12-28 15:00:00	SPY	ETF	372.45	372.53	372.09	372.11	1864202.0
2020-12-28 15:30:00	SPY	ETF	372.12	372.34	371.87	372.14	7676801.0
2020-12-28 16:00:00	SPY	ETF	372.13	372.41	371.92	372.36	5037565.0
2020-12-28 16:30:00	SPY	ETF	372.35	372.41	372.29	372.29	118380.0
2020-12-28 17:00:00	SPY	ETF	372.28	372.42	372.17	372.42	20057.0
2020-12-28 17:30:00	SPY	ETF	372.42	372.45	372.29	372.35	34419.0
2020-12-28 18:00:00	SPY	ETF	372.44	372.56	372.35	372.54	40848.0
2020-12-28 18:30:00	SPY	ETF	372.54	372.87	372.44	372.87	22542.0
2020-12-28 19:00:00	SPY	ETF	372.87	373.35	372.85	373.27	73478.0
2020-12-28 19:30:00	SPY	ETF	373.25	373.3	373.06	373.14	42688.0
2020-12-28 04:00:00	QQQ	ETF	311.41	311.44	311.23	311.28	16431.0
2020-12-28 04:30:00	QQQ	ETF	311.25	311.41	311.12	311.4	7069.0
2020-12-28 05:00:00	QQQ	ETF	311.37	311.41	311.3	311.31	10517.0
2020-12-28 05:30:00	QQQ	ETF	311.31	311.5	311.29	311.49	8527.0
2020-12-28 06:00:00	QQQ	ETF	311.54	311.8	311.53	311.61	11772.0
2020-12-28 06:30:00	QQQ	ETF	311.65	311.69	311.55	311.55	20653.0
2020-12-28 07:00:00	QQQ	ETF	311.52	311.8	311.49	311.78	61273.0
2020-12-28 07:30:00	QQQ	ETF	311.8	312.0	311.78	311.97	28636.0
2020-12-28 08:00:00	QQQ	ETF	311.97	312.11	311.31	312.05	52594.0
2020-12-28 08:30:00	QQQ	ETF	312.07	312.46	312.05	312.4	86209.0
2020-12-28 09:00:00	QQQ	ETF	312.42	312.5	312.2	312.24	104768.0
2020-12-28 09:30:00	QQQ	ETF	312.23	312.34	311.39	311.765	2854908.0
2020-12-28 10:00:00	QQQ	ETF	311.768	311.92	310.36	311.001	2410097.0
2020-12-28 10:30:00	QQQ	ETF	311.05	312.14	311.01	312.06	1585157.0
2020-12-28 11:00:00	QQQ	ETF	312.07	312.45	311.925	312.33	1238984.0
2020-12-28 11:30:00	QQQ	ETF	312.33	312.41	311.9699	312.29	847575.0
2020-12-28 12:00:00	QQQ	ETF	312.29	312.68	312.0601	312.66	860586.0
2020-12-28 12:30:00	QQQ	ETF	312.66	312.75	312.5	312.73	903052.0

> showing 50 of 22,918 rows — these rows as CSV

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