PREVIEW / etf_30min / 2019-02-26

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-02-26.parquet
  size:    495 KB
  rows:    17,318

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-02-26 04:00:00	SPY	ETF	278.97	278.97	278.46	278.46	13318.0
2019-02-26 04:30:00	SPY	ETF	278.49	278.96	278.49	278.96	2050.0
2019-02-26 05:00:00	SPY	ETF	279.0	279.0	278.9	278.94	5706.0
2019-02-26 05:30:00	SPY	ETF	278.98	279.12	278.9	279.12	4700.0
2019-02-26 06:00:00	SPY	ETF	279.11	279.12	278.89	278.89	15775.0
2019-02-26 06:30:00	SPY	ETF	278.84	278.94	278.7	278.92	14572.0
2019-02-26 07:00:00	SPY	ETF	279.03	279.26	278.98	279.24	120832.0
2019-02-26 07:30:00	SPY	ETF	279.23	279.25	279.09	279.2	49859.0
2019-02-26 08:00:00	SPY	ETF	279.21	279.2599	278.7	279.13	172595.0
2019-02-26 08:30:00	SPY	ETF	279.12	279.2	278.76	278.79	273269.0
2019-02-26 09:00:00	SPY	ETF	278.79	279.16	278.79	279.1	308745.0
2019-02-26 09:30:00	SPY	ETF	279.13	279.43	278.94	279.275	7183032.0
2019-02-26 10:00:00	SPY	ETF	279.28	279.96	279.18	279.64	6439461.0
2019-02-26 10:30:00	SPY	ETF	279.64	279.855	278.97	278.99	3391477.0
2019-02-26 11:00:00	SPY	ETF	278.995	280.17	278.9	279.975	4352542.0
2019-02-26 11:30:00	SPY	ETF	279.97	280.24	279.6	279.7	2619996.0
2019-02-26 12:00:00	SPY	ETF	279.7099	279.82	279.47	279.62	1624182.0
2019-02-26 12:30:00	SPY	ETF	279.62	279.6799	279.24	279.32	2442295.0
2019-02-26 13:00:00	SPY	ETF	279.305	279.65	279.24	279.482	1980525.0
2019-02-26 13:30:00	SPY	ETF	279.4885	279.5298	279.28	279.4545	1485144.0
2019-02-26 14:00:00	SPY	ETF	279.4585	279.69	279.35	279.46	2950307.0
2019-02-26 14:30:00	SPY	ETF	279.47	280.03	279.45	279.95	3448287.0
2019-02-26 15:00:00	SPY	ETF	279.945	280.3	279.92	279.92	4510453.0
2019-02-26 15:30:00	SPY	ETF	279.91	280.15	279.27	279.34	8213773.0
2019-02-26 16:00:00	SPY	ETF	279.34	279.39	279.02	279.09	3276887.0
2019-02-26 16:30:00	SPY	ETF	279.07	279.3389	278.85	278.88	276941.0
2019-02-26 17:00:00	SPY	ETF	278.85	278.92	278.81	278.91	121200.0
2019-02-26 17:30:00	SPY	ETF	278.92	278.94	278.68	278.73	198997.0
2019-02-26 18:00:00	SPY	ETF	278.67	278.94	278.61	278.94	106958.0
2019-02-26 18:30:00	SPY	ETF	278.92	278.99	278.77	278.84	27500.0
2019-02-26 19:00:00	SPY	ETF	278.82	279.02	278.8	278.94	29768.0
2019-02-26 19:30:00	SPY	ETF	278.94	278.97	278.8	278.8	22687.0
2019-02-26 04:00:00	QQQ	ETF	172.92	173.0	172.73	172.73	31976.0
2019-02-26 04:30:00	QQQ	ETF	172.71	173.01	172.7	173.01	12494.0
2019-02-26 05:00:00	QQQ	ETF	173.02	173.06	172.93	172.93	3600.0
2019-02-26 05:30:00	QQQ	ETF	173.0	173.1	173.0	173.1	30217.0
2019-02-26 06:00:00	QQQ	ETF	173.1	173.19	173.04	173.05	10239.0
2019-02-26 06:30:00	QQQ	ETF	173.0	173.06	172.89	173.05	9119.0
2019-02-26 07:00:00	QQQ	ETF	173.08	173.26	173.08	173.23	20404.0
2019-02-26 07:30:00	QQQ	ETF	173.2	173.24	173.13	173.16	16980.0
2019-02-26 08:00:00	QQQ	ETF	173.13	173.21	172.7	173.09	74229.0
2019-02-26 08:30:00	QQQ	ETF	173.05	173.11	172.75	172.79	103566.0
2019-02-26 09:00:00	QQQ	ETF	172.78	173.04	172.78	173.0	73351.0
2019-02-26 09:30:00	QQQ	ETF	173.04	173.5	172.81	173.39	2789225.0
2019-02-26 10:00:00	QQQ	ETF	173.38	173.91	173.3103	173.71	2429094.0
2019-02-26 10:30:00	QQQ	ETF	173.72	173.84	173.15	173.17	1360492.0
2019-02-26 11:00:00	QQQ	ETF	173.15	173.95	173.09	173.84	1751482.0
2019-02-26 11:30:00	QQQ	ETF	173.85	173.98	173.44	173.59	1246760.0
2019-02-26 12:00:00	QQQ	ETF	173.6	173.7	173.36	173.53	661977.0
2019-02-26 12:30:00	QQQ	ETF	173.5299	173.5785	173.2548	173.3279	747168.0

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

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