PREVIEW / etf_30min / 2020-02-28

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-02-28.parquet
  size:    653 KB
  rows:    24,046

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
2020-02-28 04:00:00	SPY	ETF	291.67	291.73	288.64	288.94	225132.0
2020-02-28 04:30:00	SPY	ETF	288.6	291.91	288.1	290.64	190611.0
2020-02-28 05:00:00	SPY	ETF	290.5	293.66	290.05	293.45	167564.0
2020-02-28 05:30:00	SPY	ETF	293.45	293.53	291.9	293.45	111092.0
2020-02-28 06:00:00	SPY	ETF	293.4	294.0	292.76	292.79	188706.0
2020-02-28 06:30:00	SPY	ETF	292.8	294.13	292.39	292.55	301080.0
2020-02-28 07:00:00	SPY	ETF	292.65	295.0	291.9	294.7	669969.0
2020-02-28 07:30:00	SPY	ETF	294.67	295.4	293.18	294.33	913569.0
2020-02-28 08:00:00	SPY	ETF	294.35	295.28	290.0	293.35	953042.0
2020-02-28 08:30:00	SPY	ETF	293.18	297.51	290.07	290.13	2029742.0
2020-02-28 09:00:00	SPY	ETF	290.1	291.58	287.38	288.74	3374897.0
2020-02-28 09:30:00	SPY	ETF	288.7	293.2	286.7	287.57	43510470.0
2020-02-28 10:00:00	SPY	ETF	287.56	289.44	285.54	286.42	30576242.0
2020-02-28 10:30:00	SPY	ETF	286.41	290.54	286.26	289.95	26658139.0
2020-02-28 11:00:00	SPY	ETF	289.96	297.892	287.5	291.31	20670399.0
2020-02-28 11:30:00	SPY	ETF	291.315	296.14	290.6	291.74	28293001.0
2020-02-28 12:00:00	SPY	ETF	291.75	293.04	290.0	292.94	18254883.0
2020-02-28 12:30:00	SPY	ETF	292.96	294.77	291.74	294.55	14640337.0
2020-02-28 13:00:00	SPY	ETF	294.54	295.1	292.27	292.75	16129666.0
2020-02-28 13:30:00	SPY	ETF	292.74	292.76	288.82	290.235	20811621.0
2020-02-28 14:00:00	SPY	ETF	290.23	291.14	288.03	290.2	16448365.0
2020-02-28 14:30:00	SPY	ETF	290.19	294.25	289.66	291.65	26414273.0
2020-02-28 15:00:00	SPY	ETF	291.69	292.64	288.83	288.83	19478673.0
2020-02-28 15:30:00	SPY	ETF	288.83	296.33	288.06	296.16	50152172.0
2020-02-28 16:00:00	SPY	ETF	296.12	298.98	295.4314	297.35	29383405.0
2020-02-28 16:30:00	SPY	ETF	297.35	299.7	295.4435	299.04	5241671.0
2020-02-28 17:00:00	SPY	ETF	298.95	299.1	296.26	298.23	1063219.0
2020-02-28 17:30:00	SPY	ETF	298.23	298.85	296.26	298.76	460789.0
2020-02-28 18:00:00	SPY	ETF	298.84	299.24	298.8	298.93	99978.0
2020-02-28 18:30:00	SPY	ETF	298.92	299.35	296.26	298.9	659459.0
2020-02-28 19:00:00	SPY	ETF	298.95	299.1	298.89	298.98	23252.0
2020-02-28 19:30:00	SPY	ETF	299.01	299.1	298.74	298.85	59466.0
2020-02-28 04:00:00	QQQ	ETF	201.36	201.47	198.73	198.98	186418.0
2020-02-28 04:30:00	QQQ	ETF	198.82	201.27	198.24	200.3	190768.0
2020-02-28 05:00:00	QQQ	ETF	200.2	202.43	199.95	202.4	107269.0
2020-02-28 05:30:00	QQQ	ETF	202.45	202.58	201.18	202.36	65157.0
2020-02-28 06:00:00	QQQ	ETF	202.38	203.1	202.16	202.2	120466.0
2020-02-28 06:30:00	QQQ	ETF	202.39	203.33	202.18	202.47	132112.0
2020-02-28 07:00:00	QQQ	ETF	202.43	204.07	201.79	203.83	506129.0
2020-02-28 07:30:00	QQQ	ETF	203.96	204.43	202.63	203.34	319912.0
2020-02-28 08:00:00	QQQ	ETF	203.3	204.3101	199.21	202.81	512717.0
2020-02-28 08:30:00	QQQ	ETF	202.84	205.64	200.05	200.0599	933046.0
2020-02-28 09:00:00	QQQ	ETF	200.02	201.32	198.23	199.0	1333444.0
2020-02-28 09:30:00	QQQ	ETF	198.92	202.92	198.17	199.56	18887183.0
2020-02-28 10:00:00	QQQ	ETF	199.54	201.38	198.39	199.369	12589802.0
2020-02-28 10:30:00	QQQ	ETF	199.34	202.26	199.24	202.07	8142282.0
2020-02-28 11:00:00	QQQ	ETF	202.09	203.37	200.01	203.37	7147668.0
2020-02-28 11:30:00	QQQ	ETF	203.36	207.17	202.59	203.67	10449281.0
2020-02-28 12:00:00	QQQ	ETF	203.67	204.38	202.27	204.3199	5344917.0
2020-02-28 12:30:00	QQQ	ETF	204.348	205.52	203.33	205.3	5835612.0

> showing 50 of 24,046 rows — these rows as CSV

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