PREVIEW / etf_30min / 2019-02-08

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-02-08.parquet
  size:    487 KB
  rows:    16,890

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-08 04:00:00	SPY	ETF	269.45	269.62	269.43	269.46	7452.0
2019-02-08 04:30:00	SPY	ETF	269.42	269.43	269.24	269.31	5247.0
2019-02-08 05:00:00	SPY	ETF	269.31	269.36	269.2	269.31	2276.0
2019-02-08 05:30:00	SPY	ETF	269.33	269.33	269.01	269.2	22872.0
2019-02-08 06:00:00	SPY	ETF	269.26	269.3	269.06	269.15	20704.0
2019-02-08 06:30:00	SPY	ETF	269.1	269.1	268.51	268.58	54120.0
2019-02-08 07:00:00	SPY	ETF	268.62	268.71	268.44	268.63	121883.0
2019-02-08 07:30:00	SPY	ETF	268.59	268.72	268.43	268.58	132937.0
2019-02-08 08:00:00	SPY	ETF	268.53	269.3	268.45	268.87	293319.0
2019-02-08 08:30:00	SPY	ETF	268.95	269.04	268.72	268.72	251477.0
2019-02-08 09:00:00	SPY	ETF	268.75	268.97	268.64	268.73	165079.0
2019-02-08 09:30:00	SPY	ETF	268.75	269.44	268.51	268.6399	7981895.0
2019-02-08 10:00:00	SPY	ETF	268.64	270.2874	268.09	268.54	7423460.0
2019-02-08 10:30:00	SPY	ETF	268.545	269.13	268.17	268.345	4768835.0
2019-02-08 11:00:00	SPY	ETF	268.34	268.54	267.92	268.29	5458674.0
2019-02-08 11:30:00	SPY	ETF	268.29	268.68	267.83	268.61	5133874.0
2019-02-08 12:00:00	SPY	ETF	268.61	268.78	268.23	268.62	2733827.0
2019-02-08 12:30:00	SPY	ETF	268.62	269.02	268.6	268.87	2780197.0
2019-02-08 13:00:00	SPY	ETF	268.86	269.27	268.835	268.99	3322357.0
2019-02-08 13:30:00	SPY	ETF	268.98	269.35	268.88	269.2801	2177009.0
2019-02-08 14:00:00	SPY	ETF	269.29	269.71	269.13	269.685	4178678.0
2019-02-08 14:30:00	SPY	ETF	269.69	270.2874	269.57	269.58	3617645.0
2019-02-08 15:00:00	SPY	ETF	269.59	269.95	269.405	269.78	4928027.0
2019-02-08 15:30:00	SPY	ETF	269.78	270.51	269.5	270.49	11068623.0
2019-02-08 16:00:00	SPY	ETF	270.48	270.61	270.23	270.36	7001138.0
2019-02-08 16:30:00	SPY	ETF	270.36	270.6	270.36	270.56	1201051.0
2019-02-08 17:00:00	SPY	ETF	270.56	270.56	270.33	270.4	199597.0
2019-02-08 17:30:00	SPY	ETF	270.44	270.55	270.4	270.49	27955.0
2019-02-08 18:00:00	SPY	ETF	270.51	270.53	270.47	270.5	15124.0
2019-02-08 18:30:00	SPY	ETF	270.47	270.47	270.42	270.43	7753.0
2019-02-08 19:00:00	SPY	ETF	270.46	270.47	270.44	270.44	5184.0
2019-02-08 19:30:00	SPY	ETF	270.4	270.5	270.4	270.5	8209.0
2019-02-08 04:00:00	QQQ	ETF	167.45	167.6	167.45	167.52	11935.0
2019-02-08 04:30:00	QQQ	ETF	167.47	167.47	167.28	167.32	11685.0
2019-02-08 05:00:00	QQQ	ETF	167.37	167.38	167.22	167.33	11000.0
2019-02-08 05:30:00	QQQ	ETF	167.35	167.35	167.2	167.3	8750.0
2019-02-08 06:00:00	QQQ	ETF	167.33	167.39	167.24	167.27	5400.0
2019-02-08 06:30:00	QQQ	ETF	167.22	167.23	166.7	166.77	38420.0
2019-02-08 07:00:00	QQQ	ETF	166.8	166.83	166.65	166.79	71455.0
2019-02-08 07:30:00	QQQ	ETF	166.81	166.87	166.6	166.67	128874.0
2019-02-08 08:00:00	QQQ	ETF	168.23	168.23	166.63	166.93	159647.0
2019-02-08 08:30:00	QQQ	ETF	166.96	167.01	166.76	166.76	96565.0
2019-02-08 09:00:00	QQQ	ETF	166.79	166.94	166.67	166.75	153290.0
2019-02-08 09:30:00	QQQ	ETF	166.73	167.45	166.69	166.82	4149753.0
2019-02-08 10:00:00	QQQ	ETF	166.81	167.24	166.57	166.96	3652567.0
2019-02-08 10:30:00	QQQ	ETF	166.94	167.59	166.84	167.15	2172925.0
2019-02-08 11:00:00	QQQ	ETF	167.15	167.3525	166.88	167.0937	1599982.0
2019-02-08 11:30:00	QQQ	ETF	167.09	167.35	166.62	167.3	1739309.0
2019-02-08 12:00:00	QQQ	ETF	167.29	167.47	166.86	167.17	1037052.0
2019-02-08 12:30:00	QQQ	ETF	167.17	167.46	167.11	167.35	826038.0

> showing 50 of 16,890 rows — these rows as CSV

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