PREVIEW / etf_30min / 2020-07-31

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-07-31.parquet
  size:    557 KB
  rows:    20,730

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-31 04:00:00	SPY	ETF	325.69	325.97	325.45	325.77	25464.0
2020-07-31 04:30:00	SPY	ETF	325.72	326.42	325.72	325.95	10240.0
2020-07-31 05:00:00	SPY	ETF	325.7	326.06	325.62	325.87	8604.0
2020-07-31 05:30:00	SPY	ETF	325.77	325.82	325.35	325.35	8523.0
2020-07-31 06:00:00	SPY	ETF	325.51	325.62	325.13	325.45	52634.0
2020-07-31 06:30:00	SPY	ETF	325.56	325.67	325.36	325.67	11334.0
2020-07-31 07:00:00	SPY	ETF	325.38	326.04	325.25	325.81	83386.0
2020-07-31 07:30:00	SPY	ETF	325.81	326.0	325.7	325.99	71537.0
2020-07-31 08:00:00	SPY	ETF	325.7201	326.1	325.0	325.91	360084.0
2020-07-31 08:30:00	SPY	ETF	325.82	326.95	325.56	325.56	359698.0
2020-07-31 09:00:00	SPY	ETF	325.55	326.06	325.48	325.91	235107.0
2020-07-31 09:30:00	SPY	ETF	325.9	326.13	324.12	324.74	6816130.0
2020-07-31 10:00:00	SPY	ETF	324.78	324.79	322.42	322.74	5635868.0
2020-07-31 10:30:00	SPY	ETF	322.7399	323.39	322.4114	323.3	3839864.0
2020-07-31 11:00:00	SPY	ETF	323.32	324.4	323.105	324.1	4909485.0
2020-07-31 11:30:00	SPY	ETF	324.12	324.44	323.0	323.242	3407246.0
2020-07-31 12:00:00	SPY	ETF	323.22	323.35	322.22	322.88	4188347.0
2020-07-31 12:30:00	SPY	ETF	322.89	322.89	321.33	321.71	3536829.0
2020-07-31 13:00:00	SPY	ETF	321.68	322.77	321.55	322.73	2573786.0
2020-07-31 13:30:00	SPY	ETF	322.72	323.02	322.29	322.58	2454707.0
2020-07-31 14:00:00	SPY	ETF	322.58	322.98	321.96	322.5899	2820496.0
2020-07-31 14:30:00	SPY	ETF	322.59	323.94	322.51	323.88	3540861.0
2020-07-31 15:00:00	SPY	ETF	323.88	324.85	323.68	324.63	5216452.0
2020-07-31 15:30:00	SPY	ETF	324.63	326.61	324.57	326.55	15772940.0
2020-07-31 16:00:00	SPY	ETF	326.56	326.75	323.9622	326.22	15288465.0
2020-07-31 16:30:00	SPY	ETF	326.26	327.06	326.25	326.95	649964.0
2020-07-31 17:00:00	SPY	ETF	326.91	327.05	326.52	326.71	549160.0
2020-07-31 17:30:00	SPY	ETF	326.8	326.8	326.5	326.75	77053.0
2020-07-31 18:00:00	SPY	ETF	326.74	326.86	326.52	326.75	495356.0
2020-07-31 18:30:00	SPY	ETF	326.75	326.78	326.3	326.42	145311.0
2020-07-31 19:00:00	SPY	ETF	326.42	326.49	326.3	326.3	21163.0
2020-07-31 19:30:00	SPY	ETF	326.32	326.59	326.32	326.44	33178.0
2020-07-31 04:00:00	QQQ	ETF	265.48	265.96	265.46	265.9	10199.0
2020-07-31 04:30:00	QQQ	ETF	265.87	266.33	265.71	266.03	14039.0
2020-07-31 05:00:00	QQQ	ETF	265.9	266.29	265.86	265.97	25612.0
2020-07-31 05:30:00	QQQ	ETF	266.0	266.1	265.42	265.42	23720.0
2020-07-31 06:00:00	QQQ	ETF	265.49	265.74	265.4	265.74	11182.0
2020-07-31 06:30:00	QQQ	ETF	265.58	265.84	265.5	265.6	16920.0
2020-07-31 07:00:00	QQQ	ETF	265.6	266.34	265.6	266.11	71683.0
2020-07-31 07:30:00	QQQ	ETF	266.07	266.33	266.0	266.3	64029.0
2020-07-31 08:00:00	QQQ	ETF	266.29	266.75	265.1	266.45	308093.0
2020-07-31 08:30:00	QQQ	ETF	266.42	266.58	266.01	266.02	202467.0
2020-07-31 09:00:00	QQQ	ETF	266.0	266.12	265.72	265.81	372605.0
2020-07-31 09:30:00	QQQ	ETF	265.81	265.95	263.01	264.08	7520701.0
2020-07-31 10:00:00	QQQ	ETF	264.08	264.13	261.39	261.98	4281736.0
2020-07-31 10:30:00	QQQ	ETF	261.97	263.06	261.92	263.03	3008030.0
2020-07-31 11:00:00	QQQ	ETF	263.01	264.21	262.785	263.785	2316565.0
2020-07-31 11:30:00	QQQ	ETF	263.79	264.119	262.84	263.15	2357898.0
2020-07-31 12:00:00	QQQ	ETF	263.14	263.31	262.02	262.62	2492892.0
2020-07-31 12:30:00	QQQ	ETF	262.628	262.628	260.85	261.2668	2592700.0

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

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