PREVIEW / stock_30min / 2019-06-13

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-06-13.parquet
  size:    1.7 MB
  rows:    83,165
  symbols: 2,595

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-06-13 04:00:00	AAPL	Stock	48.5875	48.6725	48.5875	48.6725	6400.0
2019-06-13 04:30:00	AAPL	Stock	48.7	48.8575	48.7	48.84	13856.0
2019-06-13 05:00:00	AAPL	Stock	48.825	48.8375	48.8075	48.8375	13536.0
2019-06-13 05:30:00	AAPL	Stock	48.8375	48.8375	48.8175	48.8225	3772.0
2019-06-13 06:00:00	AAPL	Stock	48.7625	48.785	48.7625	48.785	6744.0
2019-06-13 06:30:00	AAPL	Stock	48.7575	48.8375	48.7175	48.8375	27344.0
2019-06-13 07:00:00	AAPL	Stock	48.8175	48.84	48.77	48.775	81652.0
2019-06-13 07:30:00	AAPL	Stock	48.7875	48.7875	48.71	48.7425	59844.0
2019-06-13 08:00:00	AAPL	Stock	48.79	48.85	48.6425	48.6975	118900.0
2019-06-13 08:30:00	AAPL	Stock	48.6675	48.7375	48.6525	48.72	51220.0
2019-06-13 09:00:00	AAPL	Stock	48.7	48.735	48.65	48.65	100672.0
2019-06-13 09:30:00	AAPL	Stock	48.675	49.16	48.61	49.1362	12419816.0
2019-06-13 10:00:00	AAPL	Stock	49.14	49.1975	48.8928	48.925	7403832.0
2019-06-13 10:30:00	AAPL	Stock	48.93	49.045	48.885	48.9175	4489024.0
2019-06-13 11:00:00	AAPL	Stock	48.92	48.99	48.7825	48.845	3989432.0
2019-06-13 11:30:00	AAPL	Stock	48.8425	48.9375	48.765	48.92	3354692.0
2019-06-13 12:00:00	AAPL	Stock	48.9175	48.9595	48.8025	48.8025	2135460.0
2019-06-13 12:30:00	AAPL	Stock	48.8025	48.935	48.795	48.9075	2280456.0
2019-06-13 13:00:00	AAPL	Stock	48.91	48.9575	48.83	48.8778	1980056.0
2019-06-13 13:30:00	AAPL	Stock	48.88	48.9	48.815	48.82	1972208.0
2019-06-13 14:00:00	AAPL	Stock	48.82	48.82	48.68	48.7425	3050844.0
2019-06-13 14:30:00	AAPL	Stock	48.74	48.74	48.614	48.6875	2761620.0
2019-06-13 15:00:00	AAPL	Stock	48.6825	48.7025	48.5325	48.6	3820216.0
2019-06-13 15:30:00	AAPL	Stock	48.6	48.85	48.4	48.685	13458828.0
2019-06-13 16:00:00	AAPL	Stock	48.6825	48.6825	48.35	48.425	6805276.0
2019-06-13 16:30:00	AAPL	Stock	48.4725	48.5375	48.3125	48.3625	236060.0
2019-06-13 17:00:00	AAPL	Stock	48.3625	48.5375	48.2125	48.25	1620048.0
2019-06-13 17:30:00	AAPL	Stock	48.275	48.275	48.0025	48.1	144132.0
2019-06-13 18:00:00	AAPL	Stock	48.135	48.1875	48.125	48.125	84824.0
2019-06-13 18:30:00	AAPL	Stock	48.1275	48.1875	48.125	48.1775	34180.0
2019-06-13 19:00:00	AAPL	Stock	48.17	48.235	48.1275	48.175	53096.0
2019-06-13 19:30:00	AAPL	Stock	48.175	48.235	48.1525	48.1875	14384.0
2019-06-13 04:30:00	MSFT	Stock	131.99	131.99	131.95	131.95	350.0
2019-06-13 06:00:00	MSFT	Stock	132.08	132.08	132.07	132.07	300.0
2019-06-13 06:30:00	MSFT	Stock	132.07	132.2	132.07	132.2	1619.0
2019-06-13 07:00:00	MSFT	Stock	132.2	132.3	132.2	132.2	4054.0
2019-06-13 07:30:00	MSFT	Stock	132.15	132.15	132.09	132.15	1600.0
2019-06-13 08:00:00	MSFT	Stock	132.34	132.34	131.95	132.05	12641.0
2019-06-13 08:30:00	MSFT	Stock	131.86	132.0	131.6	131.998	35255.0
2019-06-13 09:00:00	MSFT	Stock	131.9	132.0	131.84	131.95	8896.0
2019-06-13 09:30:00	MSFT	Stock	131.98	132.5	131.83	132.465	1988788.0
2019-06-13 10:00:00	MSFT	Stock	132.47	133.0	132.03	132.12	1325945.0
2019-06-13 10:30:00	MSFT	Stock	132.115	132.345	131.83	131.84	1155098.0
2019-06-13 11:00:00	MSFT	Stock	131.84	131.99	131.56	131.97	898796.0
2019-06-13 11:30:00	MSFT	Stock	131.97	132.1	131.77	132.01	635300.0
2019-06-13 12:00:00	MSFT	Stock	132.017	132.083	131.69	131.695	503014.0
2019-06-13 12:30:00	MSFT	Stock	131.696	131.955	131.56	131.95	608928.0
2019-06-13 13:00:00	MSFT	Stock	131.96	132.09	131.89	131.92	506661.0
2019-06-13 13:30:00	MSFT	Stock	131.93	132.23	131.83	132.19	631207.0
2019-06-13 14:00:00	MSFT	Stock	132.19	132.31	131.97	132.125	804301.0

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

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