PREVIEW / etf_30min / 2020-07-10

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-07-10.parquet
  size:    544 KB
  rows:    20,077

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-10 04:00:00	SPY	ETF	312.64	313.54	312.64	313.45	27297.0
2020-07-10 04:30:00	SPY	ETF	313.2	313.2	312.45	312.49	18785.0
2020-07-10 05:00:00	SPY	ETF	312.6	312.78	312.02	312.59	17846.0
2020-07-10 05:30:00	SPY	ETF	312.56	312.99	312.56	312.92	14583.0
2020-07-10 06:00:00	SPY	ETF	312.94	313.12	312.6	312.66	133272.0
2020-07-10 06:30:00	SPY	ETF	312.73	313.25	312.73	313.21	27555.0
2020-07-10 07:00:00	SPY	ETF	313.28	313.73	313.24	313.25	78369.0
2020-07-10 07:30:00	SPY	ETF	313.27	313.32	312.72	312.75	133109.0
2020-07-10 08:00:00	SPY	ETF	312.83	314.03	311.39	312.45	301735.0
2020-07-10 08:30:00	SPY	ETF	312.3	314.45	312.3	313.74	979601.0
2020-07-10 09:00:00	SPY	ETF	313.76	314.8	313.76	314.28	625822.0
2020-07-10 09:30:00	SPY	ETF	314.31	315.09	313.47	314.01	6410276.0
2020-07-10 10:00:00	SPY	ETF	313.98	314.81	312.76	314.66	4435999.0
2020-07-10 10:30:00	SPY	ETF	314.64	315.65	314.481	315.08	5139659.0
2020-07-10 11:00:00	SPY	ETF	315.07	315.53	314.495	315.34	2216568.0
2020-07-10 11:30:00	SPY	ETF	315.29	315.93	314.85	315.85	3052170.0
2020-07-10 12:00:00	SPY	ETF	315.85	316.13	315.14	315.21	3243568.0
2020-07-10 12:30:00	SPY	ETF	315.22	315.88	314.91	315.83	1850773.0
2020-07-10 13:00:00	SPY	ETF	315.83	316.03	315.63	315.96	1643117.0
2020-07-10 13:30:00	SPY	ETF	315.97	316.67	315.71	316.51	2771594.0
2020-07-10 14:00:00	SPY	ETF	316.51	316.6704	316.18	316.4	2322343.0
2020-07-10 14:30:00	SPY	ETF	316.405	316.95	316.35	316.92	2588163.0
2020-07-10 15:00:00	SPY	ETF	316.92	317.46	316.51	317.35	3757842.0
2020-07-10 15:30:00	SPY	ETF	317.34	317.88	316.99	317.61	10600923.0
2020-07-10 16:00:00	SPY	ETF	317.63	318.0	317.59	317.79	3352363.0
2020-07-10 16:30:00	SPY	ETF	317.8	318.18	317.59	318.0	796761.0
2020-07-10 17:00:00	SPY	ETF	318.0	318.03	317.59	317.96	133090.0
2020-07-10 17:30:00	SPY	ETF	317.93	317.97	317.82	317.83	14996.0
2020-07-10 18:00:00	SPY	ETF	317.83	317.95	317.76	317.84	28398.0
2020-07-10 18:30:00	SPY	ETF	317.88	317.97	317.83	317.92	19442.0
2020-07-10 19:00:00	SPY	ETF	317.92	318.09	317.92	317.95	29958.0
2020-07-10 19:30:00	SPY	ETF	318.0	318.15	317.97	318.1	18915.0
2020-07-10 04:00:00	QQQ	ETF	260.47	261.33	260.47	261.16	33265.0
2020-07-10 04:30:00	QQQ	ETF	261.07	261.07	260.62	260.76	52253.0
2020-07-10 05:00:00	QQQ	ETF	260.84	261.04	260.6	261.04	6995.0
2020-07-10 05:30:00	QQQ	ETF	261.12	261.27	261.07	261.23	19187.0
2020-07-10 06:00:00	QQQ	ETF	261.22	261.39	260.93	260.97	67306.0
2020-07-10 06:30:00	QQQ	ETF	261.03	261.28	261.03	261.26	20234.0
2020-07-10 07:00:00	QQQ	ETF	261.27	261.67	261.27	261.4	65853.0
2020-07-10 07:30:00	QQQ	ETF	261.4	261.41	260.83	260.9	78672.0
2020-07-10 08:00:00	QQQ	ETF	260.8701	261.6202	259.99	260.85	149007.0
2020-07-10 08:30:00	QQQ	ETF	260.86	262.04	260.82	261.63	287936.0
2020-07-10 09:00:00	QQQ	ETF	261.69	262.25	261.69	261.92	234788.0
2020-07-10 09:30:00	QQQ	ETF	261.91	262.28	260.02	260.47	5194227.0
2020-07-10 10:00:00	QQQ	ETF	260.41	261.66	259.26	261.47	3669586.0
2020-07-10 10:30:00	QQQ	ETF	261.45	261.92	260.96	261.44	2258482.0
2020-07-10 11:00:00	QQQ	ETF	261.405	261.9199	260.9	261.63	1467689.0
2020-07-10 11:30:00	QQQ	ETF	261.63	262.24	261.43	262.07	1726126.0
2020-07-10 12:00:00	QQQ	ETF	262.065	262.17	261.41	261.5699	1569184.0
2020-07-10 12:30:00	QQQ	ETF	261.56	262.14	261.39	262.05	1060936.0

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

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