PREVIEW / stock_30min / 2020-01-24

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-01-24.parquet
  size:    1.8 MB
  rows:    85,867
  symbols: 2,440

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-24 04:00:00	AAPL	Stock	80.0825	80.165	80.0825	80.14	4428.0
2020-01-24 04:30:00	AAPL	Stock	80.14	80.16	80.1225	80.1225	7288.0
2020-01-24 05:00:00	AAPL	Stock	80.0975	80.1	80.075	80.075	4708.0
2020-01-24 05:30:00	AAPL	Stock	80.0525	80.0525	80.04	80.04	15872.0
2020-01-24 06:00:00	AAPL	Stock	80.095	80.095	80.0475	80.0475	9980.0
2020-01-24 06:30:00	AAPL	Stock	80.05	80.075	80.025	80.075	17388.0
2020-01-24 07:00:00	AAPL	Stock	80.075	80.075	79.925	79.9525	223516.0
2020-01-24 07:30:00	AAPL	Stock	79.9575	79.975	79.9325	79.955	75504.0
2020-01-24 08:00:00	AAPL	Stock	79.945	80.0475	79.93	79.95	282592.0
2020-01-24 08:30:00	AAPL	Stock	79.9625	80.075	79.9525	80.055	413960.0
2020-01-24 09:00:00	AAPL	Stock	80.055	80.0825	79.975	80.0425	233652.0
2020-01-24 09:30:00	AAPL	Stock	80.045	80.6575	79.965	80.6525	16822368.0
2020-01-24 10:00:00	AAPL	Stock	80.655	80.6575	80.25	80.275	9546568.0
2020-01-24 10:30:00	AAPL	Stock	80.2725	80.575	80.265	80.555	7218116.0
2020-01-24 11:00:00	AAPL	Stock	80.5672	80.8325	80.4375	80.605	9792036.0
2020-01-24 11:30:00	AAPL	Stock	80.5975	80.665	80.4602	80.4925	4977272.0
2020-01-24 12:00:00	AAPL	Stock	80.4875	80.4962	79.8275	80.03	12319408.0
2020-01-24 12:30:00	AAPL	Stock	80.0325	80.3495	79.9712	80.2755	6537716.0
2020-01-24 13:00:00	AAPL	Stock	80.2825	80.2875	80.0175	80.0425	4226844.0
2020-01-24 13:30:00	AAPL	Stock	80.0375	80.115	79.7625	79.9625	6648632.0
2020-01-24 14:00:00	AAPL	Stock	79.9675	80.035	79.4725	79.69	9453952.0
2020-01-24 14:30:00	AAPL	Stock	79.697	80.065	79.6875	80.0445	7300604.0
2020-01-24 15:00:00	AAPL	Stock	80.04	80.095	79.9088	79.915	6208244.0
2020-01-24 15:30:00	AAPL	Stock	79.9075	79.92	79.3798	79.5825	13683592.0
2020-01-24 16:00:00	AAPL	Stock	79.5625	80.135	79.55	79.5875	9187956.0
2020-01-24 16:30:00	AAPL	Stock	79.5825	79.6125	79.55	79.55	77332.0
2020-01-24 17:00:00	AAPL	Stock	79.5875	79.5875	79.5025	79.5375	81296.0
2020-01-24 17:30:00	AAPL	Stock	79.5075	79.5475	79.4575	79.5	85556.0
2020-01-24 18:00:00	AAPL	Stock	79.48	79.525	79.45	79.5	35296.0
2020-01-24 18:30:00	AAPL	Stock	79.4525	79.495	79.4375	79.4375	14320.0
2020-01-24 19:00:00	AAPL	Stock	79.4625	79.4975	79.425	79.4325	20536.0
2020-01-24 19:30:00	AAPL	Stock	79.49	79.49	79.3775	79.395	55680.0
2020-01-24 04:00:00	MSFT	Stock	167.75	168.0	167.75	168.0	1565.0
2020-01-24 04:30:00	MSFT	Stock	167.76	167.89	167.71	167.71	954.0
2020-01-24 05:00:00	MSFT	Stock	167.79	167.8	167.79	167.8	200.0
2020-01-24 05:30:00	MSFT	Stock	167.85	167.85	167.85	167.85	800.0
2020-01-24 06:00:00	MSFT	Stock	167.71	167.8	167.68	167.8	2016.0
2020-01-24 06:30:00	MSFT	Stock	167.8	167.89	167.8	167.89	1272.0
2020-01-24 07:00:00	MSFT	Stock	167.76	167.8	167.53	167.53	18597.0
2020-01-24 07:30:00	MSFT	Stock	167.55	167.65	167.5	167.5	6282.0
2020-01-24 08:00:00	MSFT	Stock	167.74	167.815	167.38	167.39	26858.0
2020-01-24 08:30:00	MSFT	Stock	167.55	167.6	167.46	167.46	10895.0
2020-01-24 09:00:00	MSFT	Stock	167.48	167.65	167.4	167.54	25334.0
2020-01-24 09:30:00	MSFT	Stock	167.46	167.53	166.83	167.405	2506955.0
2020-01-24 10:00:00	MSFT	Stock	167.4	167.425	166.84	166.86	1133972.0
2020-01-24 10:30:00	MSFT	Stock	166.845	167.36	166.77	167.23	946965.0
2020-01-24 11:00:00	MSFT	Stock	167.235	167.43	166.8	167.0	1327312.0
2020-01-24 11:30:00	MSFT	Stock	166.99	167.07	166.55	166.72	816604.0
2020-01-24 12:00:00	MSFT	Stock	166.71	166.75	165.737	165.99	1282244.0
2020-01-24 12:30:00	MSFT	Stock	166.01	166.435	165.91	166.36	756029.0

> showing 50 of 85,867 rows — these rows as CSV

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