PREVIEW / stock_30min / 2020-04-08

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-04-08.parquet
  size:    1.8 MB
  rows:    92,164
  symbols: 2,432

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-04-08 04:00:00	AAPL	Stock	65.0	65.1925	64.6125	64.6125	19700.0
2020-04-08 04:30:00	AAPL	Stock	64.36	64.83	64.355	64.83	5616.0
2020-04-08 05:00:00	AAPL	Stock	64.815	64.815	64.675	64.75	9084.0
2020-04-08 05:30:00	AAPL	Stock	64.75	64.85	64.675	64.675	11844.0
2020-04-08 06:00:00	AAPL	Stock	64.7	64.9175	64.7	64.9175	1924.0
2020-04-08 06:30:00	AAPL	Stock	64.985	65.2475	64.92	65.175	31756.0
2020-04-08 07:00:00	AAPL	Stock	65.135	65.7125	65.135	65.63	155568.0
2020-04-08 07:30:00	AAPL	Stock	65.6	65.625	65.3375	65.575	103788.0
2020-04-08 08:00:00	AAPL	Stock	65.2875	65.9625	65.175	65.725	444872.0
2020-04-08 08:30:00	AAPL	Stock	65.7025	65.8025	65.4068	65.525	327032.0
2020-04-08 09:00:00	AAPL	Stock	65.5	65.75	65.5	65.6725	393112.0
2020-04-08 09:30:00	AAPL	Stock	65.685	65.97	65.32	65.3825	14289004.0
2020-04-08 10:00:00	AAPL	Stock	65.3825	65.8825	65.3075	65.8575	9015524.0
2020-04-08 10:30:00	AAPL	Stock	65.8588	66.21	65.73	66.155	9567264.0
2020-04-08 11:00:00	AAPL	Stock	66.1612	66.3875	65.9568	66.3675	9317544.0
2020-04-08 11:30:00	AAPL	Stock	66.365	66.435	66.1625	66.2175	7909024.0
2020-04-08 12:00:00	AAPL	Stock	66.22	66.36	66.1008	66.1575	5245060.0
2020-04-08 12:30:00	AAPL	Stock	66.165	66.37	66.0425	66.2475	5050872.0
2020-04-08 13:00:00	AAPL	Stock	66.2575	66.3378	66.0925	66.11	4367084.0
2020-04-08 13:30:00	AAPL	Stock	66.125	66.175	65.7095	65.8088	5950316.0
2020-04-08 14:00:00	AAPL	Stock	65.83	66.275	65.7675	66.2175	6262300.0
2020-04-08 14:30:00	AAPL	Stock	66.215	66.525	66.1945	66.5175	8126900.0
2020-04-08 15:00:00	AAPL	Stock	66.5175	66.63	66.225	66.41	9301452.0
2020-04-08 15:30:00	AAPL	Stock	66.405	66.8425	65.91	66.51	22853616.0
2020-04-08 16:00:00	AAPL	Stock	66.51	66.5175	66.2462	66.5175	16724932.0
2020-04-08 16:30:00	AAPL	Stock	66.455	66.545	66.45	66.485	93792.0
2020-04-08 17:00:00	AAPL	Stock	66.4625	66.48	66.45	66.4675	28264.0
2020-04-08 17:30:00	AAPL	Stock	66.4775	66.4775	66.395	66.425	45600.0
2020-04-08 18:00:00	AAPL	Stock	66.4125	66.5175	66.2675	66.3025	88968.0
2020-04-08 18:30:00	AAPL	Stock	66.3025	66.375	66.275	66.375	26044.0
2020-04-08 19:00:00	AAPL	Stock	66.37	66.625	66.3375	66.625	49956.0
2020-04-08 19:30:00	AAPL	Stock	66.62	66.84	66.55	66.84	156240.0
2020-04-08 04:00:00	MSFT	Stock	164.44	164.44	163.4	163.64	3013.0
2020-04-08 04:30:00	MSFT	Stock	163.4	163.5	163.0	163.5	3270.0
2020-04-08 05:00:00	MSFT	Stock	163.24	163.48	163.24	163.48	200.0
2020-04-08 05:30:00	MSFT	Stock	163.65	163.65	163.11	163.5	3335.0
2020-04-08 06:00:00	MSFT	Stock	163.7	163.89	163.48	163.89	905.0
2020-04-08 06:30:00	MSFT	Stock	164.1	164.6	164.1	164.6	3384.0
2020-04-08 07:00:00	MSFT	Stock	164.48	165.5	164.23	165.2	37902.0
2020-04-08 07:30:00	MSFT	Stock	165.3	165.38	164.7	165.0	32566.0
2020-04-08 08:00:00	MSFT	Stock	164.6	165.9	164.5	165.74	44990.0
2020-04-08 08:30:00	MSFT	Stock	165.74	165.92	165.16	165.39	113064.0
2020-04-08 09:00:00	MSFT	Stock	165.31	165.94	165.25	165.85	78571.0
2020-04-08 09:30:00	MSFT	Stock	165.67	166.67	164.13	164.4	4622004.0
2020-04-08 10:00:00	MSFT	Stock	164.4	164.8	163.71	164.66	2777604.0
2020-04-08 10:30:00	MSFT	Stock	164.665	165.22	164.04	165.12	1901660.0
2020-04-08 11:00:00	MSFT	Stock	165.1	165.63	164.38	165.41	2358986.0
2020-04-08 11:30:00	MSFT	Stock	165.42	165.99	165.22	165.32	2189868.0
2020-04-08 12:00:00	MSFT	Stock	165.35	165.4	164.65	164.803	2385701.0
2020-04-08 12:30:00	MSFT	Stock	164.81	165.79	164.58	165.19	2012597.0

> showing 50 of 92,164 rows — these rows as CSV

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