PREVIEW / etf_30min / 2020-03-23

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-03-23.parquet
  size:    632 KB
  rows:    23,784

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-03-23 04:00:00	SPY	ETF	221.14	222.0	219.79	220.94	183938.0
2020-03-23 04:30:00	SPY	ETF	221.2	221.9	220.5	220.8	79018.0
2020-03-23 05:00:00	SPY	ETF	220.84	222.85	220.84	221.46	90121.0
2020-03-23 05:30:00	SPY	ETF	221.77	223.63	221.62	222.52	106456.0
2020-03-23 06:00:00	SPY	ETF	222.36	223.15	221.86	222.69	90268.0
2020-03-23 06:30:00	SPY	ETF	222.85	224.37	222.71	223.87	119985.0
2020-03-23 07:00:00	SPY	ETF	223.79	224.05	222.5	222.74	747893.0
2020-03-23 07:30:00	SPY	ETF	222.71	222.8	220.9	222.1	746581.0
2020-03-23 08:00:00	SPY	ETF	221.94	238.89	218.34	234.79	7450328.0
2020-03-23 08:30:00	SPY	ETF	234.91	235.72	230.9	234.59	4261458.0
2020-03-23 09:00:00	SPY	ETF	234.6	235.92	228.0	228.12	3632517.0
2020-03-23 09:30:00	SPY	ETF	228.19	228.22	221.96	227.41	40424737.0
2020-03-23 10:00:00	SPY	ETF	227.4	228.78	224.83	226.68	16712013.0
2020-03-23 10:30:00	SPY	ETF	226.69	227.95	223.33	223.54	14982983.0
2020-03-23 11:00:00	SPY	ETF	223.52	225.16	220.51	220.6	16063195.0
2020-03-23 11:30:00	SPY	ETF	220.62	222.0	218.26	220.48	20184300.0
2020-03-23 12:00:00	SPY	ETF	220.48	224.03	219.27	222.77	20996787.0
2020-03-23 12:30:00	SPY	ETF	222.8	228.16	221.35	227.38	20316650.0
2020-03-23 13:00:00	SPY	ETF	227.4	229.39	225.265	225.42	13768086.0
2020-03-23 13:30:00	SPY	ETF	225.38	227.0	221.66	222.95	19006155.0
2020-03-23 14:00:00	SPY	ETF	222.96	224.39	220.7594	223.86	20358505.0
2020-03-23 14:30:00	SPY	ETF	223.88	229.6833	221.59	222.17	17220691.0
2020-03-23 15:00:00	SPY	ETF	222.18	223.5	219.49	220.01	19411343.0
2020-03-23 15:30:00	SPY	ETF	220.015	224.96	219.02	222.51	41115267.0
2020-03-23 16:00:00	SPY	ETF	222.39	223.18	220.61	222.17	15740695.0
2020-03-23 16:30:00	SPY	ETF	222.17	223.59	221.31	222.16	3878321.0
2020-03-23 17:00:00	SPY	ETF	222.15	223.07	222.03	223.07	2608606.0
2020-03-23 17:30:00	SPY	ETF	223.09	224.55	223.04	224.0	794071.0
2020-03-23 18:00:00	SPY	ETF	223.84	227.19	222.95	226.09	1563153.0
2020-03-23 18:30:00	SPY	ETF	226.16	226.67	225.11	226.25	578256.0
2020-03-23 19:00:00	SPY	ETF	226.01	228.87	225.83	227.02	481605.0
2020-03-23 19:30:00	SPY	ETF	227.04	227.33	225.8	225.93	283113.0
2020-03-23 04:00:00	QQQ	ETF	165.65	166.31	164.25	165.39	149548.0
2020-03-23 04:30:00	QQQ	ETF	165.47	165.78	164.8	164.8	26998.0
2020-03-23 05:00:00	QQQ	ETF	165.28	166.36	164.98	165.28	39729.0
2020-03-23 05:30:00	QQQ	ETF	165.59	166.64	165.49	165.89	34842.0
2020-03-23 06:00:00	QQQ	ETF	165.82	166.4	165.45	166.03	39712.0
2020-03-23 06:30:00	QQQ	ETF	166.2	167.45	166.2	167.2	37789.0
2020-03-23 07:00:00	QQQ	ETF	167.19	167.23	166.29	166.45	185422.0
2020-03-23 07:30:00	QQQ	ETF	166.46	166.46	165.35	165.76	182947.0
2020-03-23 08:00:00	QQQ	ETF	165.74	178.76	165.0	175.12	3301013.0
2020-03-23 08:30:00	QQQ	ETF	175.18	176.0	172.14	174.93	968310.0
2020-03-23 09:00:00	QQQ	ETF	174.9	176.08	170.54	170.88	1131764.0
2020-03-23 09:30:00	QQQ	ETF	170.96	171.7	166.81	171.47	14774103.0
2020-03-23 10:00:00	QQQ	ETF	171.47	172.6	169.81	171.0	7086926.0
2020-03-23 10:30:00	QQQ	ETF	171.01	171.91	168.61	168.78	5659192.0
2020-03-23 11:00:00	QQQ	ETF	168.78	169.88	166.32	166.475	6223720.0
2020-03-23 11:30:00	QQQ	ETF	166.48	167.56	164.93	167.13	8212499.0
2020-03-23 12:00:00	QQQ	ETF	167.09	169.75	166.23	168.64	6712283.0
2020-03-23 12:30:00	QQQ	ETF	168.66	173.34	167.7	172.72	7543760.0

> showing 50 of 23,784 rows — these rows as CSV

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