PREVIEW / stock_30min / 2020-02-18

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-02-18.parquet
  size:    1.8 MB
  rows:    87,638
  symbols: 2,420

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-02-18 04:00:00	AAPL	Stock	78.2375	78.3825	77.5175	78.2475	293348.0
2020-02-18 04:30:00	AAPL	Stock	78.245	78.4725	78.125	78.25	97432.0
2020-02-18 05:00:00	AAPL	Stock	78.25	78.625	78.18	78.475	149540.0
2020-02-18 05:30:00	AAPL	Stock	78.4775	78.625	78.475	78.625	74576.0
2020-02-18 06:00:00	AAPL	Stock	78.5875	78.625	78.425	78.5475	73956.0
2020-02-18 06:30:00	AAPL	Stock	78.545	78.58	78.3525	78.3975	84640.0
2020-02-18 07:00:00	AAPL	Stock	78.375	78.8325	78.375	78.7375	745812.0
2020-02-18 07:30:00	AAPL	Stock	78.7	79.05	78.6275	79.025	458184.0
2020-02-18 08:00:00	AAPL	Stock	78.6	79.72	78.4075	79.6025	1496500.0
2020-02-18 08:30:00	AAPL	Stock	79.6225	79.935	79.345	79.4525	1276944.0
2020-02-18 09:00:00	AAPL	Stock	79.44	79.5625	78.7825	78.8725	1674900.0
2020-02-18 09:30:00	AAPL	Stock	78.8375	79.5975	78.6525	79.435	29356936.0
2020-02-18 10:00:00	AAPL	Stock	79.435	79.4595	79.1188	79.1468	10044836.0
2020-02-18 10:30:00	AAPL	Stock	79.1475	79.66	79.13	79.4525	7951520.0
2020-02-18 11:00:00	AAPL	Stock	79.4475	79.485	79.1628	79.245	6242644.0
2020-02-18 11:30:00	AAPL	Stock	79.24	79.365	78.9	78.9038	6888884.0
2020-02-18 12:00:00	AAPL	Stock	78.9	79.1125	78.8025	79.065	7874560.0
2020-02-18 12:30:00	AAPL	Stock	79.075	79.3	79.0748	79.268	5489524.0
2020-02-18 13:00:00	AAPL	Stock	79.268	79.5475	79.265	79.4272	5538552.0
2020-02-18 13:30:00	AAPL	Stock	79.4262	79.545	79.345	79.5255	4019688.0
2020-02-18 14:00:00	AAPL	Stock	79.5275	79.795	79.3925	79.79	4617436.0
2020-02-18 14:30:00	AAPL	Stock	79.79	79.9375	79.7175	79.825	5646096.0
2020-02-18 15:00:00	AAPL	Stock	79.8215	79.9225	79.7125	79.8	5213020.0
2020-02-18 15:30:00	AAPL	Stock	79.7975	79.82	79.575	79.75	7846348.0
2020-02-18 16:00:00	AAPL	Stock	79.75	79.795	79.7	79.75	9947024.0
2020-02-18 16:30:00	AAPL	Stock	79.775	79.875	79.75	79.75	98936.0
2020-02-18 17:00:00	AAPL	Stock	79.7925	79.805	79.7675	79.775	29980.0
2020-02-18 17:30:00	AAPL	Stock	79.775	79.8	79.765	79.7925	26048.0
2020-02-18 18:00:00	AAPL	Stock	79.7975	79.8375	79.79	79.825	51452.0
2020-02-18 18:30:00	AAPL	Stock	79.825	79.9	79.825	79.9	36332.0
2020-02-18 19:00:00	AAPL	Stock	79.925	79.925	79.875	79.9125	48680.0
2020-02-18 19:30:00	AAPL	Stock	79.9375	79.9375	79.9125	79.9375	63612.0
2020-02-18 04:00:00	MSFT	Stock	184.3	185.0	184.1	184.6	11018.0
2020-02-18 04:30:00	MSFT	Stock	184.68	184.7	184.6	184.6	7703.0
2020-02-18 05:00:00	MSFT	Stock	184.7	184.76	184.6	184.7	2568.0
2020-02-18 05:30:00	MSFT	Stock	184.69	185.17	184.69	185.1	6417.0
2020-02-18 06:00:00	MSFT	Stock	185.21	185.29	184.99	185.21	2421.0
2020-02-18 06:30:00	MSFT	Stock	185.1	185.18	184.99	185.0	7826.0
2020-02-18 07:00:00	MSFT	Stock	184.93	185.15	184.9	184.95	25241.0
2020-02-18 07:30:00	MSFT	Stock	184.93	185.09	184.9	184.9	11657.0
2020-02-18 08:00:00	MSFT	Stock	184.95	185.81	184.9	185.119	45254.0
2020-02-18 08:30:00	MSFT	Stock	185.1	185.15	184.84	185.1	86773.0
2020-02-18 09:00:00	MSFT	Stock	185.05	185.77	185.0	185.77	52827.0
2020-02-18 09:30:00	MSFT	Stock	185.79	186.92	185.5	186.92	3948418.0
2020-02-18 10:00:00	MSFT	Stock	186.91	187.6	186.5	186.56	2597850.0
2020-02-18 10:30:00	MSFT	Stock	186.553	187.09	186.45	186.81	1552261.0
2020-02-18 11:00:00	MSFT	Stock	186.81	187.03	186.29	186.34	1866702.0
2020-02-18 11:30:00	MSFT	Stock	186.335	186.83	186.074	186.413	1336712.0
2020-02-18 12:00:00	MSFT	Stock	186.415	186.6	186.2	186.525	873617.0
2020-02-18 12:30:00	MSFT	Stock	186.53	186.96	186.53	186.647	802049.0

> showing 50 of 87,638 rows — these rows as CSV

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