PREVIEW / stock_30min / 2020-08-28

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-08-28.parquet
  size:    1.9 MB
  rows:    95,247
  symbols: 2,459

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
2020-08-28 04:00:00	AAPL	Stock	125.2525	125.625	125.2525	125.54	28044.0
2020-08-28 04:30:00	AAPL	Stock	125.575	125.625	125.2025	125.4625	9740.0
2020-08-28 05:00:00	AAPL	Stock	125.375	125.375	125.375	125.375	1084.0
2020-08-28 05:30:00	AAPL	Stock	125.4125	125.4125	125.265	125.325	8024.0
2020-08-28 06:00:00	AAPL	Stock	125.3425	125.3425	125.1075	125.125	9128.0
2020-08-28 06:30:00	AAPL	Stock	125.125	125.225	125.125	125.225	4332.0
2020-08-28 07:00:00	AAPL	Stock	125.225	125.95	125.175	125.8575	343356.0
2020-08-28 07:30:00	AAPL	Stock	125.85	125.9	125.675	125.895	132916.0
2020-08-28 08:00:00	AAPL	Stock	125.895	125.986	125.01	125.835	572876.0
2020-08-28 08:30:00	AAPL	Stock	125.825	125.87	125.6625	125.775	320604.0
2020-08-28 09:00:00	AAPL	Stock	125.805	126.285	125.795	126.02	647200.0
2020-08-28 09:30:00	AAPL	Stock	126.0075	126.26	124.8575	125.875	17739504.0
2020-08-28 10:00:00	AAPL	Stock	125.875	125.88	125.2925	125.7	8201292.0
2020-08-28 10:30:00	AAPL	Stock	125.6925	125.7575	125.0575	125.127	6335752.0
2020-08-28 11:00:00	AAPL	Stock	125.1185	125.895	125.0	125.875	7216100.0
2020-08-28 11:30:00	AAPL	Stock	125.8725	125.885	125.4142	125.6075	4744512.0
2020-08-28 12:00:00	AAPL	Stock	125.5925	125.675	125.3375	125.41	4030096.0
2020-08-28 12:30:00	AAPL	Stock	125.4175	125.4625	125.125	125.3625	4213668.0
2020-08-28 13:00:00	AAPL	Stock	125.36	125.4075	124.8225	124.8325	5896764.0
2020-08-28 13:30:00	AAPL	Stock	124.8325	125.2325	124.5775	125.03	7233232.0
2020-08-28 14:00:00	AAPL	Stock	125.035	125.36	124.92	125.0375	6038216.0
2020-08-28 14:30:00	AAPL	Stock	125.04	125.675	124.9425	125.1962	8341300.0
2020-08-28 15:00:00	AAPL	Stock	125.1962	125.5825	125.1275	125.375	7324396.0
2020-08-28 15:30:00	AAPL	Stock	125.38	126.4425	124.705	124.725	29207312.0
2020-08-28 16:00:00	AAPL	Stock	124.8075	125.341	124.695	124.955	28335968.0
2020-08-28 16:30:00	AAPL	Stock	124.96	125.02	124.8075	124.985	735784.0
2020-08-28 17:00:00	AAPL	Stock	124.975	125.045	124.89	124.995	197332.0
2020-08-28 17:30:00	AAPL	Stock	124.9925	125.2875	124.9025	125.275	178880.0
2020-08-28 18:00:00	AAPL	Stock	125.2525	125.3125	125.175	125.25	68104.0
2020-08-28 18:30:00	AAPL	Stock	125.25	125.3125	125.215	125.2675	48936.0
2020-08-28 19:00:00	AAPL	Stock	125.2575	125.425	125.2575	125.4	69896.0
2020-08-28 19:30:00	AAPL	Stock	125.4225	125.5	125.3125	125.495	131732.0
2020-08-28 04:00:00	MSFT	Stock	228.8	228.8	227.2	228.09	3223.0
2020-08-28 04:30:00	MSFT	Stock	227.9	227.95	227.13	227.5	3329.0
2020-08-28 05:00:00	MSFT	Stock	227.13	227.95	227.13	227.8	1145.0
2020-08-28 05:30:00	MSFT	Stock	227.5	227.8	227.37	227.76	1855.0
2020-08-28 06:00:00	MSFT	Stock	227.3	227.4	227.02	227.4	2591.0
2020-08-28 06:30:00	MSFT	Stock	227.6	228.0	227.5	227.61	1319.0
2020-08-28 07:00:00	MSFT	Stock	227.95	228.15	227.22	227.48	24468.0
2020-08-28 07:30:00	MSFT	Stock	227.5	228.51	227.5	228.51	15874.0
2020-08-28 08:00:00	MSFT	Stock	227.55	228.646	226.58	227.8	159952.0
2020-08-28 08:30:00	MSFT	Stock	227.745	228.0	226.58	227.94	92799.0
2020-08-28 09:00:00	MSFT	Stock	227.601	228.31	227.5	228.08	47503.0
2020-08-28 09:30:00	MSFT	Stock	228.07	230.644	227.99	229.89	4246459.0
2020-08-28 10:00:00	MSFT	Stock	229.91	230.37	228.55	229.73	2026486.0
2020-08-28 10:30:00	MSFT	Stock	229.74	229.88	228.38	228.805	1479463.0
2020-08-28 11:00:00	MSFT	Stock	228.83	229.43	228.55	229.137	952515.0
2020-08-28 11:30:00	MSFT	Stock	229.12	229.3	228.74	228.95	774124.0
2020-08-28 12:00:00	MSFT	Stock	228.935	229.05	228.205	228.29	808914.0
2020-08-28 12:30:00	MSFT	Stock	228.307	228.6	228.11	228.51	778668.0

> showing 50 of 95,247 rows — these rows as CSV

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