PREVIEW / stock_30min / 2019-10-11

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-10-11.parquet
  size:    1.7 MB
  rows:    83,807
  symbols: 2,526

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-10-11 04:00:00	AAPL	Stock	57.8525	58.125	57.8525	58.125	23628.0
2019-10-11 04:30:00	AAPL	Stock	58.185	58.25	58.125	58.175	36556.0
2019-10-11 05:00:00	AAPL	Stock	58.275	58.345	58.25	58.345	11692.0
2019-10-11 05:30:00	AAPL	Stock	58.2875	58.375	58.2325	58.235	31016.0
2019-10-11 06:00:00	AAPL	Stock	58.2375	58.2975	58.2125	58.2475	35320.0
2019-10-11 06:30:00	AAPL	Stock	58.1875	58.26	58.1775	58.195	14888.0
2019-10-11 07:00:00	AAPL	Stock	58.2275	58.3	58.15	58.25	266324.0
2019-10-11 07:30:00	AAPL	Stock	58.23	58.2775	58.2125	58.2375	101604.0
2019-10-11 08:00:00	AAPL	Stock	58.175	58.2975	57.38	58.2	500080.0
2019-10-11 08:30:00	AAPL	Stock	58.2125	58.2575	58.175	58.2025	181132.0
2019-10-11 09:00:00	AAPL	Stock	58.2025	58.25	58.1628	58.2475	322860.0
2019-10-11 09:30:00	AAPL	Stock	58.2375	58.455	58.077	58.4175	19204604.0
2019-10-11 10:00:00	AAPL	Stock	58.425	58.593	58.415	58.5675	11373528.0
2019-10-11 10:30:00	AAPL	Stock	58.5688	58.6	58.45	58.485	6653808.0
2019-10-11 11:00:00	AAPL	Stock	58.4875	58.6975	58.4825	58.6925	7664688.0
2019-10-11 11:30:00	AAPL	Stock	58.695	58.8	58.593	58.62	10201464.0
2019-10-11 12:00:00	AAPL	Stock	58.6235	58.665	58.5575	58.605	4913756.0
2019-10-11 12:30:00	AAPL	Stock	58.605	58.7175	58.27	58.7072	6338152.0
2019-10-11 13:00:00	AAPL	Stock	58.705	58.8225	58.6192	58.695	5312488.0
2019-10-11 13:30:00	AAPL	Stock	58.705	58.8575	58.65	58.825	5226068.0
2019-10-11 14:00:00	AAPL	Stock	58.8262	58.885	58.7275	58.8738	5970036.0
2019-10-11 14:30:00	AAPL	Stock	58.875	59.14	58.875	59.1225	9892580.0
2019-10-11 15:00:00	AAPL	Stock	59.1225	59.275	59.0375	59.2462	11636332.0
2019-10-11 15:30:00	AAPL	Stock	59.2475	59.41	58.96	59.055	28376584.0
2019-10-11 16:00:00	AAPL	Stock	59.0025	59.125	58.955	59.0475	9965904.0
2019-10-11 16:30:00	AAPL	Stock	59.0475	59.2	59.0425	59.0875	246524.0
2019-10-11 17:00:00	AAPL	Stock	59.085	59.175	59.075	59.175	130924.0
2019-10-11 17:30:00	AAPL	Stock	59.175	59.2125	59.165	59.1825	72700.0
2019-10-11 18:00:00	AAPL	Stock	59.195	59.235	59.19	59.2325	32240.0
2019-10-11 18:30:00	AAPL	Stock	59.235	59.25	59.2125	59.2375	33924.0
2019-10-11 19:00:00	AAPL	Stock	59.2325	59.25	59.2	59.2375	40560.0
2019-10-11 19:30:00	AAPL	Stock	59.245	59.3125	59.235	59.3125	69868.0
2019-10-11 04:00:00	MSFT	Stock	139.84	140.29	139.84	140.29	1896.0
2019-10-11 04:30:00	MSFT	Stock	140.4	140.7	140.35	140.7	1012.0
2019-10-11 05:00:00	MSFT	Stock	140.73	140.97	140.73	140.83	2942.0
2019-10-11 05:30:00	MSFT	Stock	140.95	140.98	140.78	140.78	801.0
2019-10-11 06:00:00	MSFT	Stock	140.75	140.75	140.75	140.75	100.0
2019-10-11 06:30:00	MSFT	Stock	140.55	140.72	140.55	140.72	200.0
2019-10-11 07:00:00	MSFT	Stock	140.58	140.95	140.11	140.73	31873.0
2019-10-11 07:30:00	MSFT	Stock	140.71	140.8	140.65	140.72	3813.0
2019-10-11 08:00:00	MSFT	Stock	140.62	140.9	139.44	140.5	35837.0
2019-10-11 08:30:00	MSFT	Stock	140.5	140.62	140.39	140.408	16957.0
2019-10-11 09:00:00	MSFT	Stock	140.32	140.408	140.06	140.14	26605.0
2019-10-11 09:30:00	MSFT	Stock	140.12	141.03	140.11	140.57	3295363.0
2019-10-11 10:00:00	MSFT	Stock	140.58	141.0	140.571	140.92	1453016.0
2019-10-11 10:30:00	MSFT	Stock	140.93	140.98	140.5	140.58	1360134.0
2019-10-11 11:00:00	MSFT	Stock	140.58	140.75	140.47	140.695	1200712.0
2019-10-11 11:30:00	MSFT	Stock	140.7	140.95	140.24	140.395	1388500.0
2019-10-11 12:00:00	MSFT	Stock	140.4	140.48	140.19	140.395	721116.0
2019-10-11 12:30:00	MSFT	Stock	140.39	140.51	139.58	140.455	1279863.0

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

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