PREVIEW / etf_30min / 2019-08-08

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-08-08.parquet
  size:    521 KB
  rows:    18,038

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-08 04:00:00	SPY	ETF	288.7	288.71	287.88	288.42	16009.0
2019-08-08 04:30:00	SPY	ETF	288.55	288.82	288.4	288.63	5582.0
2019-08-08 05:00:00	SPY	ETF	288.62	289.04	288.4	288.6	15908.0
2019-08-08 05:30:00	SPY	ETF	288.6	288.9	288.58	288.74	6101.0
2019-08-08 06:00:00	SPY	ETF	288.87	289.1	288.87	289.07	4946.0
2019-08-08 06:30:00	SPY	ETF	288.95	288.95	288.4	288.45	14107.0
2019-08-08 07:00:00	SPY	ETF	288.41	288.48	288.1	288.46	120295.0
2019-08-08 07:30:00	SPY	ETF	288.39	288.59	288.1	288.4	157117.0
2019-08-08 08:00:00	SPY	ETF	288.41	289.14	288.1001	288.58	412420.0
2019-08-08 08:30:00	SPY	ETF	288.52	289.08	288.42	289.03	350974.0
2019-08-08 09:00:00	SPY	ETF	289.04	289.77	287.97	289.7	2585847.0
2019-08-08 09:30:00	SPY	ETF	289.62	290.34	289.01	290.1284	8057688.0
2019-08-08 10:00:00	SPY	ETF	290.15	290.71	290.07	290.6	6586031.0
2019-08-08 10:30:00	SPY	ETF	290.6	291.4563	290.5957	291.31	5117996.0
2019-08-08 11:00:00	SPY	ETF	291.315	291.7	290.88	291.47	4913336.0
2019-08-08 11:30:00	SPY	ETF	291.4799	292.19	291.41	292.13	4204751.0
2019-08-08 12:00:00	SPY	ETF	292.12	292.62	292.0	292.47	4834793.0
2019-08-08 12:30:00	SPY	ETF	292.47	292.86	292.43	292.84	4873348.0
2019-08-08 13:00:00	SPY	ETF	292.85	293.02	292.23	292.25	3717773.0
2019-08-08 13:30:00	SPY	ETF	292.25	292.92	292.25	292.64	2209664.0
2019-08-08 14:00:00	SPY	ETF	292.64	292.66	292.135	292.41	3388195.0
2019-08-08 14:30:00	SPY	ETF	292.41	292.85	292.15	292.65	4239876.0
2019-08-08 15:00:00	SPY	ETF	292.645	292.99	292.32	292.51	3942531.0
2019-08-08 15:30:00	SPY	ETF	292.53	293.56	292.47	293.55	14602300.0
2019-08-08 16:00:00	SPY	ETF	293.56	293.72	288.8425	293.69	8422932.0
2019-08-08 16:30:00	SPY	ETF	293.66	293.75	293.52	293.57	394329.0
2019-08-08 17:00:00	SPY	ETF	293.58	293.62	292.05	292.61	960594.0
2019-08-08 17:30:00	SPY	ETF	292.61	292.97	292.6	292.7	199512.0
2019-08-08 18:00:00	SPY	ETF	292.61	292.87	291.4	291.6	537333.0
2019-08-08 18:30:00	SPY	ETF	291.63	292.22	291.29	292.2	126473.0
2019-08-08 19:00:00	SPY	ETF	292.14	292.29	291.82	291.91	29526.0
2019-08-08 19:30:00	SPY	ETF	291.91	293.19	291.85	293.12	182550.0
2019-08-08 04:00:00	QQQ	ETF	184.77	184.82	184.11	184.53	59708.0
2019-08-08 04:30:00	QQQ	ETF	184.62	184.86	184.55	184.74	39330.0
2019-08-08 05:00:00	QQQ	ETF	184.78	185.0	184.59	184.75	26503.0
2019-08-08 05:30:00	QQQ	ETF	184.78	184.98	184.63	184.9	14220.0
2019-08-08 06:00:00	QQQ	ETF	184.99	185.19	184.99	184.99	9319.0
2019-08-08 06:30:00	QQQ	ETF	185.03	185.03	184.64	184.7	22813.0
2019-08-08 07:00:00	QQQ	ETF	184.69	184.77	184.46	184.75	75332.0
2019-08-08 07:30:00	QQQ	ETF	184.75	184.85	184.39	184.65	98482.0
2019-08-08 08:00:00	QQQ	ETF	184.7301	185.15	184.47	184.79	133077.0
2019-08-08 08:30:00	QQQ	ETF	184.75	185.05	184.69	184.91	110398.0
2019-08-08 09:00:00	QQQ	ETF	184.92	185.53	184.92	185.15	305287.0
2019-08-08 09:30:00	QQQ	ETF	185.15	185.725	184.57	185.568	4532280.0
2019-08-08 10:00:00	QQQ	ETF	185.57	186.1	185.48	186.02	2907318.0
2019-08-08 10:30:00	QQQ	ETF	186.0165	186.77	186.0165	186.69	2525333.0
2019-08-08 11:00:00	QQQ	ETF	186.685	186.9	186.36	186.64	1308542.0
2019-08-08 11:30:00	QQQ	ETF	186.635	187.23	186.58	187.155	1758461.0
2019-08-08 12:00:00	QQQ	ETF	187.16	187.41	186.96	187.33	1625616.0
2019-08-08 12:30:00	QQQ	ETF	187.33	187.58	187.3	187.5	1129929.0

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

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