PREVIEW / etf_30min / 2020-04-29

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-04-29.parquet
  size:    584 KB
  rows:    21,303

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-04-29 04:00:00	SPY	ETF	289.47	289.48	288.81	289.07	45887.0
2020-04-29 04:30:00	SPY	ETF	289.06	289.69	289.04	289.69	12252.0
2020-04-29 05:00:00	SPY	ETF	289.66	289.87	289.63	289.87	10942.0
2020-04-29 05:30:00	SPY	ETF	289.82	289.84	289.32	289.5	8933.0
2020-04-29 06:00:00	SPY	ETF	289.57	289.57	288.82	288.82	22406.0
2020-04-29 06:30:00	SPY	ETF	288.79	289.35	288.6	289.35	148305.0
2020-04-29 07:00:00	SPY	ETF	289.32	289.53	288.53	288.61	759069.0
2020-04-29 07:30:00	SPY	ETF	288.6	288.92	288.21	288.46	264712.0
2020-04-29 08:00:00	SPY	ETF	289.13	290.63	288.2	289.66	615466.0
2020-04-29 08:30:00	SPY	ETF	289.81	292.5	289.72	292.33	4342194.0
2020-04-29 09:00:00	SPY	ETF	292.33	292.88	291.5	291.53	1658373.0
2020-04-29 09:30:00	SPY	ETF	291.53	292.04	290.41	291.98	11843644.0
2020-04-29 10:00:00	SPY	ETF	291.96	292.1	290.8	292.0801	8970592.0
2020-04-29 10:30:00	SPY	ETF	292.1	292.67	291.76	292.39	5981192.0
2020-04-29 11:00:00	SPY	ETF	292.39	292.97	291.91	292.78	6357683.0
2020-04-29 11:30:00	SPY	ETF	292.78	293.14	292.28	292.8899	6378554.0
2020-04-29 12:00:00	SPY	ETF	292.8843	293.66	292.8843	293.59	5494072.0
2020-04-29 12:30:00	SPY	ETF	293.59	294.37	293.58	293.94	5214640.0
2020-04-29 13:00:00	SPY	ETF	293.95	294.58	293.95	294.01	4812058.0
2020-04-29 13:30:00	SPY	ETF	294.0	294.1	293.38	293.69	5198935.0
2020-04-29 14:00:00	SPY	ETF	293.69	294.07	292.51	293.4199	8648894.0
2020-04-29 14:30:00	SPY	ETF	293.415	294.12	293.02	293.97	7259881.0
2020-04-29 15:00:00	SPY	ETF	293.99	294.87	293.87	294.79	7129470.0
2020-04-29 15:30:00	SPY	ETF	294.8	294.88	293.08	293.19	18724222.0
2020-04-29 16:00:00	SPY	ETF	293.19	294.78	293.09	294.7	4777264.0
2020-04-29 16:30:00	SPY	ETF	294.7	296.1	294.48	296.0	1235689.0
2020-04-29 17:00:00	SPY	ETF	296.02	296.02	295.18	295.68	380477.0
2020-04-29 17:30:00	SPY	ETF	295.62	295.87	293.21	295.82	157276.0
2020-04-29 18:00:00	SPY	ETF	295.86	295.86	294.86	295.05	353452.0
2020-04-29 18:30:00	SPY	ETF	295.05	295.26	295.0	295.12	47417.0
2020-04-29 19:00:00	SPY	ETF	295.12	295.12	294.64	294.71	106122.0
2020-04-29 19:30:00	SPY	ETF	294.75	295.22	294.71	294.8	166182.0
2020-04-29 04:00:00	QQQ	ETF	215.23	215.25	214.91	215.05	22280.0
2020-04-29 04:30:00	QQQ	ETF	215.02	215.42	215.02	215.29	15712.0
2020-04-29 05:00:00	QQQ	ETF	215.3	215.43	215.14	215.37	9182.0
2020-04-29 05:30:00	QQQ	ETF	215.31	215.38	214.98	215.08	3104.0
2020-04-29 06:00:00	QQQ	ETF	215.08	215.08	214.68	214.68	13630.0
2020-04-29 06:30:00	QQQ	ETF	214.6	215.09	214.6	215.09	24953.0
2020-04-29 07:00:00	QQQ	ETF	215.09	215.13	214.38	214.44	94176.0
2020-04-29 07:30:00	QQQ	ETF	214.38	214.58	214.1	214.37	157299.0
2020-04-29 08:00:00	QQQ	ETF	215.08	215.79	214.1398	215.36	127406.0
2020-04-29 08:30:00	QQQ	ETF	215.36	217.04	215.36	216.91	871355.0
2020-04-29 09:00:00	QQQ	ETF	216.97	217.36	216.23	216.23	821968.0
2020-04-29 09:30:00	QQQ	ETF	216.23	217.157	215.14	217.03	5137555.0
2020-04-29 10:00:00	QQQ	ETF	217.025	217.95	216.3701	217.908	3289662.0
2020-04-29 10:30:00	QQQ	ETF	217.91	218.135	217.35	217.67	2550748.0
2020-04-29 11:00:00	QQQ	ETF	217.67	217.995	217.2801	217.77	1834497.0
2020-04-29 11:30:00	QQQ	ETF	217.77	217.99	217.43	217.54	2493754.0
2020-04-29 12:00:00	QQQ	ETF	217.55	218.43	217.55	218.407	1344784.0
2020-04-29 12:30:00	QQQ	ETF	218.42	218.72	218.23	218.34	1511005.0

> showing 50 of 21,303 rows — these rows as CSV

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