PREVIEW / stock_30min / 2019-09-30

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-09-30.parquet
  size:    1.7 MB
  rows:    83,922
  symbols: 2,522

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
2019-09-30 04:00:00	AAPL	Stock	55.0	55.25	55.0	55.1875	28800.0
2019-09-30 04:30:00	AAPL	Stock	55.15	55.15	55.1	55.1	12092.0
2019-09-30 05:00:00	AAPL	Stock	55.145	55.145	55.145	55.145	1200.0
2019-09-30 05:30:00	AAPL	Stock	55.1425	55.1675	55.1425	55.1675	800.0
2019-09-30 06:00:00	AAPL	Stock	55.205	55.22	55.205	55.22	14724.0
2019-09-30 06:30:00	AAPL	Stock	55.19	55.19	55.0675	55.0675	18260.0
2019-09-30 07:00:00	AAPL	Stock	55.0175	55.1375	54.97	55.1325	125184.0
2019-09-30 07:30:00	AAPL	Stock	55.1125	55.14	55.055	55.1	38920.0
2019-09-30 08:00:00	AAPL	Stock	55.1325	55.21	54.96	55.135	278308.0
2019-09-30 08:30:00	AAPL	Stock	55.125	55.1625	55.0275	55.14	180368.0
2019-09-30 09:00:00	AAPL	Stock	55.125	55.24	55.11	55.225	245036.0
2019-09-30 09:30:00	AAPL	Stock	55.225	55.5925	55.1975	55.4375	14312536.0
2019-09-30 10:00:00	AAPL	Stock	55.4312	55.535	55.29	55.4512	5339768.0
2019-09-30 10:30:00	AAPL	Stock	55.4525	55.6595	55.39	55.6595	5715612.0
2019-09-30 11:00:00	AAPL	Stock	55.6575	55.81	55.63	55.8062	6871504.0
2019-09-30 11:30:00	AAPL	Stock	55.8075	55.8575	55.745	55.7925	4212172.0
2019-09-30 12:00:00	AAPL	Stock	55.8	56.0	55.7975	55.9925	5179124.0
2019-09-30 12:30:00	AAPL	Stock	55.9925	56.1075	55.955	56.105	5149516.0
2019-09-30 13:00:00	AAPL	Stock	56.1075	56.145	55.985	55.9925	3992512.0
2019-09-30 13:30:00	AAPL	Stock	55.9975	56.09	55.9525	56.045	3485000.0
2019-09-30 14:00:00	AAPL	Stock	56.0475	56.06	55.875	56.0025	3852520.0
2019-09-30 14:30:00	AAPL	Stock	56.0075	56.0975	55.955	56.0275	3134736.0
2019-09-30 15:00:00	AAPL	Stock	56.035	56.075	55.98	56.02	4060344.0
2019-09-30 15:30:00	AAPL	Stock	56.02	56.0325	55.885	55.995	10431768.0
2019-09-30 16:00:00	AAPL	Stock	55.9925	56.1	55.9925	56.0875	10128012.0
2019-09-30 16:30:00	AAPL	Stock	56.0625	56.1	55.9925	56.0825	140056.0
2019-09-30 17:00:00	AAPL	Stock	56.0575	56.0925	56.055	56.0925	39516.0
2019-09-30 17:30:00	AAPL	Stock	56.0975	56.115	56.0775	56.095	55216.0
2019-09-30 18:00:00	AAPL	Stock	56.0975	56.16	56.075	56.085	82392.0
2019-09-30 18:30:00	AAPL	Stock	56.0875	56.125	56.05	56.0925	40212.0
2019-09-30 19:00:00	AAPL	Stock	56.0925	56.12	56.0825	56.12	17724.0
2019-09-30 19:30:00	AAPL	Stock	56.1175	56.1375	56.095	56.1325	29196.0
2019-09-30 04:00:00	MSFT	Stock	138.29	138.8	138.29	138.8	1273.0
2019-09-30 04:30:00	MSFT	Stock	138.6	138.83	138.6	138.62	2546.0
2019-09-30 05:00:00	MSFT	Stock	138.72	138.72	138.71	138.71	694.0
2019-09-30 05:30:00	MSFT	Stock	138.6	138.6	138.6	138.6	400.0
2019-09-30 06:00:00	MSFT	Stock	138.52	138.62	138.52	138.62	200.0
2019-09-30 06:30:00	MSFT	Stock	138.71	138.73	138.36	138.36	3491.0
2019-09-30 07:00:00	MSFT	Stock	138.48	138.48	138.2	138.3	6733.0
2019-09-30 07:30:00	MSFT	Stock	138.28	138.28	138.2	138.28	4822.0
2019-09-30 08:00:00	MSFT	Stock	138.24	138.39	138.07	138.07	22996.0
2019-09-30 08:30:00	MSFT	Stock	138.08	138.1	137.87	137.99	16489.0
2019-09-30 09:00:00	MSFT	Stock	137.86	138.25	137.86	138.13	12055.0
2019-09-30 09:30:00	MSFT	Stock	138.08	138.49	137.78	138.3	1487656.0
2019-09-30 10:00:00	MSFT	Stock	138.28	138.73	138.165	138.318	811365.0
2019-09-30 10:30:00	MSFT	Stock	138.32	138.46	138.155	138.416	527811.0
2019-09-30 11:00:00	MSFT	Stock	138.415	138.83	138.3	138.75	801866.0
2019-09-30 11:30:00	MSFT	Stock	138.76	138.81	138.59	138.72	451495.0
2019-09-30 12:00:00	MSFT	Stock	138.74	139.1	138.64	139.01	792531.0
2019-09-30 12:30:00	MSFT	Stock	139.02	139.18	138.94	139.068	493184.0

> showing 50 of 83,922 rows — these rows as CSV

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