PREVIEW / etf_30min / 2020-07-09

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-07-09.parquet
  size:    553 KB
  rows:    20,648

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-09 04:00:00	SPY	ETF	316.18	316.54	316.0	316.24	17634.0
2020-07-09 04:30:00	SPY	ETF	316.27	316.38	316.08	316.16	29395.0
2020-07-09 05:00:00	SPY	ETF	316.09	316.24	315.68	315.75	20426.0
2020-07-09 05:30:00	SPY	ETF	315.77	316.42	315.77	316.27	15757.0
2020-07-09 06:00:00	SPY	ETF	316.18	316.44	316.16	316.39	21680.0
2020-07-09 06:30:00	SPY	ETF	316.25	316.25	315.84	315.99	14646.0
2020-07-09 07:00:00	SPY	ETF	316.04	316.78	315.96	316.67	86009.0
2020-07-09 07:30:00	SPY	ETF	316.63	316.73	316.51	316.59	45879.0
2020-07-09 08:00:00	SPY	ETF	316.0541	316.92	316.0	316.87	236288.0
2020-07-09 08:30:00	SPY	ETF	316.83	317.2	316.78	317.0	326600.0
2020-07-09 09:00:00	SPY	ETF	316.93	317.0	316.78	316.84	191410.0
2020-07-09 09:30:00	SPY	ETF	316.84	317.1	315.35	316.1	5938382.0
2020-07-09 10:00:00	SPY	ETF	316.1	316.4	314.58	315.16	6240957.0
2020-07-09 10:30:00	SPY	ETF	315.17	315.41	311.82	311.9413	7510134.0
2020-07-09 11:00:00	SPY	ETF	311.95	312.59	310.68	311.745	10062038.0
2020-07-09 11:30:00	SPY	ETF	311.74	312.34	310.99	312.24	6076891.0
2020-07-09 12:00:00	SPY	ETF	312.24	313.43	312.07	313.0	6541008.0
2020-07-09 12:30:00	SPY	ETF	313.0	313.62	312.75	313.51	4292793.0
2020-07-09 13:00:00	SPY	ETF	313.4984	314.35	313.26	313.9103	3545349.0
2020-07-09 13:30:00	SPY	ETF	313.915	314.41	313.22	313.39	2415985.0
2020-07-09 14:00:00	SPY	ETF	313.38	314.67	313.18	314.54	2885940.0
2020-07-09 14:30:00	SPY	ETF	314.55	314.91	314.2203	314.88	2586774.0
2020-07-09 15:00:00	SPY	ETF	314.87	315.54	313.9	313.93	5104001.0
2020-07-09 15:30:00	SPY	ETF	313.95	315.19	313.29	314.42	11019419.0
2020-07-09 16:00:00	SPY	ETF	314.43	314.84	314.1	314.15	4744442.0
2020-07-09 16:30:00	SPY	ETF	314.13	314.42	314.1	314.3	2197186.0
2020-07-09 17:00:00	SPY	ETF	314.27	314.35	314.24	314.3	21092.0
2020-07-09 17:30:00	SPY	ETF	314.27	314.38	314.16	314.31	61925.0
2020-07-09 18:00:00	SPY	ETF	314.33	314.7	314.33	314.6	99090.0
2020-07-09 18:30:00	SPY	ETF	314.6	314.63	314.48	314.53	15140.0
2020-07-09 19:00:00	SPY	ETF	314.51	314.96	314.5	314.92	67706.0
2020-07-09 19:30:00	SPY	ETF	314.96	315.49	314.94	315.16	86277.0
2020-07-09 04:00:00	QQQ	ETF	260.62	260.68	260.35	260.57	19509.0
2020-07-09 04:30:00	QQQ	ETF	260.5	260.69	260.5	260.69	6100.0
2020-07-09 05:00:00	QQQ	ETF	260.6	260.74	260.48	260.53	31510.0
2020-07-09 05:30:00	QQQ	ETF	260.54	261.34	260.54	261.22	13653.0
2020-07-09 06:00:00	QQQ	ETF	261.24	261.32	261.2	261.29	8453.0
2020-07-09 06:30:00	QQQ	ETF	261.29	261.29	260.76	260.84	12600.0
2020-07-09 07:00:00	QQQ	ETF	260.83	261.56	260.83	261.47	54746.0
2020-07-09 07:30:00	QQQ	ETF	261.44	261.45	261.29	261.39	91379.0
2020-07-09 08:00:00	QQQ	ETF	260.9525	261.64	259.86	261.6	155978.0
2020-07-09 08:30:00	QQQ	ETF	261.73	261.99	261.56	261.76	139083.0
2020-07-09 09:00:00	QQQ	ETF	261.65	261.93	261.622	261.87	155314.0
2020-07-09 09:30:00	QQQ	ETF	261.89	262.205	260.77	261.82	4031179.0
2020-07-09 10:00:00	QQQ	ETF	261.84	262.124	260.55	261.3224	2868889.0
2020-07-09 10:30:00	QQQ	ETF	261.29	261.64	258.36	258.44	3485014.0
2020-07-09 11:00:00	QQQ	ETF	258.42	259.225	257.63	258.72	4248107.0
2020-07-09 11:30:00	QQQ	ETF	258.71	259.41	258.16	259.22	2504375.0
2020-07-09 12:00:00	QQQ	ETF	259.2	260.35	258.98	260.0	2068533.0
2020-07-09 12:30:00	QQQ	ETF	259.97	260.79	259.79	260.65	1593547.0

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

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