PREVIEW / etf_30min / 2019-07-01

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-07-01.parquet
  size:    530 KB
  rows:    18,636

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-07-01 04:00:00	SPY	ETF	296.1	296.53	296.1	296.39	31259.0
2019-07-01 04:30:00	SPY	ETF	296.42	296.42	296.26	296.32	5352.0
2019-07-01 05:00:00	SPY	ETF	296.3	296.33	296.1	296.1	5810.0
2019-07-01 05:30:00	SPY	ETF	296.27	296.45	296.27	296.29	8834.0
2019-07-01 06:00:00	SPY	ETF	296.4	296.67	296.4	296.61	36663.0
2019-07-01 06:30:00	SPY	ETF	296.62	296.67	296.42	296.42	29902.0
2019-07-01 07:00:00	SPY	ETF	296.4	296.4	296.25	296.36	56132.0
2019-07-01 07:30:00	SPY	ETF	296.37	296.52	296.37	296.44	110543.0
2019-07-01 08:00:00	SPY	ETF	296.45	296.7	295.73	296.66	475793.0
2019-07-01 08:30:00	SPY	ETF	296.67	296.68	296.41	296.49	157419.0
2019-07-01 09:00:00	SPY	ETF	296.46	296.84	296.46	296.66	448496.0
2019-07-01 09:30:00	SPY	ETF	296.68	296.92	296.0001	296.1533	9268020.0
2019-07-01 10:00:00	SPY	ETF	296.16	296.51	295.68	295.72	8120055.0
2019-07-01 10:30:00	SPY	ETF	295.72	296.08	295.47	295.73	4515899.0
2019-07-01 11:00:00	SPY	ETF	295.74	295.93	295.29	295.31	3293573.0
2019-07-01 11:30:00	SPY	ETF	295.31	295.8	295.28	295.44	3444846.0
2019-07-01 12:00:00	SPY	ETF	295.435	295.59	295.14	295.24	2807369.0
2019-07-01 12:30:00	SPY	ETF	295.245	295.295	294.63	294.7	2394960.0
2019-07-01 13:00:00	SPY	ETF	294.69	294.99	294.48	294.86	3909828.0
2019-07-01 13:30:00	SPY	ETF	294.85	294.92	294.61	294.87	2448644.0
2019-07-01 14:00:00	SPY	ETF	294.88	294.91	294.36	294.38	2661348.0
2019-07-01 14:30:00	SPY	ETF	294.385	294.63	294.33	294.39	1795869.0
2019-07-01 15:00:00	SPY	ETF	294.39	295.27	294.3636	295.1799	4739720.0
2019-07-01 15:30:00	SPY	ETF	295.18	295.77	295.18	295.61	11440880.0
2019-07-01 16:00:00	SPY	ETF	295.6	295.66	295.4	295.61	10793003.0
2019-07-01 16:30:00	SPY	ETF	295.61	295.66	295.55	295.57	192778.0
2019-07-01 17:00:00	SPY	ETF	295.58	295.66	295.4	295.5	3136521.0
2019-07-01 17:30:00	SPY	ETF	295.47	295.66	295.47	295.57	442490.0
2019-07-01 18:00:00	SPY	ETF	295.65	295.66	294.81	294.85	203108.0
2019-07-01 18:30:00	SPY	ETF	294.93	295.3	294.92	295.19	130505.0
2019-07-01 19:00:00	SPY	ETF	295.14	295.24	295.06	295.19	10633.0
2019-07-01 19:30:00	SPY	ETF	295.18	295.23	295.03	295.22	17565.0
2019-07-01 04:00:00	QQQ	ETF	189.45	190.02	188.4	189.83	39024.0
2019-07-01 04:30:00	QQQ	ETF	189.96	189.97	189.87	189.92	6977.0
2019-07-01 05:00:00	QQQ	ETF	189.93	189.95	189.77	189.83	4500.0
2019-07-01 05:30:00	QQQ	ETF	189.88	190.03	189.86	190.0	9000.0
2019-07-01 06:00:00	QQQ	ETF	189.99	190.17	189.93	190.14	18225.0
2019-07-01 06:30:00	QQQ	ETF	190.14	190.17	190.04	190.05	28050.0
2019-07-01 07:00:00	QQQ	ETF	190.04	190.07	189.88	189.99	211517.0
2019-07-01 07:30:00	QQQ	ETF	189.99	190.15	189.95	190.09	107572.0
2019-07-01 08:00:00	QQQ	ETF	189.96	190.33	189.22	190.27	114480.0
2019-07-01 08:30:00	QQQ	ETF	190.2701	190.2701	190.06	190.1099	117865.0
2019-07-01 09:00:00	QQQ	ETF	190.15	190.39	190.13	190.27	226243.0
2019-07-01 09:30:00	QQQ	ETF	190.3	190.5699	189.78	189.95	5977117.0
2019-07-01 10:00:00	QQQ	ETF	189.95	190.38	189.42	189.4477	2529379.0
2019-07-01 10:30:00	QQQ	ETF	189.45	189.7	189.24	189.48	1732704.0
2019-07-01 11:00:00	QQQ	ETF	189.5	189.63	189.2238	189.24	1177213.0
2019-07-01 11:30:00	QQQ	ETF	189.24	189.63	189.2	189.35	905819.0
2019-07-01 12:00:00	QQQ	ETF	189.34	189.47	188.98	189.11	693209.0
2019-07-01 12:30:00	QQQ	ETF	189.1	189.17	188.52	188.5796	1328816.0

> showing 50 of 18,636 rows — these rows as CSV

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