PREVIEW / stock_30min / 2019-05-08

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-05-08.parquet
  size:    1.7 MB
  rows:    83,007
  symbols: 2,590

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-05-08 04:00:00	AAPL	Stock	50.7625	51.065	50.7625	50.995	22272.0
2019-05-08 04:30:00	AAPL	Stock	50.995	51.0675	50.9	50.935	26484.0
2019-05-08 05:00:00	AAPL	Stock	50.875	50.935	50.85	50.905	31464.0
2019-05-08 05:30:00	AAPL	Stock	50.8525	50.8525	50.6025	50.63	20132.0
2019-05-08 06:00:00	AAPL	Stock	50.6075	50.61	50.4875	50.55	63884.0
2019-05-08 06:30:00	AAPL	Stock	50.55	50.6275	50.55	50.6275	16072.0
2019-05-08 07:00:00	AAPL	Stock	50.625	50.6625	50.2675	50.3375	274884.0
2019-05-08 07:30:00	AAPL	Stock	50.33	50.36	50.175	50.3	137240.0
2019-05-08 08:00:00	AAPL	Stock	50.5475	50.6625	50.225	50.375	278284.0
2019-05-08 08:30:00	AAPL	Stock	50.375	50.675	50.2125	50.5525	851404.0
2019-05-08 09:00:00	AAPL	Stock	50.5525	50.575	50.4025	50.5075	433816.0
2019-05-08 09:30:00	AAPL	Stock	50.505	51.19	50.4375	51.1815	18281964.0
2019-05-08 10:00:00	AAPL	Stock	51.175	51.245	50.87	50.875	8556228.0
2019-05-08 10:30:00	AAPL	Stock	50.8775	51.2225	50.7425	51.215	6781312.0
2019-05-08 11:00:00	AAPL	Stock	51.2138	51.335	51.1025	51.1825	8852908.0
2019-05-08 11:30:00	AAPL	Stock	51.1875	51.2375	50.88	50.88	6014268.0
2019-05-08 12:00:00	AAPL	Stock	50.885	50.92	50.7525	50.8125	4572980.0
2019-05-08 12:30:00	AAPL	Stock	50.8175	51.0805	50.7575	51.06	4061744.0
2019-05-08 13:00:00	AAPL	Stock	51.065	51.13	50.98	51.0415	2912608.0
2019-05-08 13:30:00	AAPL	Stock	51.045	51.1125	51.0075	51.0775	2127648.0
2019-05-08 14:00:00	AAPL	Stock	51.0825	51.1	50.99	51.0685	2182780.0
2019-05-08 14:30:00	AAPL	Stock	51.0677	51.162	51.04	51.0952	2657184.0
2019-05-08 15:00:00	AAPL	Stock	51.0975	51.2125	51.08	51.1875	3044728.0
2019-05-08 15:30:00	AAPL	Stock	51.1912	51.2025	50.635	50.725	9717564.0
2019-05-08 16:00:00	AAPL	Stock	50.725	50.875	50.725	50.79	9514980.0
2019-05-08 16:30:00	AAPL	Stock	50.79	50.825	50.725	50.78	71768.0
2019-05-08 17:00:00	AAPL	Stock	50.78	50.8125	50.7575	50.7775	9564.0
2019-05-08 17:30:00	AAPL	Stock	50.7875	50.7875	50.725	50.7475	18804.0
2019-05-08 18:00:00	AAPL	Stock	50.7475	50.7775	50.7375	50.74	21900.0
2019-05-08 18:30:00	AAPL	Stock	50.7525	50.775	50.75	50.775	24120.0
2019-05-08 19:00:00	AAPL	Stock	50.7775	50.8	50.7625	50.7625	18468.0
2019-05-08 19:30:00	AAPL	Stock	50.78	50.795	50.75	50.775	19208.0
2019-05-08 04:00:00	MSFT	Stock	125.8	126.38	125.8	126.35	1100.0
2019-05-08 04:30:00	MSFT	Stock	126.19	126.4	125.85	125.88	1850.0
2019-05-08 05:00:00	MSFT	Stock	126.12	126.12	125.83	125.9	1248.0
2019-05-08 05:30:00	MSFT	Stock	125.93	125.93	125.5	125.5	1009.0
2019-05-08 06:30:00	MSFT	Stock	125.25	125.8	125.25	125.8	575.0
2019-05-08 07:00:00	MSFT	Stock	125.25	125.25	124.6	124.96	21127.0
2019-05-08 07:30:00	MSFT	Stock	124.86	125.01	124.75	124.92	8628.0
2019-05-08 08:00:00	MSFT	Stock	124.6	125.39	124.6	125.36	22552.0
2019-05-08 08:30:00	MSFT	Stock	125.39	125.89	124.69	125.15	30069.0
2019-05-08 09:00:00	MSFT	Stock	125.1	125.45	125.07	125.45	31068.0
2019-05-08 09:30:00	MSFT	Stock	125.47	125.84	124.75	125.33	3476078.0
2019-05-08 10:00:00	MSFT	Stock	125.33	125.79	125.28	125.36	2053341.0
2019-05-08 10:30:00	MSFT	Stock	125.37	125.88	124.985	125.86	1381283.0
2019-05-08 11:00:00	MSFT	Stock	125.86	126.18	125.55	125.75	2046941.0
2019-05-08 11:30:00	MSFT	Stock	125.76	125.88	125.29	125.53	1167876.0
2019-05-08 12:00:00	MSFT	Stock	125.54	125.81	125.34	125.78	710474.0
2019-05-08 12:30:00	MSFT	Stock	125.762	126.21	125.67	126.18	767670.0
2019-05-08 13:00:00	MSFT	Stock	126.19	126.31	125.92	126.16	630909.0

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

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