PREVIEW / stock_30min / 2019-08-07

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-08-07.parquet
  size:    1.7 MB
  rows:    85,463
  symbols: 2,582

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-08-07 04:00:00	AAPL	Stock	49.25	49.475	49.25	49.475	10388.0
2019-08-07 04:30:00	AAPL	Stock	49.44	49.58	49.44	49.58	5120.0
2019-08-07 05:00:00	AAPL	Stock	49.57	49.61	49.545	49.585	14636.0
2019-08-07 05:30:00	AAPL	Stock	49.585	49.6875	49.58	49.67	6308.0
2019-08-07 06:00:00	AAPL	Stock	49.67	49.6825	49.63	49.63	6004.0
2019-08-07 06:30:00	AAPL	Stock	49.66	49.7	49.5125	49.5125	50088.0
2019-08-07 07:00:00	AAPL	Stock	49.5	49.685	49.5	49.6075	107748.0
2019-08-07 07:30:00	AAPL	Stock	49.5775	49.6	49.3875	49.43	110496.0
2019-08-07 08:00:00	AAPL	Stock	49.55	49.65	48.9275	49.1	504724.0
2019-08-07 08:30:00	AAPL	Stock	49.0775	49.085	48.675	48.6925	421028.0
2019-08-07 09:00:00	AAPL	Stock	48.6775	48.89	48.4875	48.87	475588.0
2019-08-07 09:30:00	AAPL	Stock	48.8725	49.05	48.455	48.74	14859528.0
2019-08-07 10:00:00	AAPL	Stock	48.745	49.13	48.5875	48.9	9521628.0
2019-08-07 10:30:00	AAPL	Stock	48.91	49.35	48.87	49.2225	9706200.0
2019-08-07 11:00:00	AAPL	Stock	49.22	49.325	49.05	49.1775	8303064.0
2019-08-07 11:30:00	AAPL	Stock	49.1875	49.21	49.0125	49.098	5652492.0
2019-08-07 12:00:00	AAPL	Stock	49.105	49.1375	48.885	48.965	5116012.0
2019-08-07 12:30:00	AAPL	Stock	48.96	49.1725	48.925	49.15	4097132.0
2019-08-07 13:00:00	AAPL	Stock	49.15	49.325	49.1102	49.3175	4645124.0
2019-08-07 13:30:00	AAPL	Stock	49.32	49.6625	49.32	49.4875	7616616.0
2019-08-07 14:00:00	AAPL	Stock	49.4875	49.675	49.345	49.46	5860240.0
2019-08-07 14:30:00	AAPL	Stock	49.4638	49.665	49.375	49.6475	5120036.0
2019-08-07 15:00:00	AAPL	Stock	49.645	49.6922	49.465	49.6688	5929472.0
2019-08-07 15:30:00	AAPL	Stock	49.6725	49.89	49.6125	49.785	13538632.0
2019-08-07 16:00:00	AAPL	Stock	49.7825	49.8275	49.6825	49.725	12804348.0
2019-08-07 16:30:00	AAPL	Stock	49.725	49.7625	49.7	49.75	53436.0
2019-08-07 17:00:00	AAPL	Stock	49.76	49.775	49.7325	49.7725	20032.0
2019-08-07 17:30:00	AAPL	Stock	49.755	49.76	49.7325	49.76	13920.0
2019-08-07 18:00:00	AAPL	Stock	49.755	49.7875	49.7125	49.7875	16132.0
2019-08-07 18:30:00	AAPL	Stock	49.815	49.875	49.775	49.825	56328.0
2019-08-07 19:00:00	AAPL	Stock	49.825	49.86	49.8	49.845	5176.0
2019-08-07 19:30:00	AAPL	Stock	49.8	49.8375	49.675	49.7225	41940.0
2019-08-07 04:00:00	MSFT	Stock	135.49	135.5	135.22	135.39	5825.0
2019-08-07 04:30:00	MSFT	Stock	135.3	135.5	135.3	135.5	2200.0
2019-08-07 05:00:00	MSFT	Stock	135.5	135.76	135.39	135.49	2396.0
2019-08-07 05:30:00	MSFT	Stock	135.49	136.09	135.41	136.05	3809.0
2019-08-07 06:00:00	MSFT	Stock	135.98	135.98	135.84	135.84	3410.0
2019-08-07 06:30:00	MSFT	Stock	136.0	136.02	135.35	135.35	9418.0
2019-08-07 07:00:00	MSFT	Stock	135.35	135.58	135.25	135.25	11758.0
2019-08-07 07:30:00	MSFT	Stock	135.3	135.37	134.9	135.14	17886.0
2019-08-07 08:00:00	MSFT	Stock	135.35	135.58	133.69	134.1	72747.0
2019-08-07 08:30:00	MSFT	Stock	134.1	134.1	132.59	132.61	70707.0
2019-08-07 09:00:00	MSFT	Stock	132.95	133.8	132.3	133.8	87744.0
2019-08-07 09:30:00	MSFT	Stock	133.8	133.83	131.828	132.89	3564749.0
2019-08-07 10:00:00	MSFT	Stock	132.87	134.45	132.64	133.998	2506029.0
2019-08-07 10:30:00	MSFT	Stock	133.98	135.2	133.88	134.75	2369699.0
2019-08-07 11:00:00	MSFT	Stock	134.74	134.92	133.89	134.02	1527434.0
2019-08-07 11:30:00	MSFT	Stock	134.04	134.26	133.52	133.88	1370362.0
2019-08-07 12:00:00	MSFT	Stock	133.89	133.93	133.07	133.36	1109259.0
2019-08-07 12:30:00	MSFT	Stock	133.34	134.06	133.19	133.896	1057768.0

> showing 50 of 85,463 rows — these rows as CSV

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