PREVIEW / etf_30min / 2019-04-30

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-04-30.parquet
  size:    495 KB
  rows:    17,246

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
2019-04-30 04:00:00	SPY	ETF	293.37	293.39	293.37	293.39	1300.0
2019-04-30 04:30:00	SPY	ETF	293.37	293.51	293.37	293.42	2228.0
2019-04-30 05:00:00	SPY	ETF	293.46	293.51	293.46	293.48	6700.0
2019-04-30 05:30:00	SPY	ETF	293.51	293.61	293.51	293.56	3510.0
2019-04-30 06:00:00	SPY	ETF	293.51	293.53	293.43	293.43	1830.0
2019-04-30 06:30:00	SPY	ETF	293.5	293.71	293.5	293.64	56508.0
2019-04-30 07:00:00	SPY	ETF	293.62	293.69	293.57	293.67	59357.0
2019-04-30 07:30:00	SPY	ETF	293.67	293.68	293.55	293.62	38975.0
2019-04-30 08:00:00	SPY	ETF	293.5701	293.86	293.32	293.68	50876.0
2019-04-30 08:30:00	SPY	ETF	293.62	293.71	293.23	293.4	118571.0
2019-04-30 09:00:00	SPY	ETF	293.36	293.53	293.25	293.52	201422.0
2019-04-30 09:30:00	SPY	ETF	293.49	293.52	292.9	293.03	7344120.0
2019-04-30 10:00:00	SPY	ETF	293.02	293.29	292.82	292.95	4940716.0
2019-04-30 10:30:00	SPY	ETF	292.95	293.275	292.83	292.84	2702488.0
2019-04-30 11:00:00	SPY	ETF	292.83	292.8325	291.92	292.45	6907825.0
2019-04-30 11:30:00	SPY	ETF	292.46	293.285	292.455	293.08	5935473.0
2019-04-30 12:00:00	SPY	ETF	293.08	293.35	293.03	293.27	1903295.0
2019-04-30 12:30:00	SPY	ETF	293.275	293.41	293.05	293.29	3120599.0
2019-04-30 13:00:00	SPY	ETF	293.2885	293.55	293.285	293.31	3020987.0
2019-04-30 13:30:00	SPY	ETF	293.31	293.96	293.23	293.94	6207870.0
2019-04-30 14:00:00	SPY	ETF	293.94	294.0	293.7	293.83	2765835.0
2019-04-30 14:30:00	SPY	ETF	293.83	293.95	293.67	293.79	3042272.0
2019-04-30 15:00:00	SPY	ETF	293.79	293.94	293.63	293.67	3221183.0
2019-04-30 15:30:00	SPY	ETF	293.67	294.34	293.64	293.97	12126001.0
2019-04-30 16:00:00	SPY	ETF	293.95	294.46	293.8041	294.44	10754568.0
2019-04-30 16:30:00	SPY	ETF	294.44	294.94	294.42	294.85	730014.0
2019-04-30 17:00:00	SPY	ETF	294.86	294.9	294.76	294.76	68959.0
2019-04-30 17:30:00	SPY	ETF	294.77	294.82	294.27	294.78	139805.0
2019-04-30 18:00:00	SPY	ETF	294.79	294.82	294.02	294.02	2382281.0
2019-04-30 18:30:00	SPY	ETF	294.73	294.74	294.6	294.74	24459.0
2019-04-30 19:00:00	SPY	ETF	294.74	294.74	294.57	294.66	13450.0
2019-04-30 19:30:00	SPY	ETF	294.65	294.82	294.65	294.82	40370.0
2019-04-30 04:00:00	QQQ	ETF	189.6	189.71	189.58	189.6	5296.0
2019-04-30 04:30:00	QQQ	ETF	189.63	189.66	189.62	189.65	5600.0
2019-04-30 05:00:00	QQQ	ETF	189.71	189.71	189.66	189.66	5339.0
2019-04-30 05:30:00	QQQ	ETF	189.71	189.82	189.71	189.8	4000.0
2019-04-30 06:00:00	QQQ	ETF	189.8	189.85	189.75	189.77	4500.0
2019-04-30 06:30:00	QQQ	ETF	189.77	189.88	189.77	189.85	9200.0
2019-04-30 07:00:00	QQQ	ETF	189.85	189.9	189.79	189.85	25353.0
2019-04-30 07:30:00	QQQ	ETF	189.83	189.85	189.72	189.83	22457.0
2019-04-30 08:00:00	QQQ	ETF	189.78	189.94	189.49	189.67	69477.0
2019-04-30 08:30:00	QQQ	ETF	189.7	189.73	189.36	189.38	146361.0
2019-04-30 09:00:00	QQQ	ETF	189.38	189.57	189.29	189.49	101400.0
2019-04-30 09:30:00	QQQ	ETF	189.48	189.85	189.12	189.52	3335453.0
2019-04-30 10:00:00	QQQ	ETF	189.53	189.83	189.09	189.16	1419697.0
2019-04-30 10:30:00	QQQ	ETF	189.1607	189.36	188.95	188.9566	1590555.0
2019-04-30 11:00:00	QQQ	ETF	188.955	188.955	188.21	188.44	3214602.0
2019-04-30 11:30:00	QQQ	ETF	188.445	189.1277	188.44	188.99	2110515.0
2019-04-30 12:00:00	QQQ	ETF	189.0	189.37	188.965	189.325	975134.0
2019-04-30 12:30:00	QQQ	ETF	189.33	189.46	189.1	189.3098	990200.0

> showing 50 of 17,246 rows — these rows as CSV

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