PREVIEW / etf_30min / 2020-07-29

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-07-29.parquet
  size:    542 KB
  rows:    20,157

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-07-29 04:00:00	SPY	ETF	321.93	322.2	321.78	322.2	12405.0
2020-07-29 04:30:00	SPY	ETF	322.21	322.23	321.78	321.93	2197.0
2020-07-29 05:00:00	SPY	ETF	321.9	321.93	321.56	321.93	4001.0
2020-07-29 05:30:00	SPY	ETF	321.76	322.01	321.76	321.93	3411.0
2020-07-29 06:00:00	SPY	ETF	322.01	322.13	321.86	321.99	15064.0
2020-07-29 06:30:00	SPY	ETF	322.11	322.11	321.78	321.78	2468.0
2020-07-29 07:00:00	SPY	ETF	321.8	321.99	321.68	321.83	31482.0
2020-07-29 07:30:00	SPY	ETF	321.86	322.19	321.78	322.07	55743.0
2020-07-29 08:00:00	SPY	ETF	321.8099	322.62	320.7	322.4	138971.0
2020-07-29 08:30:00	SPY	ETF	322.43	322.48	322.01	322.33	94084.0
2020-07-29 09:00:00	SPY	ETF	322.29	322.39	322.09	322.1	177333.0
2020-07-29 09:30:00	SPY	ETF	322.12	322.97	322.075	322.81	3724672.0
2020-07-29 10:00:00	SPY	ETF	322.81	323.36	322.76	323.22	2651776.0
2020-07-29 10:30:00	SPY	ETF	323.23	323.77	323.17	323.75	2014964.0
2020-07-29 11:00:00	SPY	ETF	323.74	323.86	323.34	323.85	2363815.0
2020-07-29 11:30:00	SPY	ETF	323.85	323.86	323.64	323.67	1785200.0
2020-07-29 12:00:00	SPY	ETF	323.67	323.82	323.23	323.735	3435717.0
2020-07-29 12:30:00	SPY	ETF	323.74	324.12	323.66	323.96	2392936.0
2020-07-29 13:00:00	SPY	ETF	323.96	324.3	323.78	324.1801	1521539.0
2020-07-29 13:30:00	SPY	ETF	324.19	324.23	323.88	324.03	1284889.0
2020-07-29 14:00:00	SPY	ETF	324.02	324.48	323.62	324.36	3311733.0
2020-07-29 14:30:00	SPY	ETF	324.36	325.44	324.36	324.54	3961094.0
2020-07-29 15:00:00	SPY	ETF	324.54	325.45	323.872	325.2	4856536.0
2020-07-29 15:30:00	SPY	ETF	325.2	325.73	324.65	325.09	10435088.0
2020-07-29 16:00:00	SPY	ETF	325.08	325.41	324.645	325.4	2654241.0
2020-07-29 16:30:00	SPY	ETF	325.4	325.71	325.27	325.65	464390.0
2020-07-29 17:00:00	SPY	ETF	325.59	325.7	325.55	325.58	86309.0
2020-07-29 17:30:00	SPY	ETF	325.58	325.66	325.55	325.66	32197.0
2020-07-29 18:00:00	SPY	ETF	325.65	325.69	325.4	325.48	66396.0
2020-07-29 18:30:00	SPY	ETF	325.48	325.56	325.3	325.3	26815.0
2020-07-29 19:00:00	SPY	ETF	325.41	325.44	325.1	325.22	24608.0
2020-07-29 19:30:00	SPY	ETF	325.23	325.3	325.12	325.14	24057.0
2020-07-29 04:00:00	QQQ	ETF	258.34	258.4	257.95	258.4	11389.0
2020-07-29 04:30:00	QQQ	ETF	258.44	258.44	258.04	258.19	7508.0
2020-07-29 05:00:00	QQQ	ETF	258.21	258.22	257.75	258.22	8125.0
2020-07-29 05:30:00	QQQ	ETF	258.15	258.27	258.12	258.27	9367.0
2020-07-29 06:00:00	QQQ	ETF	258.34	258.52	258.28	258.35	9245.0
2020-07-29 06:30:00	QQQ	ETF	258.39	258.6	258.22	258.22	15962.0
2020-07-29 07:00:00	QQQ	ETF	258.22	258.43	258.14	258.24	49632.0
2020-07-29 07:30:00	QQQ	ETF	258.25	258.58	258.17	258.48	23884.0
2020-07-29 08:00:00	QQQ	ETF	258.53	259.0	256.55	258.79	103623.0
2020-07-29 08:30:00	QQQ	ETF	258.81	258.94	258.2	258.61	140819.0
2020-07-29 09:00:00	QQQ	ETF	258.54	258.77	258.34	258.34	312457.0
2020-07-29 09:30:00	QQQ	ETF	258.33	258.89	257.91	258.58	2795741.0
2020-07-29 10:00:00	QQQ	ETF	258.6102	259.39	258.56	259.09	1586715.0
2020-07-29 10:30:00	QQQ	ETF	259.11	259.695	259.0	259.53	1019411.0
2020-07-29 11:00:00	QQQ	ETF	259.53	259.608	259.05	259.57	701113.0
2020-07-29 11:30:00	QQQ	ETF	259.5884	259.59	259.18	259.19	677156.0
2020-07-29 12:00:00	QQQ	ETF	259.1704	259.1738	258.21	258.9218	1811539.0
2020-07-29 12:30:00	QQQ	ETF	258.9485	259.42	258.83	259.2	1033017.0

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

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