PREVIEW / stock_30min / 2020-01-10

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-01-10.parquet
  size:    1.8 MB
  rows:    86,369
  symbols: 2,470

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-10 04:00:00	AAPL	Stock	77.805	77.9475	77.805	77.9425	26096.0
2020-01-10 04:30:00	AAPL	Stock	77.9125	77.975	77.9125	77.97	13468.0
2020-01-10 05:00:00	AAPL	Stock	77.975	77.9925	77.9225	77.975	25060.0
2020-01-10 05:30:00	AAPL	Stock	77.9525	77.9675	77.95	77.96	5400.0
2020-01-10 06:00:00	AAPL	Stock	77.9425	77.96	77.8825	77.96	23896.0
2020-01-10 06:30:00	AAPL	Stock	77.9075	77.9075	77.8725	77.8875	30756.0
2020-01-10 07:00:00	AAPL	Stock	77.925	78.0125	77.78	77.9525	368216.0
2020-01-10 07:30:00	AAPL	Stock	77.975	78.0875	77.9525	78.0475	232600.0
2020-01-10 08:00:00	AAPL	Stock	78.045	78.085	77.81	77.875	683032.0
2020-01-10 08:30:00	AAPL	Stock	77.875	77.9375	77.5	77.6875	935392.0
2020-01-10 09:00:00	AAPL	Stock	77.7	77.75	77.615	77.6425	402892.0
2020-01-10 09:30:00	AAPL	Stock	77.645	78.0438	77.425	78.0165	21893064.0
2020-01-10 10:00:00	AAPL	Stock	78.02	78.1675	77.9175	78.09	13225684.0
2020-01-10 10:30:00	AAPL	Stock	78.095	78.1375	77.935	78.0112	6819172.0
2020-01-10 11:00:00	AAPL	Stock	78.0125	78.0825	77.7075	77.74	7646264.0
2020-01-10 11:30:00	AAPL	Stock	77.74	77.9	77.61	77.7675	7786904.0
2020-01-10 12:00:00	AAPL	Stock	77.7775	77.7775	77.0625	77.4875	13188116.0
2020-01-10 12:30:00	AAPL	Stock	77.49	77.5925	77.4175	77.4425	5976052.0
2020-01-10 13:00:00	AAPL	Stock	77.4425	77.735	77.425	77.66	4797396.0
2020-01-10 13:30:00	AAPL	Stock	77.665	77.7	77.52	77.6765	3656580.0
2020-01-10 14:00:00	AAPL	Stock	77.675	77.7375	77.455	77.485	4274124.0
2020-01-10 14:30:00	AAPL	Stock	77.4825	77.5525	77.32	77.5162	6393408.0
2020-01-10 15:00:00	AAPL	Stock	77.515	77.575	77.3075	77.5368	6653580.0
2020-01-10 15:30:00	AAPL	Stock	77.535	77.605	77.315	77.5925	10818816.0
2020-01-10 16:00:00	AAPL	Stock	77.5825	77.6375	77.5525	77.5925	5733920.0
2020-01-10 16:30:00	AAPL	Stock	77.6	77.6375	77.5825	77.6025	233776.0
2020-01-10 17:00:00	AAPL	Stock	77.595	77.6175	77.595	77.6175	40424.0
2020-01-10 17:30:00	AAPL	Stock	77.6025	77.6725	77.6025	77.6625	25084.0
2020-01-10 18:00:00	AAPL	Stock	77.665	77.6775	77.63	77.645	16436.0
2020-01-10 18:30:00	AAPL	Stock	77.645	77.65	77.625	77.6275	75056.0
2020-01-10 19:00:00	AAPL	Stock	77.6275	77.675	77.625	77.675	41312.0
2020-01-10 19:30:00	AAPL	Stock	77.675	77.7125	77.65	77.6675	81552.0
2020-01-10 04:00:00	MSFT	Stock	162.54	162.69	162.5	162.69	2979.0
2020-01-10 04:30:00	MSFT	Stock	162.69	162.83	162.58	162.77	1425.0
2020-01-10 05:00:00	MSFT	Stock	162.9	162.9	162.9	162.9	478.0
2020-01-10 05:30:00	MSFT	Stock	162.88	162.88	162.81	162.81	1723.0
2020-01-10 06:00:00	MSFT	Stock	162.8	163.1	162.72	163.1	2627.0
2020-01-10 06:30:00	MSFT	Stock	163.19	163.19	162.97	162.99	5174.0
2020-01-10 07:00:00	MSFT	Stock	162.86	162.97	162.79	162.9	6227.0
2020-01-10 07:30:00	MSFT	Stock	162.9	162.98	162.86	162.88	9677.0
2020-01-10 08:00:00	MSFT	Stock	162.85	163.0	162.71	162.8	40226.0
2020-01-10 08:30:00	MSFT	Stock	162.8	163.03	162.53	162.7	39766.0
2020-01-10 09:00:00	MSFT	Stock	162.651	162.9	162.09	162.74	74715.0
2020-01-10 09:30:00	MSFT	Stock	162.74	162.91	162.13	162.625	2427363.0
2020-01-10 10:00:00	MSFT	Stock	162.635	163.22	162.635	162.87	1579704.0
2020-01-10 10:30:00	MSFT	Stock	162.86	163.02	162.542	162.81	1205266.0
2020-01-10 11:00:00	MSFT	Stock	162.81	162.949	162.6	162.615	811791.0
2020-01-10 11:30:00	MSFT	Stock	162.6	162.67	162.3	162.485	781193.0
2020-01-10 12:00:00	MSFT	Stock	162.49	162.5	161.825	162.23	1164073.0
2020-01-10 12:30:00	MSFT	Stock	162.235	162.36	162.13	162.18	621237.0

> showing 50 of 86,369 rows — these rows as CSV

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