PREVIEW / stock_30min / 2018-10-04

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-10-04.parquet
  size:    1.7 MB
  rows:    85,008
  symbols: 2,794

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
2018-10-04 04:00:00	AAPL	Stock	57.625	57.7	57.625	57.625	16136.0
2018-10-04 04:30:00	AAPL	Stock	57.675	57.675	57.6275	57.6275	7608.0
2018-10-04 05:00:00	AAPL	Stock	57.6325	57.6325	57.445	57.575	32492.0
2018-10-04 06:00:00	AAPL	Stock	57.6625	57.6625	57.625	57.625	6624.0
2018-10-04 06:30:00	AAPL	Stock	57.625	57.675	57.5875	57.675	40136.0
2018-10-04 07:00:00	AAPL	Stock	57.72	57.895	57.65	57.8025	130468.0
2018-10-04 07:30:00	AAPL	Stock	57.8025	57.8025	57.615	57.69	248592.0
2018-10-04 08:00:00	AAPL	Stock	57.6812	57.8825	57.4875	57.6375	481152.0
2018-10-04 08:30:00	AAPL	Stock	57.66	58.0175	57.575	57.6875	287876.0
2018-10-04 09:00:00	AAPL	Stock	57.6875	57.7875	57.6125	57.715	194740.0
2018-10-04 09:30:00	AAPL	Stock	57.7375	58.0875	57.2675	57.4825	19368540.0
2018-10-04 10:00:00	AAPL	Stock	57.4775	57.5825	57.335	57.4488	8447992.0
2018-10-04 10:30:00	AAPL	Stock	57.445	57.4925	57.2825	57.31	6910400.0
2018-10-04 11:00:00	AAPL	Stock	57.3	57.49	57.27	57.375	5020920.0
2018-10-04 11:30:00	AAPL	Stock	57.375	57.4125	56.955	57.0375	8493980.0
2018-10-04 12:00:00	AAPL	Stock	57.0375	57.2175	56.825	56.9575	7546160.0
2018-10-04 12:30:00	AAPL	Stock	56.955	57.205	56.8575	56.9875	5103396.0
2018-10-04 13:00:00	AAPL	Stock	56.9825	57.085	56.8578	57.01	4311756.0
2018-10-04 13:30:00	AAPL	Stock	57.0125	57.03	56.82	56.9255	4617540.0
2018-10-04 14:00:00	AAPL	Stock	56.9225	57.045	56.6825	56.885	6337980.0
2018-10-04 14:30:00	AAPL	Stock	56.8875	57.1225	56.8425	57.07	5409696.0
2018-10-04 15:00:00	AAPL	Stock	57.0675	57.13	56.9425	56.9632	3828644.0
2018-10-04 15:30:00	AAPL	Stock	56.96	57.155	56.8472	56.9975	9674840.0
2018-10-04 16:00:00	AAPL	Stock	56.9975	57.0625	56.9475	57.035	9519960.0
2018-10-04 16:30:00	AAPL	Stock	57.0425	57.06	57.005	57.06	61496.0
2018-10-04 17:00:00	AAPL	Stock	57.0625	57.075	57.0375	57.05	20528.0
2018-10-04 17:30:00	AAPL	Stock	57.05	57.075	57.05	57.0625	43540.0
2018-10-04 18:00:00	AAPL	Stock	57.065	57.065	57.0025	57.0025	32212.0
2018-10-04 18:30:00	AAPL	Stock	57.005	57.025	57.0	57.0	16112.0
2018-10-04 19:00:00	AAPL	Stock	57.005	57.015	57.005	57.005	13528.0
2018-10-04 19:30:00	AAPL	Stock	56.9975	57.025	56.9825	57.025	26700.0
2018-10-04 05:00:00	MSFT	Stock	114.68	114.68	114.68	114.68	100.0
2018-10-04 05:30:00	MSFT	Stock	114.68	114.68	114.68	114.68	676.0
2018-10-04 07:00:00	MSFT	Stock	114.65	114.75	114.62	114.7	6615.0
2018-10-04 07:30:00	MSFT	Stock	114.67	114.72	114.53	114.72	4669.0
2018-10-04 08:00:00	MSFT	Stock	114.675	115.45	114.53	114.58	8630.0
2018-10-04 08:30:00	MSFT	Stock	114.64	115.17	114.58	114.74	114844.0
2018-10-04 09:00:00	MSFT	Stock	114.74	114.9	114.52	114.61	11067.0
2018-10-04 09:30:00	MSFT	Stock	114.68	114.759	113.76	114.073	3333856.0
2018-10-04 10:00:00	MSFT	Stock	114.07	114.1	113.23	113.3	2024712.0
2018-10-04 10:30:00	MSFT	Stock	113.29	113.45	112.93	113.29	2096267.0
2018-10-04 11:00:00	MSFT	Stock	113.28	113.59	113.0	113.105	1667888.0
2018-10-04 11:30:00	MSFT	Stock	113.1	113.22	112.9	112.965	1537212.0
2018-10-04 12:00:00	MSFT	Stock	112.96	113.01	112.36	112.56	2268249.0
2018-10-04 12:30:00	MSFT	Stock	112.56	112.977	112.26	112.29	1480366.0
2018-10-04 13:00:00	MSFT	Stock	112.29	112.495	111.94	112.015	2080720.0
2018-10-04 13:30:00	MSFT	Stock	112.02	112.02	111.63	111.76	2060957.0
2018-10-04 14:00:00	MSFT	Stock	111.75	112.11	111.69	112.105	1555868.0
2018-10-04 14:30:00	MSFT	Stock	112.1	112.635	112.015	112.455	1824496.0
2018-10-04 15:00:00	MSFT	Stock	112.46	112.54	112.31	112.31	1492963.0

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

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