PREVIEW / stock_30min / 2020-10-13

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-10-13.parquet
  size:    1.9 MB
  rows:    96,852
  symbols: 2,487

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-10-13 04:00:00	AAPL	Stock	124.84	125.9	124.5	125.65	195620.0
2020-10-13 04:30:00	AAPL	Stock	125.61	126.18	125.61	126.05	82215.0
2020-10-13 05:00:00	AAPL	Stock	126.06	126.49	125.89	126.37	102741.0
2020-10-13 05:30:00	AAPL	Stock	126.37	126.99	126.35	126.97	110753.0
2020-10-13 06:00:00	AAPL	Stock	126.97	127.32	126.76	127.2	196461.0
2020-10-13 06:30:00	AAPL	Stock	127.17	127.2	126.21	126.5	171350.0
2020-10-13 07:00:00	AAPL	Stock	126.5	126.6	124.4	126.42	925994.0
2020-10-13 07:30:00	AAPL	Stock	126.42	126.54	126.06	126.23	359893.0
2020-10-13 08:00:00	AAPL	Stock	125.9	126.6	125.3	126.18	1575028.0
2020-10-13 08:30:00	AAPL	Stock	126.16	126.47	125.71	125.81	992478.0
2020-10-13 09:00:00	AAPL	Stock	125.81	125.83	125.0	125.31	1535125.0
2020-10-13 09:30:00	AAPL	Stock	125.31	125.39	121.52	122.871	33593835.0
2020-10-13 10:00:00	AAPL	Stock	122.87	123.92	122.51	123.757	15589196.0
2020-10-13 10:30:00	AAPL	Stock	123.757	123.88	123.031	123.53	12521632.0
2020-10-13 11:00:00	AAPL	Stock	123.53	124.74	123.51	124.42	12047797.0
2020-10-13 11:30:00	AAPL	Stock	124.42	124.65	123.14	123.73	13131343.0
2020-10-13 12:00:00	AAPL	Stock	123.73	123.76	122.46	123.08	10991186.0
2020-10-13 12:30:00	AAPL	Stock	123.09	123.106	122.2	122.64	9238209.0
2020-10-13 13:00:00	AAPL	Stock	122.62	123.68	120.78	122.58	27962413.0
2020-10-13 13:30:00	AAPL	Stock	122.59	122.67	119.65	120.39	25305418.0
2020-10-13 14:00:00	AAPL	Stock	120.39	121.46	119.875	120.89	20856588.0
2020-10-13 14:30:00	AAPL	Stock	120.89	121.43	120.47	121.32	12301205.0
2020-10-13 15:00:00	AAPL	Stock	121.312	122.2	121.2	121.8	13006741.0
2020-10-13 15:30:00	AAPL	Stock	121.8	122.05	121.03	121.05	14851181.0
2020-10-13 16:00:00	AAPL	Stock	121.1	122.395	121.0	121.27	10666152.0
2020-10-13 16:30:00	AAPL	Stock	121.25	121.35	120.55	120.85	372703.0
2020-10-13 17:00:00	AAPL	Stock	120.82	120.89	120.7	120.74	148216.0
2020-10-13 17:30:00	AAPL	Stock	120.72	121.07	120.71	120.945	186698.0
2020-10-13 18:00:00	AAPL	Stock	120.94	121.35	120.88	121.35	244918.0
2020-10-13 18:30:00	AAPL	Stock	121.33	121.48	121.21	121.22	165032.0
2020-10-13 19:00:00	AAPL	Stock	121.27	121.44	121.19	121.38	102322.0
2020-10-13 19:30:00	AAPL	Stock	121.37	121.42	121.19	121.29	191276.0
2020-10-13 04:00:00	MSFT	Stock	220.48	221.3	220.48	221.1	1832.0
2020-10-13 04:30:00	MSFT	Stock	221.3	222.38	221.3	222.37	1254.0
2020-10-13 05:00:00	MSFT	Stock	222.61	223.89	222.61	223.82	6173.0
2020-10-13 05:30:00	MSFT	Stock	223.78	223.9	223.26	223.48	4435.0
2020-10-13 06:00:00	MSFT	Stock	223.8	224.5	223.22	224.48	13006.0
2020-10-13 06:30:00	MSFT	Stock	224.82	224.82	223.22	223.68	10134.0
2020-10-13 07:00:00	MSFT	Stock	223.8	224.4	223.32	224.1	79018.0
2020-10-13 07:30:00	MSFT	Stock	224.09	224.25	223.77	224.0	38283.0
2020-10-13 08:00:00	MSFT	Stock	223.852	224.4	220.85	223.82	66982.0
2020-10-13 08:30:00	MSFT	Stock	223.89	224.21	222.32	222.781	56728.0
2020-10-13 09:00:00	MSFT	Stock	222.77	223.67	222.0	222.47	69231.0
2020-10-13 09:30:00	MSFT	Stock	222.47	222.96	221.51	222.05	3094678.0
2020-10-13 10:00:00	MSFT	Stock	222.12	222.376	220.43	221.81	1698186.0
2020-10-13 10:30:00	MSFT	Stock	221.78	223.11	221.06	223.09	1409280.0
2020-10-13 11:00:00	MSFT	Stock	223.08	224.25	222.39	223.8	1474254.0
2020-10-13 11:30:00	MSFT	Stock	223.81	224.65	223.8	224.01	1341824.0
2020-10-13 12:00:00	MSFT	Stock	224.01	224.35	222.624	223.353	1050178.0
2020-10-13 12:30:00	MSFT	Stock	223.34	223.73	222.86	223.52	950318.0

> showing 50 of 96,852 rows — these rows as CSV

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