PREVIEW / stock_30min / 2018-09-11

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-09-11.parquet
  size:    1.7 MB
  rows:    84,108
  symbols: 2,781

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-09-11 04:30:00	AAPL	Stock	54.8425	54.8425	54.625	54.625	14984.0
2018-09-11 05:00:00	AAPL	Stock	54.65	54.65	54.525	54.525	11708.0
2018-09-11 05:30:00	AAPL	Stock	54.575	54.625	54.575	54.625	12768.0
2018-09-11 06:00:00	AAPL	Stock	54.62	54.8125	54.6025	54.7	19480.0
2018-09-11 06:30:00	AAPL	Stock	54.7	54.7	54.625	54.695	26436.0
2018-09-11 07:00:00	AAPL	Stock	54.7275	54.7275	54.5825	54.6175	91840.0
2018-09-11 07:30:00	AAPL	Stock	54.6275	54.66	54.55	54.63	53288.0
2018-09-11 08:00:00	AAPL	Stock	54.675	54.75	54.5	54.625	199368.0
2018-09-11 08:30:00	AAPL	Stock	54.61	54.635	54.5	54.53	153520.0
2018-09-11 09:00:00	AAPL	Stock	54.5275	54.62	54.475	54.525	221224.0
2018-09-11 09:30:00	AAPL	Stock	54.485	54.845	54.14	54.68	18332532.0
2018-09-11 10:00:00	AAPL	Stock	54.6825	55.155	54.6425	55.025	10760012.0
2018-09-11 10:30:00	AAPL	Stock	55.0225	55.125	54.8825	55.11	6929048.0
2018-09-11 11:00:00	AAPL	Stock	55.1125	55.3325	55.105	55.2832	6746992.0
2018-09-11 11:30:00	AAPL	Stock	55.2825	55.7325	55.2825	55.7225	8534396.0
2018-09-11 12:00:00	AAPL	Stock	55.7225	55.9825	55.7175	55.7868	13857192.0
2018-09-11 12:30:00	AAPL	Stock	55.7875	55.925	55.705	55.919	6620624.0
2018-09-11 13:00:00	AAPL	Stock	55.9225	55.9475	55.7675	55.7675	5098740.0
2018-09-11 13:30:00	AAPL	Stock	55.765	55.9258	55.7375	55.92	4205760.0
2018-09-11 14:00:00	AAPL	Stock	55.9175	56.0525	55.815	56.0025	5885524.0
2018-09-11 14:30:00	AAPL	Stock	56.005	56.0748	55.9525	55.9825	4823224.0
2018-09-11 15:00:00	AAPL	Stock	55.9815	56.0125	55.8038	55.82	5709804.0
2018-09-11 15:30:00	AAPL	Stock	55.82	56.0125	55.765	55.965	13314080.0
2018-09-11 16:00:00	AAPL	Stock	55.9675	56.0425	55.9325	56.025	8406132.0
2018-09-11 16:30:00	AAPL	Stock	56.0375	56.0375	56.0	56.0175	54212.0
2018-09-11 17:00:00	AAPL	Stock	56.0175	56.0325	55.9625	56.0275	268712.0
2018-09-11 17:30:00	AAPL	Stock	56.025	56.0625	56.0125	56.0625	87756.0
2018-09-11 18:00:00	AAPL	Stock	56.0775	56.0875	56.0625	56.0675	78696.0
2018-09-11 18:30:00	AAPL	Stock	56.07	56.0875	56.0625	56.0825	38008.0
2018-09-11 19:00:00	AAPL	Stock	56.0825	56.11	56.05	56.0825	28748.0
2018-09-11 19:30:00	AAPL	Stock	56.0875	56.145	56.0675	56.1125	65076.0
2018-09-11 04:00:00	MSFT	Stock	109.47	109.47	108.86	108.86	270.0
2018-09-11 04:30:00	MSFT	Stock	109.2	109.2	109.2	109.2	297.0
2018-09-11 05:00:00	MSFT	Stock	109.15	109.15	109.15	109.15	100.0
2018-09-11 06:00:00	MSFT	Stock	109.2	109.3	109.2	109.3	9700.0
2018-09-11 06:30:00	MSFT	Stock	109.27	109.27	109.27	109.27	486.0
2018-09-11 07:00:00	MSFT	Stock	109.13	109.15	109.05	109.05	5279.0
2018-09-11 07:30:00	MSFT	Stock	109.0	109.0	108.81	108.97	8120.0
2018-09-11 08:00:00	MSFT	Stock	109.13	109.65	108.75	108.9	12244.0
2018-09-11 08:30:00	MSFT	Stock	108.98	108.98	108.86	108.86	3995.0
2018-09-11 09:00:00	MSFT	Stock	108.88	109.01	108.7	108.96	42730.0
2018-09-11 09:30:00	MSFT	Stock	108.96	110.39	108.89	110.17	2915267.0
2018-09-11 10:00:00	MSFT	Stock	110.17	110.73	110.148	110.68	1660112.0
2018-09-11 10:30:00	MSFT	Stock	110.69	110.7	110.25	110.3	919989.0
2018-09-11 11:00:00	MSFT	Stock	110.3	110.58	110.25	110.39	844894.0
2018-09-11 11:30:00	MSFT	Stock	110.395	111.29	110.39	111.25	1490892.0
2018-09-11 12:00:00	MSFT	Stock	111.25	111.44	111.135	111.17	1493825.0
2018-09-11 12:30:00	MSFT	Stock	111.18	111.25	110.975	111.15	657911.0
2018-09-11 13:00:00	MSFT	Stock	111.15	111.23	110.62	110.79	851648.0
2018-09-11 13:30:00	MSFT	Stock	110.79	111.0	110.78	110.93	616970.0

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

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