PREVIEW / etf_30min / 2019-06-21

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-06-21.parquet
  size:    504 KB
  rows:    17,781

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-06-21 04:00:00	SPY	ETF	294.37	294.37	294.04	294.19	14101.0
2019-06-21 04:30:00	SPY	ETF	294.2	294.29	293.95	293.95	8114.0
2019-06-21 05:00:00	SPY	ETF	293.99	294.25	293.97	294.25	24170.0
2019-06-21 05:30:00	SPY	ETF	294.32	294.32	293.85	294.06	12477.0
2019-06-21 06:00:00	SPY	ETF	294.0	294.1	293.8	293.86	17191.0
2019-06-21 06:30:00	SPY	ETF	293.9	294.26	293.9	294.11	32302.0
2019-06-21 07:00:00	SPY	ETF	294.13	294.33	293.92	293.97	107718.0
2019-06-21 07:30:00	SPY	ETF	293.96	294.02	293.87	293.91	46947.0
2019-06-21 08:00:00	SPY	ETF	294.06	294.35	293.4	293.8	360658.0
2019-06-21 08:30:00	SPY	ETF	293.8	294.17	293.72	293.85	284583.0
2019-06-21 09:00:00	SPY	ETF	293.85	294.13	293.65	294.09	996415.0
2019-06-21 09:30:00	SPY	ETF	294.13	294.37	293.76	294.01	8640424.0
2019-06-21 10:00:00	SPY	ETF	294.04	294.24	293.84	294.23	3888596.0
2019-06-21 10:30:00	SPY	ETF	294.225	294.73	294.16	294.46	9343802.0
2019-06-21 11:00:00	SPY	ETF	294.45	295.52	294.44	294.86	5364723.0
2019-06-21 11:30:00	SPY	ETF	294.85	295.11	294.35	294.51	3285281.0
2019-06-21 12:00:00	SPY	ETF	294.5	294.66	294.14	294.33	4239232.0
2019-06-21 12:30:00	SPY	ETF	294.325	294.53	294.14	294.43	2589734.0
2019-06-21 13:00:00	SPY	ETF	294.44	294.53	294.16	294.375	2166864.0
2019-06-21 13:30:00	SPY	ETF	294.38	294.525	294.355	294.5234	1146447.0
2019-06-21 14:00:00	SPY	ETF	294.52	294.67	294.25	294.43	3447876.0
2019-06-21 14:30:00	SPY	ETF	294.43	294.65	294.37	294.52	3412454.0
2019-06-21 15:00:00	SPY	ETF	294.52	294.88	294.4747	294.61	5259279.0
2019-06-21 15:30:00	SPY	ETF	294.62	294.89	293.95	294.08	11528399.0
2019-06-21 16:00:00	SPY	ETF	294.05	294.35	293.57	293.64	11012541.0
2019-06-21 16:30:00	SPY	ETF	293.65	294.1018	293.44	293.44	1425896.0
2019-06-21 17:00:00	SPY	ETF	293.5	294.0	293.21	293.28	763042.0
2019-06-21 17:30:00	SPY	ETF	293.36	293.38	293.24	293.38	60334.0
2019-06-21 18:00:00	SPY	ETF	293.36	294.0	293.2	293.2	270769.0
2019-06-21 18:30:00	SPY	ETF	293.2	293.24	293.13	293.24	14620.0
2019-06-21 19:00:00	SPY	ETF	293.24	293.24	293.14	293.19	17917.0
2019-06-21 19:30:00	SPY	ETF	293.24	293.24	293.13	293.17	21971.0
2019-06-21 04:00:00	QQQ	ETF	188.55	188.62	188.47	188.6	6296.0
2019-06-21 04:30:00	QQQ	ETF	188.65	188.65	188.42	188.48	1875.0
2019-06-21 05:00:00	QQQ	ETF	188.51	188.71	188.47	188.71	2220.0
2019-06-21 05:30:00	QQQ	ETF	188.65	188.65	188.37	188.56	5399.0
2019-06-21 06:00:00	QQQ	ETF	188.4	188.57	188.28	188.28	6390.0
2019-06-21 06:30:00	QQQ	ETF	188.38	188.54	188.29	188.51	12377.0
2019-06-21 07:00:00	QQQ	ETF	188.46	188.56	188.31	188.35	29517.0
2019-06-21 07:30:00	QQQ	ETF	188.3	188.4	188.27	188.33	17542.0
2019-06-21 08:00:00	QQQ	ETF	188.3901	189.03	188.0	188.17	135415.0
2019-06-21 08:30:00	QQQ	ETF	188.2	188.47	188.11	188.35	181984.0
2019-06-21 09:00:00	QQQ	ETF	188.34	188.69	188.21	188.57	491929.0
2019-06-21 09:30:00	QQQ	ETF	188.57	188.76	188.1736	188.6	4566950.0
2019-06-21 10:00:00	QQQ	ETF	188.6	188.92	188.5001	188.74	2782250.0
2019-06-21 10:30:00	QQQ	ETF	188.75	189.37	188.74	189.06	2326310.0
2019-06-21 11:00:00	QQQ	ETF	189.07	189.77	189.06	189.2	2949028.0
2019-06-21 11:30:00	QQQ	ETF	189.2	189.3932	188.7115	188.82	1394586.0
2019-06-21 12:00:00	QQQ	ETF	188.8198	188.97	188.51	188.71	1282309.0
2019-06-21 12:30:00	QQQ	ETF	188.7	188.92	188.57	188.8568	767962.0

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

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