PREVIEW / etf_30min / 2020-04-24

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-04-24.parquet
  size:    549 KB
  rows:    19,875

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-24 04:00:00	SPY	ETF	278.25	278.27	277.18	277.43	36256.0
2020-04-24 04:30:00	SPY	ETF	277.43	277.93	277.3	277.86	25015.0
2020-04-24 05:00:00	SPY	ETF	277.95	279.73	277.95	279.39	90351.0
2020-04-24 05:30:00	SPY	ETF	279.33	279.96	279.09	279.58	136188.0
2020-04-24 06:00:00	SPY	ETF	279.64	280.2	279.32	279.7	60118.0
2020-04-24 06:30:00	SPY	ETF	279.72	280.85	279.6	280.85	143396.0
2020-04-24 07:00:00	SPY	ETF	280.8	280.98	280.35	280.66	199672.0
2020-04-24 07:30:00	SPY	ETF	280.66	280.66	279.83	279.95	219385.0
2020-04-24 08:00:00	SPY	ETF	280.9399	280.9399	276.13	280.2	518687.0
2020-04-24 08:30:00	SPY	ETF	280.1999	281.43	280.1999	280.7	571561.0
2020-04-24 09:00:00	SPY	ETF	280.72	281.1199	280.59	280.71	391300.0
2020-04-24 09:30:00	SPY	ETF	280.73	281.29	278.77	278.86	6852655.0
2020-04-24 10:00:00	SPY	ETF	278.89	280.91	278.81	279.46	5191923.0
2020-04-24 10:30:00	SPY	ETF	279.48	280.39	279.21	279.59	3660618.0
2020-04-24 11:00:00	SPY	ETF	279.59	279.6599	278.5	279.135	6812186.0
2020-04-24 11:30:00	SPY	ETF	279.14	279.73	278.675	279.3501	5441740.0
2020-04-24 12:00:00	SPY	ETF	279.35	280.41	279.06	279.9957	2932757.0
2020-04-24 12:30:00	SPY	ETF	280.0	280.52	279.75	280.22	3734224.0
2020-04-24 13:00:00	SPY	ETF	280.2127	280.32	279.78	280.31	2403690.0
2020-04-24 13:30:00	SPY	ETF	280.31	281.56	280.08	281.52	4685242.0
2020-04-24 14:00:00	SPY	ETF	281.51	281.95	281.24	281.64	4806221.0
2020-04-24 14:30:00	SPY	ETF	281.64	282.52	281.535	282.21	4805812.0
2020-04-24 15:00:00	SPY	ETF	282.21	282.93	281.81	282.92	5428168.0
2020-04-24 15:30:00	SPY	ETF	282.94	283.7	282.48	283.04	16104765.0
2020-04-24 16:00:00	SPY	ETF	283.05	283.35	282.77	283.0	8165100.0
2020-04-24 16:30:00	SPY	ETF	283.04	283.15	282.95	283.0	489404.0
2020-04-24 17:00:00	SPY	ETF	283.01	283.05	282.82	282.95	288849.0
2020-04-24 17:30:00	SPY	ETF	282.96	283.25	282.96	283.25	60560.0
2020-04-24 18:00:00	SPY	ETF	283.2499	283.2499	283.03	283.15	25849.0
2020-04-24 18:30:00	SPY	ETF	283.15	283.2	282.97	283.12	25734.0
2020-04-24 19:00:00	SPY	ETF	283.15	283.15	283.0	283.0	14117.0
2020-04-24 19:30:00	SPY	ETF	283.0	283.35	283.0	283.35	52185.0
2020-04-24 04:00:00	QQQ	ETF	209.5	209.5	208.55	208.8	20304.0
2020-04-24 04:30:00	QQQ	ETF	208.7	209.15	208.68	208.98	141817.0
2020-04-24 05:00:00	QQQ	ETF	209.27	210.52	209.24	210.33	32358.0
2020-04-24 05:30:00	QQQ	ETF	210.3	210.72	210.23	210.45	17699.0
2020-04-24 06:00:00	QQQ	ETF	210.4	210.7	210.22	210.46	9087.0
2020-04-24 06:30:00	QQQ	ETF	210.62	211.42	210.35	211.42	24598.0
2020-04-24 07:00:00	QQQ	ETF	211.4	211.43	210.99	211.29	111804.0
2020-04-24 07:30:00	QQQ	ETF	211.3	211.3	210.62	210.74	75669.0
2020-04-24 08:00:00	QQQ	ETF	211.09	211.39	208.0	210.8	115256.0
2020-04-24 08:30:00	QQQ	ETF	210.9	211.68	210.88	211.25	146939.0
2020-04-24 09:00:00	QQQ	ETF	211.23	211.43	210.9	210.94	265811.0
2020-04-24 09:30:00	QQQ	ETF	210.94	211.53	209.5	209.61	3965287.0
2020-04-24 10:00:00	QQQ	ETF	209.61	211.19	209.61	210.79	3058048.0
2020-04-24 10:30:00	QQQ	ETF	210.78	211.6	210.6	210.83	2278883.0
2020-04-24 11:00:00	QQQ	ETF	210.8	211.1	210.13	210.76	1991979.0
2020-04-24 11:30:00	QQQ	ETF	210.7699	211.3	210.37	211.07	1480982.0
2020-04-24 12:00:00	QQQ	ETF	211.052	211.82	210.75	211.7743	1708230.0
2020-04-24 12:30:00	QQQ	ETF	211.77	212.17	211.6	211.925	1522006.0

> showing 50 of 19,875 rows — these rows as CSV

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