PREVIEW / stock_30min / 2020-02-20

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-02-20.parquet
  size:    1.8 MB
  rows:    87,315
  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-02-20 04:00:00	AAPL	Stock	80.8225	80.8625	80.75	80.75	18796.0
2020-02-20 04:30:00	AAPL	Stock	80.825	80.825	80.825	80.825	1924.0
2020-02-20 05:00:00	AAPL	Stock	80.775	80.775	80.775	80.775	5600.0
2020-02-20 05:30:00	AAPL	Stock	80.75	80.75	80.75	80.75	400.0
2020-02-20 06:30:00	AAPL	Stock	80.71	80.71	80.675	80.675	3076.0
2020-02-20 07:00:00	AAPL	Stock	80.7	80.8125	80.625	80.725	110764.0
2020-02-20 07:30:00	AAPL	Stock	80.6725	80.775	80.65	80.775	39100.0
2020-02-20 08:00:00	AAPL	Stock	80.75	80.8088	80.625	80.675	100872.0
2020-02-20 08:30:00	AAPL	Stock	80.68	80.7775	80.51	80.645	205644.0
2020-02-20 09:00:00	AAPL	Stock	80.625	80.685	80.61	80.6425	113148.0
2020-02-20 09:30:00	AAPL	Stock	80.6575	81.1625	80.645	81.095	10669420.0
2020-02-20 10:00:00	AAPL	Stock	81.0975	81.135	80.735	80.8475	6029536.0
2020-02-20 10:30:00	AAPL	Stock	80.845	81.0125	80.665	80.6982	4797836.0
2020-02-20 11:00:00	AAPL	Stock	80.7	80.715	80.1275	80.1775	8100560.0
2020-02-20 11:30:00	AAPL	Stock	80.1725	80.24	79.5525	79.9725	10107388.0
2020-02-20 12:00:00	AAPL	Stock	79.965	80.0265	79.675	79.79	5653296.0
2020-02-20 12:30:00	AAPL	Stock	79.795	80.074	79.6525	80.06	4829792.0
2020-02-20 13:00:00	AAPL	Stock	80.0525	80.265	79.9175	80.0775	3988420.0
2020-02-20 13:30:00	AAPL	Stock	80.0762	80.17	79.875	79.9262	2549452.0
2020-02-20 14:00:00	AAPL	Stock	79.93	80.25	79.93	79.995	3093208.0
2020-02-20 14:30:00	AAPL	Stock	79.9955	80.2947	79.98	80.095	4053456.0
2020-02-20 15:00:00	AAPL	Stock	80.1025	80.155	79.925	80.0525	3312504.0
2020-02-20 15:30:00	AAPL	Stock	80.0512	80.1875	79.9525	80.075	6883868.0
2020-02-20 16:00:00	AAPL	Stock	80.075	80.1225	80.005	80.0325	6387424.0
2020-02-20 16:30:00	AAPL	Stock	80.0075	80.075	79.9425	79.9425	77084.0
2020-02-20 17:00:00	AAPL	Stock	79.9375	79.9375	79.8875	79.91	32936.0
2020-02-20 17:30:00	AAPL	Stock	79.89	79.9	79.845	79.87	35528.0
2020-02-20 18:00:00	AAPL	Stock	79.875	79.9175	79.6375	79.6375	66920.0
2020-02-20 18:30:00	AAPL	Stock	79.69	79.75	79.45	79.5	104288.0
2020-02-20 19:00:00	AAPL	Stock	79.5	79.7125	79.4975	79.675	43032.0
2020-02-20 19:30:00	AAPL	Stock	79.7475	79.875	79.675	79.795	79088.0
2020-02-20 04:00:00	MSFT	Stock	187.15	187.2	187.0	187.0	665.0
2020-02-20 05:00:00	MSFT	Stock	186.95	187.0	186.74	187.0	1906.0
2020-02-20 06:30:00	MSFT	Stock	187.0	187.0	187.0	187.0	300.0
2020-02-20 07:00:00	MSFT	Stock	186.99	186.99	186.75	186.8	6562.0
2020-02-20 07:30:00	MSFT	Stock	186.81	186.97	186.75	186.95	4493.0
2020-02-20 08:00:00	MSFT	Stock	186.8	187.74	186.75	186.9	21338.0
2020-02-20 08:30:00	MSFT	Stock	186.9	186.97	186.62	186.9	18171.0
2020-02-20 09:00:00	MSFT	Stock	186.84	187.0	186.84	187.0	14348.0
2020-02-20 09:30:00	MSFT	Stock	186.98	187.25	185.852	186.55	2790945.0
2020-02-20 10:00:00	MSFT	Stock	186.54	186.58	185.97	186.215	1665259.0
2020-02-20 10:30:00	MSFT	Stock	186.21	186.89	186.11	186.3	1432410.0
2020-02-20 11:00:00	MSFT	Stock	186.28	186.28	183.64	183.68	2944320.0
2020-02-20 11:30:00	MSFT	Stock	183.67	183.827	181.1	183.33	5160881.0
2020-02-20 12:00:00	MSFT	Stock	183.31	183.31	182.27	182.62	2184570.0
2020-02-20 12:30:00	MSFT	Stock	182.64	183.455	182.35	183.415	1660190.0
2020-02-20 13:00:00	MSFT	Stock	183.41	184.32	183.16	183.662	1474269.0
2020-02-20 13:30:00	MSFT	Stock	183.658	183.87	182.97	183.04	1175617.0
2020-02-20 14:00:00	MSFT	Stock	183.05	184.27	183.04	184.07	1339007.0
2020-02-20 14:30:00	MSFT	Stock	184.05	184.73	183.912	184.19	1326988.0

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

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