PREVIEW / stock_30min / 2019-08-29

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-08-29.parquet
  size:    1.7 MB
  rows:    84,926
  symbols: 2,579

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-08-29 04:00:00	AAPL	Stock	51.85	51.975	51.85	51.9375	12488.0
2019-08-29 04:30:00	AAPL	Stock	51.9625	52.0025	51.95	51.975	18668.0
2019-08-29 05:00:00	AAPL	Stock	52.0	52.125	52.0	52.1225	15600.0
2019-08-29 05:30:00	AAPL	Stock	52.12	52.2125	52.0925	52.2125	26300.0
2019-08-29 06:00:00	AAPL	Stock	52.195	52.2625	52.19	52.2	27352.0
2019-08-29 06:30:00	AAPL	Stock	52.175	52.25	52.175	52.25	29528.0
2019-08-29 07:00:00	AAPL	Stock	52.25	52.255	52.085	52.1625	141416.0
2019-08-29 07:30:00	AAPL	Stock	52.1275	52.1875	52.095	52.145	59896.0
2019-08-29 08:00:00	AAPL	Stock	52.2025	52.25	52.03	52.175	359264.0
2019-08-29 08:30:00	AAPL	Stock	52.1675	52.1875	52.0875	52.1375	171280.0
2019-08-29 09:00:00	AAPL	Stock	52.1	52.17	52.0425	52.15	244400.0
2019-08-29 09:30:00	AAPL	Stock	52.165	52.3075	52.03	52.0675	12743712.0
2019-08-29 10:00:00	AAPL	Stock	52.065	52.0775	51.94	52.0225	5044948.0
2019-08-29 10:30:00	AAPL	Stock	52.0225	52.0375	51.6638	51.9475	6103636.0
2019-08-29 11:00:00	AAPL	Stock	51.95	52.035	51.885	52.01	3405600.0
2019-08-29 11:30:00	AAPL	Stock	52.0175	52.065	51.99	52.01	3155912.0
2019-08-29 12:00:00	AAPL	Stock	52.01	52.22	51.9725	52.1025	6354820.0
2019-08-29 12:30:00	AAPL	Stock	52.1025	52.23	52.0925	52.1375	2695732.0
2019-08-29 13:00:00	AAPL	Stock	52.135	52.1995	52.1162	52.14	1919820.0
2019-08-29 13:30:00	AAPL	Stock	52.14	52.2225	52.1082	52.22	2293992.0
2019-08-29 14:00:00	AAPL	Stock	52.22	52.33	52.13	52.18	6356076.0
2019-08-29 14:30:00	AAPL	Stock	52.185	52.21	52.1025	52.14	2612700.0
2019-08-29 15:00:00	AAPL	Stock	52.1425	52.2	52.065	52.085	3733924.0
2019-08-29 15:30:00	AAPL	Stock	52.0855	52.275	52.0855	52.275	7329160.0
2019-08-29 16:00:00	AAPL	Stock	52.295	52.295	52.1235	52.2625	7654576.0
2019-08-29 16:30:00	AAPL	Stock	52.2525	52.2768	52.2275	52.2275	103300.0
2019-08-29 17:00:00	AAPL	Stock	52.23	52.2475	52.23	52.2475	16308.0
2019-08-29 17:30:00	AAPL	Stock	52.2475	52.25	52.205	52.2275	11592.0
2019-08-29 18:00:00	AAPL	Stock	52.2075	52.225	52.205	52.205	22040.0
2019-08-29 18:30:00	AAPL	Stock	52.2175	52.2175	52.1875	52.195	22976.0
2019-08-29 19:00:00	AAPL	Stock	52.2125	52.2125	52.1875	52.195	5760.0
2019-08-29 19:30:00	AAPL	Stock	52.19	52.25	52.175	52.2	29276.0
2019-08-29 04:00:00	MSFT	Stock	136.16	136.72	136.16	136.66	1922.0
2019-08-29 05:00:00	MSFT	Stock	136.91	137.49	136.91	137.3	2200.0
2019-08-29 05:30:00	MSFT	Stock	137.36	137.36	137.36	137.36	600.0
2019-08-29 06:00:00	MSFT	Stock	137.36	137.36	137.31	137.31	1723.0
2019-08-29 06:30:00	MSFT	Stock	137.31	137.31	137.3	137.3	300.0
2019-08-29 07:00:00	MSFT	Stock	137.28	137.4	136.9	137.05	45382.0
2019-08-29 07:30:00	MSFT	Stock	137.05	137.25	136.91	137.11	24776.0
2019-08-29 08:00:00	MSFT	Stock	137.15	137.3	136.914	137.2	32987.0
2019-08-29 08:30:00	MSFT	Stock	137.14	137.25	137.02	137.15	11132.0
2019-08-29 09:00:00	MSFT	Stock	137.15	137.27	137.02	137.19	20649.0
2019-08-29 09:30:00	MSFT	Stock	137.25	138.3	137.02	137.985	2963736.0
2019-08-29 10:00:00	MSFT	Stock	137.98	138.17	137.75	137.96	1354898.0
2019-08-29 10:30:00	MSFT	Stock	137.96	137.99	136.91	137.62	1482104.0
2019-08-29 11:00:00	MSFT	Stock	137.601	138.02	137.54	137.94	682419.0
2019-08-29 11:30:00	MSFT	Stock	137.95	138.2	137.93	138.02	803708.0
2019-08-29 12:00:00	MSFT	Stock	137.975	138.2	137.86	138.1	845350.0
2019-08-29 12:30:00	MSFT	Stock	138.1	138.42	138.01	138.14	905365.0
2019-08-29 13:00:00	MSFT	Stock	138.14	138.29	138.06	138.13	498204.0

> showing 50 of 84,926 rows — these rows as CSV

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