PREVIEW / etf_30min / 2021-05-26

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-05-26.parquet
  size:    592 KB
  rows:    22,734

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
2021-05-26 04:00:00	SPY	ETF	419.33	419.65	419.33	419.59	11058.0
2021-05-26 04:30:00	SPY	ETF	419.57	419.57	419.25	419.25	3400.0
2021-05-26 05:00:00	SPY	ETF	419.33	419.84	419.33	419.84	1700.0
2021-05-26 05:30:00	SPY	ETF	419.91	420.02	419.4	419.4	5820.0
2021-05-26 06:00:00	SPY	ETF	419.4	419.5	419.34	419.35	1917.0
2021-05-26 06:30:00	SPY	ETF	419.45	419.45	419.33	419.45	4378.0
2021-05-26 07:00:00	SPY	ETF	419.43	420.0	419.4	419.77	64819.0
2021-05-26 07:30:00	SPY	ETF	419.72	419.72	419.33	419.39	44593.0
2021-05-26 08:00:00	SPY	ETF	419.4296	419.97	419.16	419.75	62827.0
2021-05-26 08:30:00	SPY	ETF	419.732	419.732	419.0	419.19	140949.0
2021-05-26 09:00:00	SPY	ETF	419.28	419.32	418.77	418.87	132876.0
2021-05-26 09:30:00	SPY	ETF	418.87	419.19	417.81	417.9	3893966.0
2021-05-26 10:00:00	SPY	ETF	417.91	418.95	417.76	418.7311	2658869.0
2021-05-26 10:30:00	SPY	ETF	418.76	418.96	418.56	418.9099	2149162.0
2021-05-26 11:00:00	SPY	ETF	418.91	419.35	418.785	418.96	2100938.0
2021-05-26 11:30:00	SPY	ETF	418.95	419.34	418.69	419.26	1889963.0
2021-05-26 12:00:00	SPY	ETF	419.26	419.45	419.1701	419.2901	1478876.0
2021-05-26 12:30:00	SPY	ETF	419.2943	419.49	419.22	419.3819	968644.0
2021-05-26 13:00:00	SPY	ETF	419.38	419.61	419.04	419.2599	1716602.0
2021-05-26 13:30:00	SPY	ETF	419.2519	419.285	418.44	418.69	2459708.0
2021-05-26 14:00:00	SPY	ETF	418.7	419.18	418.64	419.09	1536161.0
2021-05-26 14:30:00	SPY	ETF	419.09	419.16	418.7	418.84	1694994.0
2021-05-26 15:00:00	SPY	ETF	418.84	419.18	418.625	418.9423	3265623.0
2021-05-26 15:30:00	SPY	ETF	418.95	419.12	418.56	419.0499	7308342.0
2021-05-26 16:00:00	SPY	ETF	419.04	419.1	418.6533	419.07	1770427.0
2021-05-26 16:30:00	SPY	ETF	419.07	419.12	419.0	419.08	177745.0
2021-05-26 17:00:00	SPY	ETF	419.04	419.1	418.98	419.05	90478.0
2021-05-26 17:30:00	SPY	ETF	419.05	419.07	419.02	419.05	8250.0
2021-05-26 18:00:00	SPY	ETF	419.04	419.32	419.02	419.32	41076.0
2021-05-26 18:30:00	SPY	ETF	419.22	419.22	418.98	418.98	26129.0
2021-05-26 19:00:00	SPY	ETF	418.97	418.98	418.77	418.89	26163.0
2021-05-26 19:30:00	SPY	ETF	418.93	419.0	418.76	419.0	23105.0
2021-05-26 04:00:00	QQQ	ETF	333.91	334.13	333.74	334.0	14464.0
2021-05-26 04:30:00	QQQ	ETF	334.03	334.03	333.67	333.75	8713.0
2021-05-26 05:00:00	QQQ	ETF	333.66	333.99	333.66	333.99	6481.0
2021-05-26 05:30:00	QQQ	ETF	334.11	334.35	333.71	333.79	16763.0
2021-05-26 06:00:00	QQQ	ETF	333.79	333.91	333.76	333.83	8376.0
2021-05-26 06:30:00	QQQ	ETF	333.9	334.07	333.84	334.06	4549.0
2021-05-26 07:00:00	QQQ	ETF	334.05	334.69	333.97	334.56	64930.0
2021-05-26 07:30:00	QQQ	ETF	334.53	334.55	334.31	334.33	35427.0
2021-05-26 08:00:00	QQQ	ETF	334.0596	334.61	333.5	334.5899	58017.0
2021-05-26 08:30:00	QQQ	ETF	334.6	334.6	333.85	334.01	144266.0
2021-05-26 09:00:00	QQQ	ETF	334.06	334.07	333.5	333.66	118736.0
2021-05-26 09:30:00	QQQ	ETF	333.66	334.221	333.12	333.3299	2779200.0
2021-05-26 10:00:00	QQQ	ETF	333.36	334.008	332.95	333.9401	1648246.0
2021-05-26 10:30:00	QQQ	ETF	333.95	334.325	333.81	334.19	1267583.0
2021-05-26 11:00:00	QQQ	ETF	334.2	334.45	333.97	334.03	1239387.0
2021-05-26 11:30:00	QQQ	ETF	334.02	334.4	333.5206	334.34	1189445.0
2021-05-26 12:00:00	QQQ	ETF	334.34	334.61	334.25	334.385	1006255.0
2021-05-26 12:30:00	QQQ	ETF	334.39	334.52	334.2	334.2982	663859.0

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

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