PREVIEW / etf_30min / 2020-02-24

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-02-24.parquet
  size:    619 KB
  rows:    22,499

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-24 04:00:00	SPY	ETF	326.4	326.46	324.49	325.04	464480.0
2020-02-24 04:30:00	SPY	ETF	324.93	325.85	324.19	325.8	241284.0
2020-02-24 05:00:00	SPY	ETF	325.7	325.87	325.3	325.3	17857.0
2020-02-24 05:30:00	SPY	ETF	325.29	325.29	324.36	324.63	180976.0
2020-02-24 06:00:00	SPY	ETF	324.64	325.19	324.17	325.14	202005.0
2020-02-24 06:30:00	SPY	ETF	325.1	326.12	325.1	325.7	436002.0
2020-02-24 07:00:00	SPY	ETF	325.77	326.47	325.72	325.78	587633.0
2020-02-24 07:30:00	SPY	ETF	325.79	326.08	325.02	325.4	919754.0
2020-02-24 08:00:00	SPY	ETF	326.2301	329.23	324.58	325.18	905523.0
2020-02-24 08:30:00	SPY	ETF	325.23	325.37	324.35	324.52	887009.0
2020-02-24 09:00:00	SPY	ETF	324.52	324.53	322.96	323.15	2303304.0
2020-02-24 09:30:00	SPY	ETF	323.14	325.65	322.86	325.34	19652403.0
2020-02-24 10:00:00	SPY	ETF	325.34	325.85	324.28	324.331	9436370.0
2020-02-24 10:30:00	SPY	ETF	324.33	324.9	323.61	324.75	7974916.0
2020-02-24 11:00:00	SPY	ETF	324.745	324.92	323.9	324.3	6525760.0
2020-02-24 11:30:00	SPY	ETF	324.295	324.54	323.03	323.51	8084141.0
2020-02-24 12:00:00	SPY	ETF	323.5	333.5623	322.34	322.615	8195566.0
2020-02-24 12:30:00	SPY	ETF	322.61	323.44	322.17	322.37	7475137.0
2020-02-24 13:00:00	SPY	ETF	322.36	322.63	321.24	322.56	9494709.0
2020-02-24 13:30:00	SPY	ETF	322.57	323.2	322.26	322.99	7158366.0
2020-02-24 14:00:00	SPY	ETF	322.98	323.77	322.07	323.61	7715551.0
2020-02-24 14:30:00	SPY	ETF	323.61	324.88	323.34	324.7	8334111.0
2020-02-24 15:00:00	SPY	ETF	324.7	325.21	323.97	324.03	10689259.0
2020-02-24 15:30:00	SPY	ETF	324.04	333.5623	322.4	322.41	24178525.0
2020-02-24 16:00:00	SPY	ETF	322.4	333.5623	321.9	322.4	14101136.0
2020-02-24 16:30:00	SPY	ETF	322.42	322.8	322.02	322.53	755399.0
2020-02-24 17:00:00	SPY	ETF	322.6	322.75	322.51	322.74	1401755.0
2020-02-24 17:30:00	SPY	ETF	322.7	322.71	322.44	322.48	95917.0
2020-02-24 18:00:00	SPY	ETF	322.5	323.58	321.35	323.12	391078.0
2020-02-24 18:30:00	SPY	ETF	323.27	323.94	322.68	323.84	153607.0
2020-02-24 19:00:00	SPY	ETF	323.74	324.39	323.58	324.27	132492.0
2020-02-24 19:30:00	SPY	ETF	324.25	324.65	323.98	324.63	203146.0
2020-02-24 04:00:00	QQQ	ETF	227.01	227.01	222.55	223.0	204014.0
2020-02-24 04:30:00	QQQ	ETF	222.97	223.72	222.4	223.71	175617.0
2020-02-24 05:00:00	QQQ	ETF	223.7	223.83	223.27	223.53	113343.0
2020-02-24 05:30:00	QQQ	ETF	223.47	223.51	222.73	222.92	86558.0
2020-02-24 06:00:00	QQQ	ETF	222.89	223.42	222.63	223.42	171300.0
2020-02-24 06:30:00	QQQ	ETF	223.4	224.28	223.31	223.98	305877.0
2020-02-24 07:00:00	QQQ	ETF	224.01	224.87	223.95	224.3	648552.0
2020-02-24 07:30:00	QQQ	ETF	224.3	224.66	223.65	223.92	708596.0
2020-02-24 08:00:00	QQQ	ETF	223.93	226.47	223.35	224.08	676600.0
2020-02-24 08:30:00	QQQ	ETF	224.1	224.24	223.26	223.39	593623.0
2020-02-24 09:00:00	QQQ	ETF	223.39	223.42	221.7	221.81	1090959.0
2020-02-24 09:30:00	QQQ	ETF	221.84	223.935	220.26	223.7656	10983860.0
2020-02-24 10:00:00	QQQ	ETF	223.78	224.25	222.69	222.82	5042546.0
2020-02-24 10:30:00	QQQ	ETF	222.79	223.19	222.0533	223.05	4278284.0
2020-02-24 11:00:00	QQQ	ETF	223.03	223.17	222.24	222.59	2778821.0
2020-02-24 11:30:00	QQQ	ETF	222.59	222.7199	221.505	222.0	4712300.0
2020-02-24 12:00:00	QQQ	ETF	221.99	222.05	220.96	221.39	4097745.0
2020-02-24 12:30:00	QQQ	ETF	221.38	222.27	221.1	221.43	2771048.0

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

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