PREVIEW / stock_30min / 2019-03-08

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-03-08.parquet
  size:    1.7 MB
  rows:    84,965
  symbols: 2,647

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-03-08 04:00:00	AAPL	Stock	42.9725	42.9725	42.925	42.925	8088.0
2019-03-08 04:30:00	AAPL	Stock	42.9	42.9025	42.81	42.875	10388.0
2019-03-08 05:00:00	AAPL	Stock	42.92	42.9375	42.825	42.875	66364.0
2019-03-08 05:30:00	AAPL	Stock	42.8875	42.8875	42.875	42.88	22648.0
2019-03-08 06:00:00	AAPL	Stock	42.8775	42.8925	42.8775	42.8775	9584.0
2019-03-08 06:30:00	AAPL	Stock	42.9325	42.9325	42.8425	42.8425	11108.0
2019-03-08 07:00:00	AAPL	Stock	42.8825	42.9125	42.8325	42.8625	58720.0
2019-03-08 07:30:00	AAPL	Stock	42.8575	42.8875	42.8125	42.815	107384.0
2019-03-08 08:00:00	AAPL	Stock	42.85	42.925	42.7905	42.865	123772.0
2019-03-08 08:30:00	AAPL	Stock	42.8325	43.125	42.5825	42.595	798396.0
2019-03-08 09:00:00	AAPL	Stock	42.5925	42.6	42.4775	42.57	466936.0
2019-03-08 09:30:00	AAPL	Stock	42.5725	42.8675	42.375	42.795	14517884.0
2019-03-08 10:00:00	AAPL	Stock	42.7925	42.945	42.6702	42.895	7982708.0
2019-03-08 10:30:00	AAPL	Stock	42.8975	42.9925	42.78	42.8975	5521896.0
2019-03-08 11:00:00	AAPL	Stock	42.8925	43.0675	42.8725	42.9975	5373356.0
2019-03-08 11:30:00	AAPL	Stock	42.9952	43.015	42.9075	42.92	3531544.0
2019-03-08 12:00:00	AAPL	Stock	42.9225	42.9475	42.8125	42.8825	3517304.0
2019-03-08 12:30:00	AAPL	Stock	42.885	42.9175	42.8175	42.835	2349476.0
2019-03-08 13:00:00	AAPL	Stock	42.835	42.8775	42.8075	42.836	2615224.0
2019-03-08 13:30:00	AAPL	Stock	42.8375	42.9525	42.81	42.9512	2817328.0
2019-03-08 14:00:00	AAPL	Stock	42.9525	43.0175	42.91	42.9875	2964304.0
2019-03-08 14:30:00	AAPL	Stock	42.99	43.1875	42.985	43.125	5077528.0
2019-03-08 15:00:00	AAPL	Stock	43.12	43.1875	42.995	43.0375	5340096.0
2019-03-08 15:30:00	AAPL	Stock	43.03	43.2675	43.0075	43.23	9657436.0
2019-03-08 16:00:00	AAPL	Stock	43.2275	43.3625	43.22	43.31	14549576.0
2019-03-08 16:30:00	AAPL	Stock	43.3075	43.3075	43.26	43.29	45372.0
2019-03-08 17:00:00	AAPL	Stock	43.275	43.295	43.275	43.275	22688.0
2019-03-08 17:30:00	AAPL	Stock	43.2675	43.275	43.2625	43.275	11992.0
2019-03-08 18:00:00	AAPL	Stock	43.275	43.275	43.2625	43.275	9116.0
2019-03-08 18:30:00	AAPL	Stock	43.265	43.265	43.25	43.25	7488.0
2019-03-08 19:00:00	AAPL	Stock	43.275	43.2875	43.275	43.2875	2468.0
2019-03-08 19:30:00	AAPL	Stock	43.265	43.2975	43.2525	43.2525	9340.0
2019-03-08 04:00:00	MSFT	Stock	109.75	109.9	109.75	109.85	2718.0
2019-03-08 05:00:00	MSFT	Stock	109.48	109.48	109.26	109.3	2805.0
2019-03-08 05:30:00	MSFT	Stock	109.34	109.34	109.32	109.32	500.0
2019-03-08 06:00:00	MSFT	Stock	109.5	109.7	109.5	109.7	1300.0
2019-03-08 06:30:00	MSFT	Stock	109.66	109.66	109.64	109.64	1787.0
2019-03-08 07:00:00	MSFT	Stock	109.64	109.65	109.6	109.65	4342.0
2019-03-08 07:30:00	MSFT	Stock	109.65	109.71	109.56	109.62	2810.0
2019-03-08 08:00:00	MSFT	Stock	109.55	109.7	109.51	109.65	9345.0
2019-03-08 08:30:00	MSFT	Stock	109.7	110.39	109.2	109.31	203724.0
2019-03-08 09:00:00	MSFT	Stock	109.26	109.36	109.06	109.26	72194.0
2019-03-08 09:30:00	MSFT	Stock	109.16	109.62	108.8	109.2	3401141.0
2019-03-08 10:00:00	MSFT	Stock	109.205	109.498	109.02	109.43	1909285.0
2019-03-08 10:30:00	MSFT	Stock	109.44	109.765	109.2	109.41	1269166.0
2019-03-08 11:00:00	MSFT	Stock	109.41	109.88	109.36	109.73	1153497.0
2019-03-08 11:30:00	MSFT	Stock	109.74	109.855	109.535	109.61	722275.0
2019-03-08 12:00:00	MSFT	Stock	109.62	109.7	109.24	109.49	1074891.0
2019-03-08 12:30:00	MSFT	Stock	109.487	109.54	109.34	109.43	912336.0
2019-03-08 13:00:00	MSFT	Stock	109.42	109.58	109.375	109.55	699577.0

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

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