PREVIEW / stock_30min / 2020-03-31

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-03-31.parquet
  size:    1.8 MB
  rows:    93,391
  symbols: 2,447

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-03-31 04:00:00	AAPL	Stock	64.3275	64.475	64.1	64.475	37452.0
2020-03-31 04:30:00	AAPL	Stock	64.475	64.675	64.31	64.625	23024.0
2020-03-31 05:00:00	AAPL	Stock	64.53	64.625	64.5075	64.5925	16840.0
2020-03-31 05:30:00	AAPL	Stock	64.5875	64.625	64.3075	64.3075	15524.0
2020-03-31 06:00:00	AAPL	Stock	64.435	64.5	64.09	64.0975	25892.0
2020-03-31 06:30:00	AAPL	Stock	64.0525	64.2475	63.9025	63.9025	10492.0
2020-03-31 07:00:00	AAPL	Stock	63.9725	64.125	63.765	63.88	164052.0
2020-03-31 07:30:00	AAPL	Stock	63.9225	63.98	63.635	63.87	132336.0
2020-03-31 08:00:00	AAPL	Stock	63.8575	64.1175	63.075	63.3725	408796.0
2020-03-31 08:30:00	AAPL	Stock	63.375	63.4975	63.1275	63.475	255232.0
2020-03-31 09:00:00	AAPL	Stock	63.475	63.925	63.41	63.9075	255292.0
2020-03-31 09:30:00	AAPL	Stock	63.9	64.3525	63.5725	63.8125	17288904.0
2020-03-31 10:00:00	AAPL	Stock	63.8225	65.325	63.81	65.205	17222536.0
2020-03-31 10:30:00	AAPL	Stock	65.1975	65.6225	64.9	64.955	13967028.0
2020-03-31 11:00:00	AAPL	Stock	64.9625	65.1125	64.675	65.07	9594216.0
2020-03-31 11:30:00	AAPL	Stock	65.0642	65.18	64.57	64.72	7483436.0
2020-03-31 12:00:00	AAPL	Stock	64.715	64.835	64.0325	64.2225	7147916.0
2020-03-31 12:30:00	AAPL	Stock	64.225	64.3325	63.685	63.9625	10477368.0
2020-03-31 13:00:00	AAPL	Stock	63.96	64.17	63.625	63.8	7203724.0
2020-03-31 13:30:00	AAPL	Stock	63.7975	64.285	63.6525	64.2025	7571796.0
2020-03-31 14:00:00	AAPL	Stock	64.2088	64.2262	63.7775	63.965	5547388.0
2020-03-31 14:30:00	AAPL	Stock	63.9738	64.22	63.7275	63.9012	6110336.0
2020-03-31 15:00:00	AAPL	Stock	63.8975	64.12	63.0	63.1935	10865424.0
2020-03-31 15:30:00	AAPL	Stock	63.2	63.7375	63.0575	63.575	17034924.0
2020-03-31 16:00:00	AAPL	Stock	63.574	63.574	63.3	63.5	22184292.0
2020-03-31 16:30:00	AAPL	Stock	63.425	64.1498	63.35	63.43	51064.0
2020-03-31 17:00:00	AAPL	Stock	63.4375	63.4675	63.375	63.3925	69848.0
2020-03-31 17:30:00	AAPL	Stock	63.3925	63.3925	63.125	63.225	109624.0
2020-03-31 18:00:00	AAPL	Stock	63.1875	63.21	63.0	63.07	142776.0
2020-03-31 18:30:00	AAPL	Stock	63.0375	63.0725	62.9	62.945	64944.0
2020-03-31 19:00:00	AAPL	Stock	62.95	62.9775	62.65	62.775	67424.0
2020-03-31 19:30:00	AAPL	Stock	62.7875	62.82	62.65	62.65	112496.0
2020-03-31 04:00:00	MSFT	Stock	163.62	164.5	163.62	164.17	18444.0
2020-03-31 04:30:00	MSFT	Stock	164.15	164.2	163.5	163.8	16043.0
2020-03-31 05:00:00	MSFT	Stock	163.8	164.0	163.51	163.8	7105.0
2020-03-31 05:30:00	MSFT	Stock	163.96	163.97	162.63	163.25	15781.0
2020-03-31 06:00:00	MSFT	Stock	162.82	163.46	160.5	160.5	93349.0
2020-03-31 06:30:00	MSFT	Stock	160.64	161.37	160.23	160.3	75444.0
2020-03-31 07:00:00	MSFT	Stock	160.5	161.18	159.87	160.7	152476.0
2020-03-31 07:30:00	MSFT	Stock	160.79	161.3	159.63	160.0	169793.0
2020-03-31 08:00:00	MSFT	Stock	159.97	161.1	157.0	158.15	267018.0
2020-03-31 08:30:00	MSFT	Stock	158.2	158.75	157.5	158.75	188129.0
2020-03-31 09:00:00	MSFT	Stock	158.74	159.6	158.52	159.54	339177.0
2020-03-31 09:30:00	MSFT	Stock	159.53	159.97	157.96	158.63	7299168.0
2020-03-31 10:00:00	MSFT	Stock	158.59	163.09	158.59	162.86	6971003.0
2020-03-31 10:30:00	MSFT	Stock	162.84	164.78	162.54	162.75	6148897.0
2020-03-31 11:00:00	MSFT	Stock	162.75	163.61	162.1	162.95	3557955.0
2020-03-31 11:30:00	MSFT	Stock	162.94	163.24	160.28	161.102	3755678.0
2020-03-31 12:00:00	MSFT	Stock	161.101	161.26	159.92	160.14	3213431.0
2020-03-31 12:30:00	MSFT	Stock	160.14	160.19	158.81	159.268	3456231.0

> showing 50 of 93,391 rows — these rows as CSV

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