PREVIEW / stock_30min / 2020-01-27

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-01-27.parquet
  size:    1.8 MB
  rows:    89,829
  symbols: 2,459

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-01-27 04:00:00	AAPL	Stock	78.475	78.475	78.0	78.05	134368.0
2020-01-27 04:30:00	AAPL	Stock	78.05	78.065	77.8975	78.0225	44928.0
2020-01-27 05:00:00	AAPL	Stock	78.0225	78.025	77.3775	77.675	176836.0
2020-01-27 05:30:00	AAPL	Stock	77.7225	77.7225	77.375	77.375	59656.0
2020-01-27 06:00:00	AAPL	Stock	77.3175	77.575	77.1475	77.575	198048.0
2020-01-27 06:30:00	AAPL	Stock	77.6	77.6875	77.36	77.575	130832.0
2020-01-27 07:00:00	AAPL	Stock	77.6375	78.0975	77.5375	78.0	466568.0
2020-01-27 07:30:00	AAPL	Stock	77.9975	78.0875	77.8	77.8125	225664.0
2020-01-27 08:00:00	AAPL	Stock	77.8	78.1	77.655	77.95	801048.0
2020-01-27 08:30:00	AAPL	Stock	78.0	78.0	77.675	77.8125	465028.0
2020-01-27 09:00:00	AAPL	Stock	77.805	77.885	77.4825	77.5125	955484.0
2020-01-27 09:30:00	AAPL	Stock	77.515	77.9425	76.4725	77.8575	33324604.0
2020-01-27 10:00:00	AAPL	Stock	77.875	77.94	77.4162	77.7875	12753688.0
2020-01-27 10:30:00	AAPL	Stock	77.7827	77.8	77.215	77.36	8491164.0
2020-01-27 11:00:00	AAPL	Stock	77.355	77.5125	76.8825	77.0825	8658688.0
2020-01-27 11:30:00	AAPL	Stock	77.0775	77.42	76.965	77.345	6829828.0
2020-01-27 12:00:00	AAPL	Stock	77.3425	77.7725	77.2775	77.6775	6447632.0
2020-01-27 12:30:00	AAPL	Stock	77.66	77.8975	77.6308	77.795	4928100.0
2020-01-27 13:00:00	AAPL	Stock	77.795	77.9	77.625	77.7875	4165976.0
2020-01-27 13:30:00	AAPL	Stock	77.7825	77.8238	77.525	77.5695	3246104.0
2020-01-27 14:00:00	AAPL	Stock	77.575	77.7875	77.47	77.74	3693956.0
2020-01-27 14:30:00	AAPL	Stock	77.7425	77.8	77.23	77.379	6193440.0
2020-01-27 15:00:00	AAPL	Stock	77.3725	77.45	77.155	77.3035	6683944.0
2020-01-27 15:30:00	AAPL	Stock	77.3025	77.4525	76.22	77.24	11385220.0
2020-01-27 16:00:00	AAPL	Stock	77.2425	77.26	77.2	77.2225	11941748.0
2020-01-27 16:30:00	AAPL	Stock	77.215	77.2475	77.1375	77.18	250204.0
2020-01-27 17:00:00	AAPL	Stock	77.1775	77.25	77.15	77.2375	1503600.0
2020-01-27 17:30:00	AAPL	Stock	77.2225	77.3225	77.2225	77.275	64592.0
2020-01-27 18:00:00	AAPL	Stock	77.25	77.53	77.25	77.53	149916.0
2020-01-27 18:30:00	AAPL	Stock	77.495	77.4975	77.395	77.4425	79556.0
2020-01-27 19:00:00	AAPL	Stock	77.45	77.5	77.45	77.4825	86696.0
2020-01-27 19:30:00	AAPL	Stock	77.475	77.495	77.275	77.3125	91988.0
2020-01-27 04:00:00	MSFT	Stock	163.39	163.39	161.73	162.02	16879.0
2020-01-27 04:30:00	MSFT	Stock	162.0	162.17	162.0	162.1	14670.0
2020-01-27 05:00:00	MSFT	Stock	161.94	161.94	161.31	161.67	10011.0
2020-01-27 05:30:00	MSFT	Stock	161.43	161.62	161.11	161.13	10479.0
2020-01-27 06:00:00	MSFT	Stock	161.15	161.85	161.1	161.69	15776.0
2020-01-27 06:30:00	MSFT	Stock	161.63	161.98	161.5	161.76	9853.0
2020-01-27 07:00:00	MSFT	Stock	161.72	162.05	161.51	162.0	31067.0
2020-01-27 07:30:00	MSFT	Stock	162.01	162.17	161.83	161.85	32595.0
2020-01-27 08:00:00	MSFT	Stock	161.515	162.19	161.515	162.04	72458.0
2020-01-27 08:30:00	MSFT	Stock	162.02	162.19	161.85	162.0	39712.0
2020-01-27 09:00:00	MSFT	Stock	162.15	162.18	161.06	161.13	88373.0
2020-01-27 09:30:00	MSFT	Stock	161.17	162.37	160.2	162.04	4343876.0
2020-01-27 10:00:00	MSFT	Stock	162.05	162.71	161.735	162.635	2053117.0
2020-01-27 10:30:00	MSFT	Stock	162.63	162.66	161.87	162.265	1266846.0
2020-01-27 11:00:00	MSFT	Stock	162.269	162.75	162.16	162.615	1113874.0
2020-01-27 11:30:00	MSFT	Stock	162.62	163.075	162.4	162.875	1424109.0
2020-01-27 12:00:00	MSFT	Stock	162.87	163.375	162.61	163.06	993129.0
2020-01-27 12:30:00	MSFT	Stock	163.04	163.37	162.92	162.971	737868.0

> showing 50 of 89,829 rows — these rows as CSV

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