PREVIEW / stock_30min / 2018-04-25

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-04-25.parquet
  size:    1.6 MB
  rows:    82,689
  symbols: 2,852

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
2018-04-25 04:00:00	AAPL	Stock	40.775	40.795	40.6	40.6	6920.0
2018-04-25 04:30:00	AAPL	Stock	40.6025	40.6025	40.525	40.525	5024.0
2018-04-25 05:00:00	AAPL	Stock	40.5275	40.5475	40.5275	40.5475	3496.0
2018-04-25 05:30:00	AAPL	Stock	40.6025	40.6025	40.6	40.6	2400.0
2018-04-25 06:00:00	AAPL	Stock	40.6025	40.675	40.6025	40.675	22160.0
2018-04-25 06:30:00	AAPL	Stock	40.6125	40.6125	40.6125	40.6125	3360.0
2018-04-25 07:00:00	AAPL	Stock	40.55	40.55	40.475	40.4925	99876.0
2018-04-25 07:30:00	AAPL	Stock	40.52	40.62	40.52	40.62	79764.0
2018-04-25 08:00:00	AAPL	Stock	40.5475	40.65	40.46	40.645	136376.0
2018-04-25 08:30:00	AAPL	Stock	40.6375	40.6875	40.59	40.6475	149972.0
2018-04-25 09:00:00	AAPL	Stock	40.65	40.725	40.6252	40.675	110696.0
2018-04-25 09:30:00	AAPL	Stock	40.655	41.145	40.6025	40.925	16794612.0
2018-04-25 10:00:00	AAPL	Stock	40.9263	41.1225	40.7825	41.085	11023452.0
2018-04-25 10:30:00	AAPL	Stock	41.0875	41.26	41.06	41.2	8525128.0
2018-04-25 11:00:00	AAPL	Stock	41.1975	41.29	41.125	41.213	6297792.0
2018-04-25 11:30:00	AAPL	Stock	41.2148	41.2275	41.0125	41.1275	6382484.0
2018-04-25 12:00:00	AAPL	Stock	41.1275	41.2225	41.0275	41.2175	4219020.0
2018-04-25 12:30:00	AAPL	Stock	41.2212	41.275	41.1425	41.1775	3427828.0
2018-04-25 13:00:00	AAPL	Stock	41.18	41.2875	41.1585	41.2175	3418600.0
2018-04-25 13:30:00	AAPL	Stock	41.22	41.355	41.21	41.246	4966524.0
2018-04-25 14:00:00	AAPL	Stock	41.25	41.265	41.07	41.08	3638196.0
2018-04-25 14:30:00	AAPL	Stock	41.08	41.2525	41.0425	41.25	4643888.0
2018-04-25 15:00:00	AAPL	Stock	41.25	41.2925	41.0775	41.12	6067792.0
2018-04-25 15:30:00	AAPL	Stock	41.125	41.1625	40.835	40.943	11542004.0
2018-04-25 16:00:00	AAPL	Stock	40.9525	41.14	40.895	41.075	9990360.0
2018-04-25 16:30:00	AAPL	Stock	41.095	41.1	40.9125	41.0375	408024.0
2018-04-25 17:00:00	AAPL	Stock	41.05	41.15	40.9125	41.1475	199200.0
2018-04-25 17:30:00	AAPL	Stock	41.145	41.17	41.0675	41.17	30016.0
2018-04-25 18:00:00	AAPL	Stock	41.17	41.1875	41.125	41.175	34864.0
2018-04-25 18:30:00	AAPL	Stock	41.155	41.1875	41.1125	41.175	8664.0
2018-04-25 19:00:00	AAPL	Stock	41.1625	41.22	41.1625	41.2075	22276.0
2018-04-25 19:30:00	AAPL	Stock	41.22	41.2475	41.1625	41.2475	36820.0
2018-04-25 04:00:00	MSFT	Stock	93.0	93.0	93.0	93.0	840.0
2018-04-25 05:00:00	MSFT	Stock	92.67	92.67	92.67	92.67	1600.0
2018-04-25 05:30:00	MSFT	Stock	92.6	92.6	92.6	92.6	400.0
2018-04-25 07:00:00	MSFT	Stock	92.95	93.2	92.37	92.4	11679.0
2018-04-25 07:30:00	MSFT	Stock	92.4	92.94	92.36	92.85	12782.0
2018-04-25 08:00:00	MSFT	Stock	92.35	92.99	92.35	92.98	26132.0
2018-04-25 08:30:00	MSFT	Stock	92.98	93.14	92.98	93.14	13946.0
2018-04-25 09:00:00	MSFT	Stock	93.03	93.28	93.03	93.1	12084.0
2018-04-25 09:30:00	MSFT	Stock	93.14	93.3	90.64	90.705	4829731.0
2018-04-25 10:00:00	MSFT	Stock	90.71	91.54	90.28	91.43	3625199.0
2018-04-25 10:30:00	MSFT	Stock	91.43	91.88	91.33	91.68	3028013.0
2018-04-25 11:00:00	MSFT	Stock	91.69	92.24	91.655	92.16	2022110.0
2018-04-25 11:30:00	MSFT	Stock	92.17	92.29	91.28	91.32	1646214.0
2018-04-25 12:00:00	MSFT	Stock	91.32	91.95	91.28	91.86	1084687.0
2018-04-25 12:30:00	MSFT	Stock	91.86	92.28	91.78	91.87	1123321.0
2018-04-25 13:00:00	MSFT	Stock	91.855	92.19	91.7	91.81	849397.0
2018-04-25 13:30:00	MSFT	Stock	91.82	92.37	91.81	92.235	1115060.0
2018-04-25 14:00:00	MSFT	Stock	92.235	92.32	91.6	91.725	1351042.0

> showing 50 of 82,689 rows — these rows as CSV

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