PREVIEW / etf_30min / 2021-01-28

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-01-28.parquet
  size:    626 KB
  rows:    24,084

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-01-28 04:00:00	SPY	ETF	370.6	371.26	370.34	370.68	70553.0
2021-01-28 04:30:00	SPY	ETF	370.71	371.88	370.32	371.58	57010.0
2021-01-28 05:00:00	SPY	ETF	371.35	372.9	371.33	372.73	66500.0
2021-01-28 05:30:00	SPY	ETF	372.73	373.11	372.5	372.56	59567.0
2021-01-28 06:00:00	SPY	ETF	372.46	374.0	372.24	373.43	213846.0
2021-01-28 06:30:00	SPY	ETF	373.41	373.75	373.1	373.28	67225.0
2021-01-28 07:00:00	SPY	ETF	373.3	374.5	373.16	374.09	335212.0
2021-01-28 07:30:00	SPY	ETF	374.05	374.11	373.4	373.75	143606.0
2021-01-28 08:00:00	SPY	ETF	373.66	374.4596	370.88	373.37	552566.0
2021-01-28 08:30:00	SPY	ETF	373.23	376.32	373.14	376.04	931287.0
2021-01-28 09:00:00	SPY	ETF	376.1	377.05	375.16	376.33	988054.0
2021-01-28 09:30:00	SPY	ETF	376.35	378.87	375.89	377.58	9037861.0
2021-01-28 10:00:00	SPY	ETF	377.59	380.18	377.27	378.91	6281862.0
2021-01-28 10:30:00	SPY	ETF	378.89	380.07	378.39	379.78	4451107.0
2021-01-28 11:00:00	SPY	ETF	379.84	380.96	379.78	379.91	4356223.0
2021-01-28 11:30:00	SPY	ETF	379.91	380.757	379.54	380.6	2839814.0
2021-01-28 12:00:00	SPY	ETF	380.59	381.42	380.59	381.3899	3031343.0
2021-01-28 12:30:00	SPY	ETF	381.39	381.8	381.2	381.48	2167998.0
2021-01-28 13:00:00	SPY	ETF	381.475	381.85	380.87	381.21	2381132.0
2021-01-28 13:30:00	SPY	ETF	381.23	381.93	381.16	381.63	2001225.0
2021-01-28 14:00:00	SPY	ETF	381.67	381.78	380.41	380.815	3202221.0
2021-01-28 14:30:00	SPY	ETF	380.815	380.9499	379.9481	380.65	2991871.0
2021-01-28 15:00:00	SPY	ETF	380.63	380.63	379.3201	379.3201	4053821.0
2021-01-28 15:30:00	SPY	ETF	379.32	379.81	377.26	377.6	9907134.0
2021-01-28 16:00:00	SPY	ETF	377.61	378.35	376.8	377.21	8679961.0
2021-01-28 16:30:00	SPY	ETF	377.3	377.6105	376.1	376.41	1223733.0
2021-01-28 17:00:00	SPY	ETF	376.5	376.84	376.31	376.6	150155.0
2021-01-28 17:30:00	SPY	ETF	376.64	377.63	376.25	376.6	111604.0
2021-01-28 18:00:00	SPY	ETF	376.52	376.99	375.84	376.99	137794.0
2021-01-28 18:30:00	SPY	ETF	377.63	377.63	375.81	376.0	75788.0
2021-01-28 19:00:00	SPY	ETF	376.23	376.77	375.93	376.17	111039.0
2021-01-28 19:30:00	SPY	ETF	376.05	376.27	375.85	375.99	74809.0
2021-01-28 04:00:00	QQQ	ETF	315.34	316.14	314.6	315.29	63445.0
2021-01-28 04:30:00	QQQ	ETF	315.33	316.14	314.88	315.97	20050.0
2021-01-28 05:00:00	QQQ	ETF	315.97	316.75	315.38	316.44	56326.0
2021-01-28 05:30:00	QQQ	ETF	316.29	316.68	315.87	315.87	58251.0
2021-01-28 06:00:00	QQQ	ETF	315.88	317.7	315.48	317.16	49103.0
2021-01-28 06:30:00	QQQ	ETF	317.32	317.47	316.75	316.95	28082.0
2021-01-28 07:00:00	QQQ	ETF	316.93	318.5	316.8	318.12	358358.0
2021-01-28 07:30:00	QQQ	ETF	318.02	318.27	317.29	317.4	152216.0
2021-01-28 08:00:00	QQQ	ETF	317.6396	318.75	315.25	317.0	389984.0
2021-01-28 08:30:00	QQQ	ETF	316.81	319.89	316.67	319.74	423147.0
2021-01-28 09:00:00	QQQ	ETF	319.76	321.46	319.72	320.67	785290.0
2021-01-28 09:30:00	QQQ	ETF	320.67	322.89	320.03	321.44	4392869.0
2021-01-28 10:00:00	QQQ	ETF	321.45	323.65	321.27	322.605	2543024.0
2021-01-28 10:30:00	QQQ	ETF	322.64	323.82	321.8301	323.579	2782472.0
2021-01-28 11:00:00	QQQ	ETF	323.59	324.58	323.51	323.52	2284426.0
2021-01-28 11:30:00	QQQ	ETF	323.52	324.4	323.04	324.35	1303407.0
2021-01-28 12:00:00	QQQ	ETF	324.38	325.68	324.36	325.5011	2644546.0
2021-01-28 12:30:00	QQQ	ETF	325.5028	326.21	325.432	325.79	1172677.0

> showing 50 of 24,084 rows — these rows as CSV

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