PREVIEW / stock_30min / 2021-01-29

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-01-29.parquet
  size:    2.3 MB
  rows:    117,813
  symbols: 2,742

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-29 04:00:00	AAPL	Stock	135.6	136.1	135.06	135.88	60743.0
2021-01-29 04:30:00	AAPL	Stock	135.88	135.95	135.0	135.4	43353.0
2021-01-29 05:00:00	AAPL	Stock	135.32	135.32	134.76	135.28	53530.0
2021-01-29 05:30:00	AAPL	Stock	135.24	136.03	135.24	135.96	11056.0
2021-01-29 06:00:00	AAPL	Stock	136.01	136.49	135.27	136.42	27240.0
2021-01-29 06:30:00	AAPL	Stock	136.36	136.65	136.02	136.13	38948.0
2021-01-29 07:00:00	AAPL	Stock	136.17	136.38	135.8	136.1	240744.0
2021-01-29 07:30:00	AAPL	Stock	136.08	136.39	135.7	135.85	183431.0
2021-01-29 08:00:00	AAPL	Stock	136.12	137.43	135.27	135.73	719192.0
2021-01-29 08:30:00	AAPL	Stock	135.75	137.09	135.75	136.03	444543.0
2021-01-29 09:00:00	AAPL	Stock	136.06	136.5	135.7	135.9	553098.0
2021-01-29 09:30:00	AAPL	Stock	135.85	136.74	133.79	135.159	16548269.0
2021-01-29 10:00:00	AAPL	Stock	135.11	135.59	133.9	135.1	8698305.0
2021-01-29 10:30:00	AAPL	Stock	135.099	135.44	133.83	134.112	7287276.0
2021-01-29 11:00:00	AAPL	Stock	134.13	134.33	131.875	132.2	15027057.0
2021-01-29 11:30:00	AAPL	Stock	132.19	133.05	131.2	132.99	12138769.0
2021-01-29 12:00:00	AAPL	Stock	132.965	133.31	131.46	131.968	9192235.0
2021-01-29 12:30:00	AAPL	Stock	131.95	132.23	130.21	130.58	14061280.0
2021-01-29 13:00:00	AAPL	Stock	130.58	132.1	130.34	132.048	9516448.0
2021-01-29 13:30:00	AAPL	Stock	132.04	132.81	131.47	131.66	8458251.0
2021-01-29 14:00:00	AAPL	Stock	131.65	132.63	131.59	131.945	6408046.0
2021-01-29 14:30:00	AAPL	Stock	131.93	132.07	131.03	131.63	6472924.0
2021-01-29 15:00:00	AAPL	Stock	131.64	133.22	131.61	132.533	8589660.0
2021-01-29 15:30:00	AAPL	Stock	132.54	133.5	131.72	131.83	15164109.0
2021-01-29 16:00:00	AAPL	Stock	131.96	133.0	131.83	132.0	10804301.0
2021-01-29 16:30:00	AAPL	Stock	131.98	132.886	131.91	131.96	305454.0
2021-01-29 17:00:00	AAPL	Stock	131.96	132.0	131.85	131.98	118382.0
2021-01-29 17:30:00	AAPL	Stock	131.98	131.98	131.8	131.82	84529.0
2021-01-29 18:00:00	AAPL	Stock	131.84	131.92	131.7	131.92	88270.0
2021-01-29 18:30:00	AAPL	Stock	131.91	131.91	131.7	131.8	89301.0
2021-01-29 19:00:00	AAPL	Stock	131.8	131.82	131.72	131.72	42377.0
2021-01-29 19:30:00	AAPL	Stock	131.71	131.79	131.55	131.78	101713.0
2021-01-29 04:00:00	MSFT	Stock	235.7	235.9	233.98	234.09	13406.0
2021-01-29 04:30:00	MSFT	Stock	234.6	235.55	234.6	234.76	16008.0
2021-01-29 05:00:00	MSFT	Stock	234.4	234.4	233.15	234.0	10475.0
2021-01-29 05:30:00	MSFT	Stock	234.15	235.45	233.8	235.38	11524.0
2021-01-29 06:00:00	MSFT	Stock	235.12	236.0	235.0	236.0	11561.0
2021-01-29 06:30:00	MSFT	Stock	236.0	236.55	235.29	235.29	8562.0
2021-01-29 07:00:00	MSFT	Stock	235.84	236.5	235.82	236.47	36454.0
2021-01-29 07:30:00	MSFT	Stock	236.55	236.7	235.16	235.23	47583.0
2021-01-29 08:00:00	MSFT	Stock	236.0	238.34	234.2	236.0	86935.0
2021-01-29 08:30:00	MSFT	Stock	236.04	238.93	236.02	236.8	86983.0
2021-01-29 09:00:00	MSFT	Stock	236.98	237.23	235.3	236.03	60330.0
2021-01-29 09:30:00	MSFT	Stock	235.92	236.94	234.06	236.28	4274755.0
2021-01-29 10:00:00	MSFT	Stock	236.255	237.92	236.064	237.8	1880907.0
2021-01-29 10:30:00	MSFT	Stock	237.79	238.02	234.93	237.146	1504202.0
2021-01-29 11:00:00	MSFT	Stock	237.16	237.48	233.81	233.91	1918672.0
2021-01-29 11:30:00	MSFT	Stock	233.92	235.02	233.56	234.92	1374736.0
2021-01-29 12:00:00	MSFT	Stock	234.9	235.2	233.47	233.52	1578047.0
2021-01-29 12:30:00	MSFT	Stock	233.51	233.75	232.01	232.315	2035075.0

> showing 50 of 117,813 rows — these rows as CSV

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