PREVIEW / etf_30min / 2019-10-30

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-10-30.parquet
  size:    505 KB
  rows:    17,500

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-10-30 04:00:00	SPY	ETF	303.17	303.21	303.08	303.13	4106.0
2019-10-30 04:30:00	SPY	ETF	303.01	303.08	302.93	302.93	2900.0
2019-10-30 05:00:00	SPY	ETF	302.96	303.0	302.93	302.98	4122.0
2019-10-30 05:30:00	SPY	ETF	303.06	303.07	303.03	303.03	2900.0
2019-10-30 06:00:00	SPY	ETF	303.08	303.19	303.01	303.1	4240.0
2019-10-30 06:30:00	SPY	ETF	303.08	303.28	303.08	303.17	4750.0
2019-10-30 07:00:00	SPY	ETF	303.19	303.36	303.19	303.35	13090.0
2019-10-30 07:30:00	SPY	ETF	303.37	303.42	303.32	303.32	11172.0
2019-10-30 08:00:00	SPY	ETF	303.2499	303.4	302.95	303.28	28793.0
2019-10-30 08:30:00	SPY	ETF	303.32	303.49	303.24	303.42	65114.0
2019-10-30 09:00:00	SPY	ETF	303.41	303.52	303.41	303.42	89050.0
2019-10-30 09:30:00	SPY	ETF	303.43	303.43	302.65	302.87	3283469.0
2019-10-30 10:00:00	SPY	ETF	302.865	303.01	301.99	302.89	4656936.0
2019-10-30 10:30:00	SPY	ETF	302.9	303.1	302.66	303.06	1628345.0
2019-10-30 11:00:00	SPY	ETF	303.06	303.09	302.63	302.81	1799390.0
2019-10-30 11:30:00	SPY	ETF	302.8	302.9	302.53	302.79	1660427.0
2019-10-30 12:00:00	SPY	ETF	302.78	303.12	302.75	303.07	1562147.0
2019-10-30 12:30:00	SPY	ETF	303.07	303.17	302.8865	302.9	1078881.0
2019-10-30 13:00:00	SPY	ETF	302.91	303.05	302.86	302.91	1056960.0
2019-10-30 13:30:00	SPY	ETF	302.92	303.04	302.41	302.5	3085937.0
2019-10-30 14:00:00	SPY	ETF	302.49	303.37	302.1	303.03	4879112.0
2019-10-30 14:30:00	SPY	ETF	303.03	303.81	302.47	303.6696	6261617.0
2019-10-30 15:00:00	SPY	ETF	303.66	304.55	303.64	304.15	4211840.0
2019-10-30 15:30:00	SPY	ETF	304.15	304.27	303.83	304.14	7042861.0
2019-10-30 16:00:00	SPY	ETF	304.14	304.49	304.08	304.37	5423600.0
2019-10-30 16:30:00	SPY	ETF	304.37	305.13	304.25	304.75	709187.0
2019-10-30 17:00:00	SPY	ETF	304.63	304.79	304.6	304.7	171428.0
2019-10-30 17:30:00	SPY	ETF	304.65	304.86	304.65	304.75	36247.0
2019-10-30 18:00:00	SPY	ETF	304.7	304.73	304.5	304.56	49521.0
2019-10-30 18:30:00	SPY	ETF	304.53	304.6	304.52	304.54	5152.0
2019-10-30 19:00:00	SPY	ETF	304.54	304.54	304.45	304.52	8605.0
2019-10-30 19:30:00	SPY	ETF	304.52	304.6	304.46	304.5	27163.0
2019-10-30 04:00:00	QQQ	ETF	196.09	196.1	196.09	196.1	400.0
2019-10-30 04:30:00	QQQ	ETF	196.12	196.12	196.12	196.12	400.0
2019-10-30 05:00:00	QQQ	ETF	196.03	196.1	195.99	196.1	6870.0
2019-10-30 05:30:00	QQQ	ETF	196.09	196.09	196.03	196.09	1250.0
2019-10-30 06:00:00	QQQ	ETF	196.11	196.15	196.06	196.1	600.0
2019-10-30 06:30:00	QQQ	ETF	196.11	196.19	196.11	196.17	6200.0
2019-10-30 07:00:00	QQQ	ETF	196.16	196.34	196.16	196.34	17920.0
2019-10-30 07:30:00	QQQ	ETF	196.37	196.47	196.37	196.42	26395.0
2019-10-30 08:00:00	QQQ	ETF	196.43	196.4399	196.02	196.36	25997.0
2019-10-30 08:30:00	QQQ	ETF	196.37	196.59	196.36	196.51	51573.0
2019-10-30 09:00:00	QQQ	ETF	196.5	196.59	196.42	196.42	122986.0
2019-10-30 09:30:00	QQQ	ETF	196.42	196.43	195.72	196.0301	2363659.0
2019-10-30 10:00:00	QQQ	ETF	196.04	196.23	195.29	196.11	2793126.0
2019-10-30 10:30:00	QQQ	ETF	196.1	196.42	195.92	196.39	998811.0
2019-10-30 11:00:00	QQQ	ETF	196.39	196.4	195.93	196.04	911226.0
2019-10-30 11:30:00	QQQ	ETF	196.05	196.075	195.775	196.0	580117.0
2019-10-30 12:00:00	QQQ	ETF	195.99	196.17	195.89	196.13	451412.0
2019-10-30 12:30:00	QQQ	ETF	196.13	196.21	195.93	195.94	740857.0

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

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