PREVIEW / etf_30min / 2019-08-28

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-08-28.parquet
  size:    505 KB
  rows:    17,396

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-28 04:00:00	SPY	ETF	287.02	287.62	286.9	287.5	6119.0
2019-08-28 04:30:00	SPY	ETF	287.67	287.67	286.5	287.02	9835.0
2019-08-28 05:00:00	SPY	ETF	287.12	287.4	287.12	287.19	2393.0
2019-08-28 05:30:00	SPY	ETF	287.05	287.07	286.9	286.9	3738.0
2019-08-28 06:00:00	SPY	ETF	287.12	287.47	286.62	286.89	22676.0
2019-08-28 06:30:00	SPY	ETF	287.01	287.1	286.8	286.88	8434.0
2019-08-28 07:00:00	SPY	ETF	286.88	286.95	286.28	286.28	110384.0
2019-08-28 07:30:00	SPY	ETF	286.22	286.38	285.86	286.09	139563.0
2019-08-28 08:00:00	SPY	ETF	286.25	287.52	285.46	285.62	232846.0
2019-08-28 08:30:00	SPY	ETF	285.63	286.32	285.62	286.3	166766.0
2019-08-28 09:00:00	SPY	ETF	286.28	286.73	285.95	286.12	505874.0
2019-08-28 09:30:00	SPY	ETF	286.14	287.21	285.25	287.14	9738428.0
2019-08-28 10:00:00	SPY	ETF	287.14	287.61	286.91	287.08	4604115.0
2019-08-28 10:30:00	SPY	ETF	287.07	288.205	287.07	287.92	3923291.0
2019-08-28 11:00:00	SPY	ETF	287.92	288.6	287.55	288.5	3645063.0
2019-08-28 11:30:00	SPY	ETF	288.5	288.81	288.32	288.5	4675111.0
2019-08-28 12:00:00	SPY	ETF	288.495	288.76	288.3	288.38	1703592.0
2019-08-28 12:30:00	SPY	ETF	288.38	288.73	288.17	288.71	2729584.0
2019-08-28 13:00:00	SPY	ETF	288.71	288.72	288.0	288.41	2582028.0
2019-08-28 13:30:00	SPY	ETF	288.4	288.74	288.27	288.48	2050748.0
2019-08-28 14:00:00	SPY	ETF	288.49	288.64	288.38	288.55	2159371.0
2019-08-28 14:30:00	SPY	ETF	288.565	288.99	288.5	288.945	3233182.0
2019-08-28 15:00:00	SPY	ETF	288.94	289.07	288.52	288.52	3762611.0
2019-08-28 15:30:00	SPY	ETF	288.52	288.92	288.27	288.83	7801457.0
2019-08-28 16:00:00	SPY	ETF	288.83	289.07	288.78	288.95	3199956.0
2019-08-28 16:30:00	SPY	ETF	288.93	288.93	288.17	288.37	624226.0
2019-08-28 17:00:00	SPY	ETF	288.41	288.75	288.3	288.75	220207.0
2019-08-28 17:30:00	SPY	ETF	288.75	288.89	288.53	288.55	167254.0
2019-08-28 18:00:00	SPY	ETF	288.52	289.02	288.36	288.73	843795.0
2019-08-28 18:30:00	SPY	ETF	288.74	288.82	288.63	288.76	16056.0
2019-08-28 19:00:00	SPY	ETF	288.7	288.7	288.41	288.55	39052.0
2019-08-28 19:30:00	SPY	ETF	288.5	288.63	288.33	288.51	51486.0
2019-08-28 04:00:00	QQQ	ETF	184.61	185.08	184.5	184.91	12352.0
2019-08-28 04:30:00	QQQ	ETF	185.1	185.1	184.09	184.56	19036.0
2019-08-28 05:00:00	QQQ	ETF	184.5	184.82	184.46	184.77	12431.0
2019-08-28 05:30:00	QQQ	ETF	184.64	184.64	184.35	184.5	16400.0
2019-08-28 06:00:00	QQQ	ETF	184.55	184.85	184.26	184.5	23875.0
2019-08-28 06:30:00	QQQ	ETF	184.5	184.6	184.4	184.42	6045.0
2019-08-28 07:00:00	QQQ	ETF	184.49	184.5	184.02	184.02	71351.0
2019-08-28 07:30:00	QQQ	ETF	184.01	184.13	183.73	183.9	112327.0
2019-08-28 08:00:00	QQQ	ETF	184.06	184.69	183.39	183.45	167075.0
2019-08-28 08:30:00	QQQ	ETF	183.5	184.0	183.49	183.97	93754.0
2019-08-28 09:00:00	QQQ	ETF	183.94	184.36	183.73	183.84	198474.0
2019-08-28 09:30:00	QQQ	ETF	183.85	184.23	182.91	184.0432	3472747.0
2019-08-28 10:00:00	QQQ	ETF	184.065	184.57	183.88	184.03	2253306.0
2019-08-28 10:30:00	QQQ	ETF	184.03	184.82	184.03	184.61	2000776.0
2019-08-28 11:00:00	QQQ	ETF	184.63	185.01	184.24	184.96	1547297.0
2019-08-28 11:30:00	QQQ	ETF	184.96	185.25	184.85	185.04	1088222.0
2019-08-28 12:00:00	QQQ	ETF	185.03	185.11	184.82	184.86	513869.0
2019-08-28 12:30:00	QQQ	ETF	184.865	185.055	184.67	185.04	722343.0

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

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