PREVIEW / etf_30min / 2019-10-10

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-10-10.parquet
  size:    510 KB
  rows:    17,590

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-10 04:00:00	SPY	ETF	290.49	291.49	290.44	291.31	27006.0
2019-10-10 04:30:00	SPY	ETF	291.2	291.24	290.94	290.94	8972.0
2019-10-10 05:00:00	SPY	ETF	291.14	291.23	290.87	290.94	13324.0
2019-10-10 05:30:00	SPY	ETF	290.9	291.19	290.8	291.15	8226.0
2019-10-10 06:00:00	SPY	ETF	291.15	291.73	291.15	291.29	31109.0
2019-10-10 06:30:00	SPY	ETF	291.27	291.46	290.89	290.99	36604.0
2019-10-10 07:00:00	SPY	ETF	290.96	291.05	290.66	290.78	115181.0
2019-10-10 07:30:00	SPY	ETF	290.78	290.8	290.36	290.62	247386.0
2019-10-10 08:00:00	SPY	ETF	290.76	291.24	290.22	290.67	141525.0
2019-10-10 08:30:00	SPY	ETF	290.74	291.16	290.74	291.03	216064.0
2019-10-10 09:00:00	SPY	ETF	291.01	291.45	290.83	291.17	800098.0
2019-10-10 09:30:00	SPY	ETF	291.18	293.28	291.0	293.17	8278238.0
2019-10-10 10:00:00	SPY	ETF	293.19	293.31	292.565	293.07	5460011.0
2019-10-10 10:30:00	SPY	ETF	293.065	293.7922	292.86	293.7901	3135339.0
2019-10-10 11:00:00	SPY	ETF	293.8	294.21	293.63	293.96	3131146.0
2019-10-10 11:30:00	SPY	ETF	293.96	294.13	293.78	293.99	2118793.0
2019-10-10 12:00:00	SPY	ETF	293.98	294.04	293.26	293.27	2196113.0
2019-10-10 12:30:00	SPY	ETF	293.28	293.3	292.76	293.27	2914590.0
2019-10-10 13:00:00	SPY	ETF	293.27	293.32	292.96	293.05	2148923.0
2019-10-10 13:30:00	SPY	ETF	293.04	293.66	292.61	293.4	2864870.0
2019-10-10 14:00:00	SPY	ETF	293.4	293.55	292.04	292.87	4834521.0
2019-10-10 14:30:00	SPY	ETF	292.86	293.17	292.57	292.8352	2950444.0
2019-10-10 15:00:00	SPY	ETF	292.83	293.31	292.74	293.305	2535659.0
2019-10-10 15:30:00	SPY	ETF	293.305	293.5	292.86	293.24	8412920.0
2019-10-10 16:00:00	SPY	ETF	293.25	293.64	293.1562	293.5	2181243.0
2019-10-10 16:30:00	SPY	ETF	293.5	294.75	293.5	294.32	1337656.0
2019-10-10 17:00:00	SPY	ETF	294.3	294.59	294.29	294.4	92962.0
2019-10-10 17:30:00	SPY	ETF	294.37	294.37	294.16	294.18	80263.0
2019-10-10 18:00:00	SPY	ETF	294.3	294.43	293.83	293.96	151110.0
2019-10-10 18:30:00	SPY	ETF	293.95	295.1	293.95	294.28	209897.0
2019-10-10 19:00:00	SPY	ETF	294.23	294.31	293.98	294.02	46109.0
2019-10-10 19:30:00	SPY	ETF	294.02	294.13	293.7	294.13	74917.0
2019-10-10 04:00:00	QQQ	ETF	186.79	187.47	186.65	187.45	34437.0
2019-10-10 04:30:00	QQQ	ETF	187.28	187.37	187.18	187.19	6000.0
2019-10-10 05:00:00	QQQ	ETF	187.26	187.35	187.02	187.02	7773.0
2019-10-10 05:30:00	QQQ	ETF	187.04	187.26	187.01	187.25	6132.0
2019-10-10 06:00:00	QQQ	ETF	187.19	187.71	187.19	187.34	38481.0
2019-10-10 06:30:00	QQQ	ETF	187.36	187.52	187.16	187.26	21526.0
2019-10-10 07:00:00	QQQ	ETF	187.2	187.22	186.94	187.05	73843.0
2019-10-10 07:30:00	QQQ	ETF	187.05	187.05	186.59	186.93	283956.0
2019-10-10 08:00:00	QQQ	ETF	187.0	187.44	186.6	187.01	64427.0
2019-10-10 08:30:00	QQQ	ETF	187.09	187.33	187.09	187.16	206236.0
2019-10-10 09:00:00	QQQ	ETF	187.16	187.47	187.01	187.27	467755.0
2019-10-10 09:30:00	QQQ	ETF	187.27	188.85	187.12	188.72	4739971.0
2019-10-10 10:00:00	QQQ	ETF	188.73	188.88	188.38	188.635	2066286.0
2019-10-10 10:30:00	QQQ	ETF	188.64	189.17	188.52	189.15	1072018.0
2019-10-10 11:00:00	QQQ	ETF	189.16	189.43	189.02	189.26	1068785.0
2019-10-10 11:30:00	QQQ	ETF	189.25	189.35	189.11	189.19	928290.0
2019-10-10 12:00:00	QQQ	ETF	189.19	189.22	188.5	188.52	913694.0
2019-10-10 12:30:00	QQQ	ETF	188.51	188.56	188.13	188.53	930711.0

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

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