PREVIEW / etf_30min / 2019-10-04

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-10-04.parquet
  size:    501 KB
  rows:    17,060

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-10-04 04:00:00	SPY	ETF	290.25	290.33	290.0	290.0	20401.0
2019-10-04 04:30:00	SPY	ETF	290.0	290.05	289.75	289.82	11630.0
2019-10-04 05:00:00	SPY	ETF	289.8	289.88	289.71	289.74	3322.0
2019-10-04 05:30:00	SPY	ETF	289.59	289.59	289.36	289.4	18580.0
2019-10-04 06:00:00	SPY	ETF	289.4	289.74	289.4	289.45	34622.0
2019-10-04 06:30:00	SPY	ETF	289.53	289.6	289.2	289.44	40308.0
2019-10-04 07:00:00	SPY	ETF	289.36	289.48	289.3	289.43	104733.0
2019-10-04 07:30:00	SPY	ETF	289.44	289.73	289.39	289.53	182924.0
2019-10-04 08:00:00	SPY	ETF	289.4301	291.06	289.1	289.3	512541.0
2019-10-04 08:30:00	SPY	ETF	289.55	291.43	289.43	291.24	1637198.0
2019-10-04 09:00:00	SPY	ETF	291.2	291.35	290.98	291.2	402556.0
2019-10-04 09:30:00	SPY	ETF	291.14	292.3	291.08	292.29	5943671.0
2019-10-04 10:00:00	SPY	ETF	292.28	292.7	291.92	291.92	4697083.0
2019-10-04 10:30:00	SPY	ETF	291.91	292.13	291.39	291.85	4288681.0
2019-10-04 11:00:00	SPY	ETF	291.86	292.55	291.65	292.51	2980457.0
2019-10-04 11:30:00	SPY	ETF	292.505	293.14	292.35	292.9	4665692.0
2019-10-04 12:00:00	SPY	ETF	292.895	293.12	292.7433	292.905	1501280.0
2019-10-04 12:30:00	SPY	ETF	292.91	293.06	292.81	292.91	1640460.0
2019-10-04 13:00:00	SPY	ETF	292.91	293.03	292.75	293.02	1203647.0
2019-10-04 13:30:00	SPY	ETF	293.03	293.36	292.95	293.03	1751388.0
2019-10-04 14:00:00	SPY	ETF	293.04	293.55	292.93	293.49	2316849.0
2019-10-04 14:30:00	SPY	ETF	293.48	293.72	293.46	293.574	2115390.0
2019-10-04 15:00:00	SPY	ETF	293.58	293.9	293.51	293.72	2524114.0
2019-10-04 15:30:00	SPY	ETF	293.725	294.63	293.675	294.37	15071412.0
2019-10-04 16:00:00	SPY	ETF	294.37	294.55	294.19	294.32	10347776.0
2019-10-04 16:30:00	SPY	ETF	294.31	294.44	294.27	294.42	648814.0
2019-10-04 17:00:00	SPY	ETF	294.32	294.4	294.22	294.4	500427.0
2019-10-04 17:30:00	SPY	ETF	294.41	294.45	294.35	294.4	351173.0
2019-10-04 18:00:00	SPY	ETF	294.43	294.46	294.35	294.38	112713.0
2019-10-04 18:30:00	SPY	ETF	294.39	294.43	294.38	294.4	4430.0
2019-10-04 19:00:00	SPY	ETF	294.4	294.44	294.39	294.44	2704.0
2019-10-04 19:30:00	SPY	ETF	294.4	294.65	294.4	294.65	16200.0
2019-10-04 04:00:00	QQQ	ETF	186.13	186.33	186.11	186.11	11600.0
2019-10-04 04:30:00	QQQ	ETF	186.11	186.13	185.85	185.93	13890.0
2019-10-04 05:00:00	QQQ	ETF	185.95	185.95	185.82	185.84	18882.0
2019-10-04 05:30:00	QQQ	ETF	185.83	185.83	185.53	185.58	38399.0
2019-10-04 06:00:00	QQQ	ETF	185.61	185.81	185.6	185.73	13370.0
2019-10-04 06:30:00	QQQ	ETF	185.73	185.77	185.5	185.67	19680.0
2019-10-04 07:00:00	QQQ	ETF	185.71	185.75	185.57	185.69	58321.0
2019-10-04 07:30:00	QQQ	ETF	185.69	185.93	185.68	185.82	103856.0
2019-10-04 08:00:00	QQQ	ETF	185.84	186.75	185.56	185.77	116763.0
2019-10-04 08:30:00	QQQ	ETF	185.9	187.18	185.78	187.09	1171845.0
2019-10-04 09:00:00	QQQ	ETF	187.0	187.12	186.84	187.01	106660.0
2019-10-04 09:30:00	QQQ	ETF	186.99	187.75	186.88	187.73	6083648.0
2019-10-04 10:00:00	QQQ	ETF	187.73	187.96	187.37	187.38	2494443.0
2019-10-04 10:30:00	QQQ	ETF	187.36	187.66	187.03	187.46	1357633.0
2019-10-04 11:00:00	QQQ	ETF	187.475	187.91	187.3	187.82	1764333.0
2019-10-04 11:30:00	QQQ	ETF	187.825	188.4	187.8	188.2	1944343.0
2019-10-04 12:00:00	QQQ	ETF	188.2	188.34	188.04	188.14	992646.0
2019-10-04 12:30:00	QQQ	ETF	188.13	188.28	188.06	188.13	627970.0

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

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