PREVIEW / stock_30min / 2020-09-14

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-09-14.parquet
  size:    1.9 MB
  rows:    96,681
  symbols: 2,501

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-09-14 04:00:00	AAPL	Stock	114.65	115.15	114.21	114.29	62994.0
2020-09-14 04:30:00	AAPL	Stock	114.12	114.5	113.9	114.19	42123.0
2020-09-14 05:00:00	AAPL	Stock	114.18	114.58	114.07	114.51	16251.0
2020-09-14 05:30:00	AAPL	Stock	114.57	114.61	113.8	114.2	19351.0
2020-09-14 06:00:00	AAPL	Stock	114.12	114.57	114.1	114.11	22649.0
2020-09-14 06:30:00	AAPL	Stock	114.2	114.98	114.2	114.8	25235.0
2020-09-14 07:00:00	AAPL	Stock	114.75	114.87	113.8	114.1	386800.0
2020-09-14 07:30:00	AAPL	Stock	114.12	114.15	113.7	113.77	214804.0
2020-09-14 08:00:00	AAPL	Stock	114.16	114.69	113.49	113.72	699480.0
2020-09-14 08:30:00	AAPL	Stock	113.7	114.1	113.59	113.87	325410.0
2020-09-14 09:00:00	AAPL	Stock	113.88	114.89	113.67	114.73	628422.0
2020-09-14 09:30:00	AAPL	Stock	114.72	115.71	113.52	114.83	18718885.0
2020-09-14 10:00:00	AAPL	Stock	114.81	115.42	114.425	115.003	10046973.0
2020-09-14 10:30:00	AAPL	Stock	115.0	115.02	113.85	114.5	9847814.0
2020-09-14 11:00:00	AAPL	Stock	114.49	114.55	113.67	114.15	6867295.0
2020-09-14 11:30:00	AAPL	Stock	114.15	114.75	114.06	114.512	5350059.0
2020-09-14 12:00:00	AAPL	Stock	114.51	114.81	114.021	114.11	5783274.0
2020-09-14 12:30:00	AAPL	Stock	114.12	114.6	114.0	114.34	4461138.0
2020-09-14 13:00:00	AAPL	Stock	114.35	114.48	113.19	113.644	7044920.0
2020-09-14 13:30:00	AAPL	Stock	113.625	113.87	112.8	113.72	5651087.0
2020-09-14 14:00:00	AAPL	Stock	113.72	114.49	113.43	113.94	7147429.0
2020-09-14 14:30:00	AAPL	Stock	113.95	114.61	113.94	114.438	6234505.0
2020-09-14 15:00:00	AAPL	Stock	114.45	114.86	114.2	114.55	6734574.0
2020-09-14 15:30:00	AAPL	Stock	114.56	115.93	114.53	115.36	14684201.0
2020-09-14 16:00:00	AAPL	Stock	115.35	115.95	115.13	115.91	9821601.0
2020-09-14 16:30:00	AAPL	Stock	115.91	115.93	115.355	115.63	204250.0
2020-09-14 17:00:00	AAPL	Stock	115.62	115.79	115.51	115.79	101676.0
2020-09-14 17:30:00	AAPL	Stock	115.75	115.94	115.75	115.88	136938.0
2020-09-14 18:00:00	AAPL	Stock	115.88	116.0	115.76	115.85	111584.0
2020-09-14 18:30:00	AAPL	Stock	115.86	115.95	115.75	115.94	85894.0
2020-09-14 19:00:00	AAPL	Stock	115.93	115.95	115.88	115.9	83281.0
2020-09-14 19:30:00	AAPL	Stock	115.92	115.95	115.75	115.94	196063.0
2020-09-14 04:00:00	MSFT	Stock	203.93	204.0	202.31	203.3	40694.0
2020-09-14 04:30:00	MSFT	Stock	203.15	203.38	203.1	203.3	7138.0
2020-09-14 05:00:00	MSFT	Stock	203.28	203.3	203.15	203.2	4720.0
2020-09-14 05:30:00	MSFT	Stock	203.45	203.45	203.0	203.0	6081.0
2020-09-14 06:00:00	MSFT	Stock	203.2	203.54	203.2	203.48	4059.0
2020-09-14 06:30:00	MSFT	Stock	203.5	204.77	203.5	204.5	4230.0
2020-09-14 07:00:00	MSFT	Stock	204.38	204.5	203.3	203.61	63775.0
2020-09-14 07:30:00	MSFT	Stock	203.61	203.61	202.75	202.75	49476.0
2020-09-14 08:00:00	MSFT	Stock	203.35	204.115	202.349	203.0	101553.0
2020-09-14 08:30:00	MSFT	Stock	203.0	203.81	203.0	203.27	55227.0
2020-09-14 09:00:00	MSFT	Stock	203.25	204.5	202.97	204.34	72651.0
2020-09-14 09:30:00	MSFT	Stock	204.27	207.84	204.03	207.28	3756715.0
2020-09-14 10:00:00	MSFT	Stock	207.31	209.09	206.87	208.87	2163707.0
2020-09-14 10:30:00	MSFT	Stock	208.86	209.2	208.015	208.59	1462316.0
2020-09-14 11:00:00	MSFT	Stock	208.54	208.85	207.66	208.115	1069872.0
2020-09-14 11:30:00	MSFT	Stock	208.14	208.78	207.92	208.07	773533.0
2020-09-14 12:00:00	MSFT	Stock	208.06	208.37	207.08	207.479	862203.0
2020-09-14 12:30:00	MSFT	Stock	207.49	207.68	206.68	206.94	818428.0

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

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