PREVIEW / etf_30min / 2020-04-09

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-04-09.parquet
  size:    601 KB
  rows:    22,234

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-09 04:00:00	SPY	ETF	276.56	277.06	274.94	274.94	98627.0
2020-04-09 04:30:00	SPY	ETF	274.97	275.25	273.84	273.84	72032.0
2020-04-09 05:00:00	SPY	ETF	273.81	274.33	273.14	274.01	66650.0
2020-04-09 05:30:00	SPY	ETF	274.04	274.29	272.87	273.19	59592.0
2020-04-09 06:00:00	SPY	ETF	272.96	273.76	272.34	272.86	66502.0
2020-04-09 06:30:00	SPY	ETF	272.66	273.01	271.76	272.76	119631.0
2020-04-09 07:00:00	SPY	ETF	272.8	274.01	271.55	271.59	471129.0
2020-04-09 07:30:00	SPY	ETF	271.51	272.65	271.15	271.86	638532.0
2020-04-09 08:00:00	SPY	ETF	274.0	277.21	270.4	271.66	1195219.0
2020-04-09 08:30:00	SPY	ETF	271.83	277.26	271.1	276.94	4900136.0
2020-04-09 09:00:00	SPY	ETF	276.93	278.73	276.57	277.6	5136467.0
2020-04-09 09:30:00	SPY	ETF	277.58	280.61	276.86	280.51	21649991.0
2020-04-09 10:00:00	SPY	ETF	280.51	280.58	277.06	279.18	20545873.0
2020-04-09 10:30:00	SPY	ETF	279.15	280.2	278.25	279.36	13574110.0
2020-04-09 11:00:00	SPY	ETF	279.35	279.43	277.12	278.53	9360968.0
2020-04-09 11:30:00	SPY	ETF	278.53	279.77	278.03	279.43	7793322.0
2020-04-09 12:00:00	SPY	ETF	279.44	280.33	279.21	279.36	7412410.0
2020-04-09 12:30:00	SPY	ETF	279.37	280.96	279.12	280.591	8661489.0
2020-04-09 13:00:00	SPY	ETF	280.6	280.92	279.9	280.8502	7364459.0
2020-04-09 13:30:00	SPY	ETF	280.8662	281.2	278.88	279.89	10517666.0
2020-04-09 14:00:00	SPY	ETF	279.87	279.98	277.5	277.85	11549117.0
2020-04-09 14:30:00	SPY	ETF	277.84	279.58	275.47	276.585	12871260.0
2020-04-09 15:00:00	SPY	ETF	276.58	278.22	276.0	278.2	11633673.0
2020-04-09 15:30:00	SPY	ETF	278.21	278.935	277.07	278.24	19735731.0
2020-04-09 16:00:00	SPY	ETF	278.25	278.76	277.7311	278.25	11823706.0
2020-04-09 16:30:00	SPY	ETF	278.25	279.35	278.13	279.03	1131671.0
2020-04-09 17:00:00	SPY	ETF	279.03	279.03	278.66	278.68	609557.0
2020-04-09 17:30:00	SPY	ETF	278.68	278.84	278.2	278.8	149740.0
2020-04-09 18:00:00	SPY	ETF	278.83	279.29	278.2	278.9	94646.0
2020-04-09 18:30:00	SPY	ETF	278.89	279.08	278.68	278.82	119416.0
2020-04-09 19:00:00	SPY	ETF	278.8	279.07	278.8	278.98	44110.0
2020-04-09 19:30:00	SPY	ETF	279.0	279.19	278.92	279.0	71872.0
2020-04-09 04:00:00	QQQ	ETF	201.62	201.7	200.31	200.32	42161.0
2020-04-09 04:30:00	QQQ	ETF	200.45	200.64	199.71	199.9	105173.0
2020-04-09 05:00:00	QQQ	ETF	199.77	200.14	199.18	199.88	81152.0
2020-04-09 05:30:00	QQQ	ETF	199.83	200.0	199.07	199.29	14920.0
2020-04-09 06:00:00	QQQ	ETF	199.12	199.64	198.9	199.11	40624.0
2020-04-09 06:30:00	QQQ	ETF	199.06	199.26	198.52	199.25	41148.0
2020-04-09 07:00:00	QQQ	ETF	199.29	200.05	198.6	198.61	117267.0
2020-04-09 07:30:00	QQQ	ETF	198.51	199.18	198.24	198.72	138910.0
2020-04-09 08:00:00	QQQ	ETF	199.46	201.82	197.85	198.79	269088.0
2020-04-09 08:30:00	QQQ	ETF	199.31	201.97	198.74	201.79	847351.0
2020-04-09 09:00:00	QQQ	ETF	201.79	202.92	201.57	202.28	677860.0
2020-04-09 09:30:00	QQQ	ETF	202.23	203.22	201.07	202.8	7169059.0
2020-04-09 10:00:00	QQQ	ETF	202.79	202.81	199.11	200.4	8058239.0
2020-04-09 10:30:00	QQQ	ETF	200.43	201.2	199.69	200.84	5331061.0
2020-04-09 11:00:00	QQQ	ETF	200.84	200.87	199.31	200.34	4177927.0
2020-04-09 11:30:00	QQQ	ETF	200.34	201.44	200.09	201.1615	2886132.0
2020-04-09 12:00:00	QQQ	ETF	201.18	201.83	200.99	201.0301	2234321.0
2020-04-09 12:30:00	QQQ	ETF	201.02	202.16	200.71	201.94	1873621.0

> showing 50 of 22,234 rows — these rows as CSV

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