PREVIEW / etf_30min / 2020-08-07

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-08-07.parquet
  size:    557 KB
  rows:    20,562

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-08-07 04:00:00	SPY	ETF	334.02	334.02	333.3	333.3	13109.0
2020-08-07 04:30:00	SPY	ETF	333.25	333.4	333.05	333.26	11150.0
2020-08-07 05:00:00	SPY	ETF	333.22	333.22	332.46	332.65	13418.0
2020-08-07 05:30:00	SPY	ETF	332.51	332.87	332.51	332.87	6290.0
2020-08-07 06:00:00	SPY	ETF	332.73	332.9	332.58	332.85	18681.0
2020-08-07 06:30:00	SPY	ETF	332.85	333.19	332.76	333.15	116520.0
2020-08-07 07:00:00	SPY	ETF	333.26	333.36	333.07	333.34	108499.0
2020-08-07 07:30:00	SPY	ETF	333.3	333.36	333.06	333.1	83451.0
2020-08-07 08:00:00	SPY	ETF	333.3501	333.6	332.7	333.19	278700.0
2020-08-07 08:30:00	SPY	ETF	333.65	334.61	333.27	333.36	1145455.0
2020-08-07 09:00:00	SPY	ETF	333.36	333.36	332.8	333.28	283386.0
2020-08-07 09:30:00	SPY	ETF	333.28	334.085	332.86	333.92	4542234.0
2020-08-07 10:00:00	SPY	ETF	333.91	334.11	333.0584	333.71	2886896.0
2020-08-07 10:30:00	SPY	ETF	333.72	334.59	333.69	334.38	2931093.0
2020-08-07 11:00:00	SPY	ETF	334.38	334.65	333.73	333.77	2319403.0
2020-08-07 11:30:00	SPY	ETF	333.765	334.26	333.51	333.55	2045796.0
2020-08-07 12:00:00	SPY	ETF	333.54	334.38	333.37	334.33	1880951.0
2020-08-07 12:30:00	SPY	ETF	334.32	334.57	333.84	333.86	2225523.0
2020-08-07 13:00:00	SPY	ETF	333.86	333.93	332.91	333.67	3155304.0
2020-08-07 13:30:00	SPY	ETF	333.68	334.055	332.91	333.0203	2935052.0
2020-08-07 14:00:00	SPY	ETF	333.02	333.57	332.3	332.485	5001334.0
2020-08-07 14:30:00	SPY	ETF	332.48	333.3892	332.31	333.29	3176474.0
2020-08-07 15:00:00	SPY	ETF	333.29	333.86	332.845	333.3	5662154.0
2020-08-07 15:30:00	SPY	ETF	333.29	334.88	333.12	334.55	10841362.0
2020-08-07 16:00:00	SPY	ETF	334.54	334.67	334.3	334.52	4463850.0
2020-08-07 16:30:00	SPY	ETF	334.52	334.79	334.52	334.77	214959.0
2020-08-07 17:00:00	SPY	ETF	334.78	334.78	334.54	334.62	111851.0
2020-08-07 17:30:00	SPY	ETF	334.62	334.65	334.37	334.43	76826.0
2020-08-07 18:00:00	SPY	ETF	334.43	334.63	334.3	334.47	43087.0
2020-08-07 18:30:00	SPY	ETF	334.43	334.55	334.42	334.55	15271.0
2020-08-07 19:00:00	SPY	ETF	334.5	334.61	334.43	334.59	7994.0
2020-08-07 19:30:00	SPY	ETF	334.61	334.67	334.53	334.53	7723.0
2020-08-07 04:00:00	QQQ	ETF	274.2	274.21	273.42	273.42	18026.0
2020-08-07 04:30:00	QQQ	ETF	273.51	273.67	273.37	273.66	18252.0
2020-08-07 05:00:00	QQQ	ETF	273.49	273.49	273.02	273.15	21381.0
2020-08-07 05:30:00	QQQ	ETF	273.16	273.5	273.16	273.48	6300.0
2020-08-07 06:00:00	QQQ	ETF	273.41	273.52	273.22	273.41	7424.0
2020-08-07 06:30:00	QQQ	ETF	273.3	273.64	273.3	273.61	6797.0
2020-08-07 07:00:00	QQQ	ETF	273.65	273.81	273.56	273.71	32895.0
2020-08-07 07:30:00	QQQ	ETF	273.74	273.79	273.59	273.66	59785.0
2020-08-07 08:00:00	QQQ	ETF	273.68	274.11	273.1	273.78	151943.0
2020-08-07 08:30:00	QQQ	ETF	274.01	274.63	273.35	273.71	417283.0
2020-08-07 09:00:00	QQQ	ETF	273.76	274.64	273.6	274.08	276816.0
2020-08-07 09:30:00	QQQ	ETF	274.04	274.5	273.44	274.4	3057184.0
2020-08-07 10:00:00	QQQ	ETF	274.41	274.465	273.39	273.91	2283899.0
2020-08-07 10:30:00	QQQ	ETF	273.92	274.8818	273.882	274.7	2083036.0
2020-08-07 11:00:00	QQQ	ETF	274.69	274.79	273.31	273.33	1697807.0
2020-08-07 11:30:00	QQQ	ETF	273.3499	273.8168	272.59	272.62	1593553.0
2020-08-07 12:00:00	QQQ	ETF	272.6111	273.19	272.26	273.15	1983779.0
2020-08-07 12:30:00	QQQ	ETF	273.14	273.37	271.7	271.72	2475185.0

> showing 50 of 20,562 rows — these rows as CSV

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