PREVIEW / etf_30min / 2019-08-01

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-08-01.parquet
  size:    531 KB
  rows:    18,665

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-08-01 04:00:00	SPY	ETF	297.76	297.9	297.65	297.72	15141.0
2019-08-01 04:30:00	SPY	ETF	297.64	297.81	297.39	297.76	12080.0
2019-08-01 05:00:00	SPY	ETF	297.73	298.35	297.73	298.18	46882.0
2019-08-01 05:30:00	SPY	ETF	298.18	298.38	298.08	298.32	9160.0
2019-08-01 06:00:00	SPY	ETF	298.31	298.33	298.23	298.23	6190.0
2019-08-01 06:30:00	SPY	ETF	298.34	298.37	298.08	298.11	13090.0
2019-08-01 07:00:00	SPY	ETF	298.05	298.17	297.89	298.03	108056.0
2019-08-01 07:30:00	SPY	ETF	298.03	298.29	297.8	297.93	109065.0
2019-08-01 08:00:00	SPY	ETF	297.913	298.26	297.3	297.6	329815.0
2019-08-01 08:30:00	SPY	ETF	297.6	297.83	297.59	297.78	181788.0
2019-08-01 09:00:00	SPY	ETF	297.75	297.8	297.27	297.6	432581.0
2019-08-01 09:30:00	SPY	ETF	297.6	298.81	297.48	298.66	8019717.0
2019-08-01 10:00:00	SPY	ETF	298.66	299.685	298.34	299.68	5471984.0
2019-08-01 10:30:00	SPY	ETF	299.67	300.28	299.54	300.24	5057908.0
2019-08-01 11:00:00	SPY	ETF	300.24	300.75	299.98	300.72	5843417.0
2019-08-01 11:30:00	SPY	ETF	300.73	300.87	300.41	300.42	2853829.0
2019-08-01 12:00:00	SPY	ETF	300.42	300.495	300.07	300.22	2972875.0
2019-08-01 12:30:00	SPY	ETF	300.2136	300.61	300.17	300.38	2022982.0
2019-08-01 13:00:00	SPY	ETF	300.38	300.48	297.9702	298.23	6725375.0
2019-08-01 13:30:00	SPY	ETF	298.23	298.98	295.17	296.41	24460797.0
2019-08-01 14:00:00	SPY	ETF	296.4	296.54	294.56	295.32	16343711.0
2019-08-01 14:30:00	SPY	ETF	295.32	295.69	293.96	295.2	17589936.0
2019-08-01 15:00:00	SPY	ETF	295.21	295.96	294.4	295.475	11199243.0
2019-08-01 15:30:00	SPY	ETF	295.48	295.93	294.4	294.88	18747372.0
2019-08-01 16:00:00	SPY	ETF	294.92	297.5254	294.57	294.7	11032609.0
2019-08-01 16:30:00	SPY	ETF	294.74	294.91	294.26	294.33	346804.0
2019-08-01 17:00:00	SPY	ETF	294.32	294.84	294.07	294.18	100573.0
2019-08-01 17:30:00	SPY	ETF	294.22	294.41	294.2	294.41	58127.0
2019-08-01 18:00:00	SPY	ETF	294.4	294.84	293.97	293.97	130652.0
2019-08-01 18:30:00	SPY	ETF	293.95	294.09	293.72	293.92	21527.0
2019-08-01 19:00:00	SPY	ETF	294.04	294.26	293.99	294.09	21856.0
2019-08-01 19:30:00	SPY	ETF	294.14	294.26	294.02	294.06	80727.0
2019-08-01 04:00:00	QQQ	ETF	191.5	191.57	191.36	191.45	45519.0
2019-08-01 04:30:00	QQQ	ETF	191.37	191.49	191.21	191.49	3400.0
2019-08-01 05:00:00	QQQ	ETF	191.47	192.04	191.47	191.84	18437.0
2019-08-01 05:30:00	QQQ	ETF	191.86	192.04	191.8	191.99	5700.0
2019-08-01 06:00:00	QQQ	ETF	191.96	192.02	191.91	192.02	6800.0
2019-08-01 06:30:00	QQQ	ETF	192.02	192.07	191.85	191.85	20270.0
2019-08-01 07:00:00	QQQ	ETF	191.86	191.92	191.69	191.75	93869.0
2019-08-01 07:30:00	QQQ	ETF	191.77	191.99	191.59	191.67	91000.0
2019-08-01 08:00:00	QQQ	ETF	191.67	191.9	190.75	191.45	108500.0
2019-08-01 08:30:00	QQQ	ETF	191.45	191.69	191.45	191.67	89186.0
2019-08-01 09:00:00	QQQ	ETF	191.61	191.67	191.27	191.53	257336.0
2019-08-01 09:30:00	QQQ	ETF	191.52	193.07	191.42	192.92	4795268.0
2019-08-01 10:00:00	QQQ	ETF	192.91	193.89	192.86	193.89	2748084.0
2019-08-01 10:30:00	QQQ	ETF	193.88	194.57	193.75	194.53	4096239.0
2019-08-01 11:00:00	QQQ	ETF	194.525	194.975	194.36	194.96	3124746.0
2019-08-01 11:30:00	QQQ	ETF	194.97	194.98	194.53	194.55	1192856.0
2019-08-01 12:00:00	QQQ	ETF	194.56	194.605	194.32	194.54	840839.0
2019-08-01 12:30:00	QQQ	ETF	194.54	194.77	194.44	194.53	743104.0

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

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