PREVIEW / etf_30min / 2020-10-29

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-10-29.parquet
  size:    576 KB
  rows:    21,225

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-10-29 04:00:00	SPY	ETF	329.16	330.1	328.41	329.5	85641.0
2020-10-29 04:30:00	SPY	ETF	329.37	329.37	328.6	328.95	18511.0
2020-10-29 05:00:00	SPY	ETF	329.05	329.64	329.04	329.54	31266.0
2020-10-29 05:30:00	SPY	ETF	329.6	329.6	328.62	329.07	34993.0
2020-10-29 06:00:00	SPY	ETF	328.99	328.99	328.2	328.33	135332.0
2020-10-29 06:30:00	SPY	ETF	328.43	328.85	328.18	328.53	54670.0
2020-10-29 07:00:00	SPY	ETF	328.51	328.53	327.44	327.5	300864.0
2020-10-29 07:30:00	SPY	ETF	327.48	327.8	325.65	325.75	475752.0
2020-10-29 08:00:00	SPY	ETF	325.79	331.02	325.67	326.32	511716.0
2020-10-29 08:30:00	SPY	ETF	326.36	327.72	326.24	327.18	753584.0
2020-10-29 09:00:00	SPY	ETF	327.08	327.34	326.59	326.9	399192.0
2020-10-29 09:30:00	SPY	ETF	326.91	329.4853	325.09	327.83	11237434.0
2020-10-29 10:00:00	SPY	ETF	327.87	329.16	327.11	329.12	7614487.0
2020-10-29 10:30:00	SPY	ETF	329.12	329.82	328.68	329.22	6890705.0
2020-10-29 11:00:00	SPY	ETF	329.21	329.87	328.47	329.065	5239550.0
2020-10-29 11:30:00	SPY	ETF	329.065	329.32	327.82	328.43	4663643.0
2020-10-29 12:00:00	SPY	ETF	328.44	329.204	327.98	328.95	2705790.0
2020-10-29 12:30:00	SPY	ETF	328.94	329.71	328.815	329.2	2763897.0
2020-10-29 13:00:00	SPY	ETF	329.21	330.07	328.5734	329.995	2603331.0
2020-10-29 13:30:00	SPY	ETF	329.9919	331.57	329.96	331.49	5282760.0
2020-10-29 14:00:00	SPY	ETF	331.48	333.22	331.45	332.99	6590100.0
2020-10-29 14:30:00	SPY	ETF	333.0	333.395	331.7	332.09	5669348.0
2020-10-29 15:00:00	SPY	ETF	332.11	332.58	330.93	332.03	5671891.0
2020-10-29 15:30:00	SPY	ETF	332.04	332.54	329.93	329.99	10105198.0
2020-10-29 16:00:00	SPY	ETF	329.97	331.11	328.8	329.13	7548159.0
2020-10-29 16:30:00	SPY	ETF	329.09	329.98	327.18	327.64	810521.0
2020-10-29 17:00:00	SPY	ETF	327.55	327.59	326.88	327.23	159445.0
2020-10-29 17:30:00	SPY	ETF	327.24	327.35	327.0	327.05	103926.0
2020-10-29 18:00:00	SPY	ETF	327.03	327.46	326.47	326.84	198314.0
2020-10-29 18:30:00	SPY	ETF	326.97	327.25	326.7	327.01	79212.0
2020-10-29 19:00:00	SPY	ETF	327.1	327.93	327.1	327.68	94853.0
2020-10-29 19:30:00	SPY	ETF	327.72	328.16	327.6	327.65	166988.0
2020-10-29 04:00:00	QQQ	ETF	274.32	275.12	274.0	274.45	50993.0
2020-10-29 04:30:00	QQQ	ETF	274.48	274.74	274.13	274.41	15302.0
2020-10-29 05:00:00	QQQ	ETF	274.54	275.31	274.54	275.14	24493.0
2020-10-29 05:30:00	QQQ	ETF	275.23	275.3	274.44	274.64	26540.0
2020-10-29 06:00:00	QQQ	ETF	274.7	274.7	273.82	274.05	36537.0
2020-10-29 06:30:00	QQQ	ETF	274.23	274.61	273.87	274.43	22710.0
2020-10-29 07:00:00	QQQ	ETF	274.41	274.41	273.36	273.36	190624.0
2020-10-29 07:30:00	QQQ	ETF	273.34	273.7	271.95	272.02	279400.0
2020-10-29 08:00:00	QQQ	ETF	272.1	275.31	271.64	272.53	241462.0
2020-10-29 08:30:00	QQQ	ETF	272.5	273.72	272.36	273.3	320940.0
2020-10-29 09:00:00	QQQ	ETF	273.27	273.5	272.89	273.06	274609.0
2020-10-29 09:30:00	QQQ	ETF	273.04	274.9898	272.52	274.71	5303559.0
2020-10-29 10:00:00	QQQ	ETF	274.74	275.73	274.37	275.615	2758776.0
2020-10-29 10:30:00	QQQ	ETF	275.63	275.85	274.72	275.34	1798169.0
2020-10-29 11:00:00	QQQ	ETF	275.34	276.53	274.79	276.2426	1612448.0
2020-10-29 11:30:00	QQQ	ETF	276.24	276.45	274.79	275.2958	2046869.0
2020-10-29 12:00:00	QQQ	ETF	275.3072	276.017	274.97	275.83	1079403.0
2020-10-29 12:30:00	QQQ	ETF	275.82	276.49	275.59	276.12	1345010.0

> showing 50 of 21,225 rows — these rows as CSV

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