PREVIEW / stock_30min / 2018-09-07

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-09-07.parquet
  size:    1.7 MB
  rows:    82,972
  symbols: 2,783

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-09-07 04:30:00	AAPL	Stock	55.885	55.885	55.825	55.825	800.0
2018-09-07 05:00:00	AAPL	Stock	55.875	55.875	55.875	55.875	2080.0
2018-09-07 05:30:00	AAPL	Stock	55.93	55.9625	55.88	55.88	33848.0
2018-09-07 06:00:00	AAPL	Stock	55.8525	55.9425	55.85	55.9425	15204.0
2018-09-07 06:30:00	AAPL	Stock	55.95	55.95	55.925	55.95	8432.0
2018-09-07 07:00:00	AAPL	Stock	55.895	55.9575	55.8375	55.8375	113884.0
2018-09-07 07:30:00	AAPL	Stock	55.8325	55.8375	55.78	55.78	58300.0
2018-09-07 08:00:00	AAPL	Stock	55.8875	55.9625	55.715	55.8	167588.0
2018-09-07 08:30:00	AAPL	Stock	55.7825	55.7825	55.5625	55.595	397300.0
2018-09-07 09:00:00	AAPL	Stock	55.59	55.59	55.385	55.5	430888.0
2018-09-07 09:30:00	AAPL	Stock	55.4625	56.19	55.385	56.1415	17106476.0
2018-09-07 10:00:00	AAPL	Stock	56.1425	56.2575	56.05	56.1025	8097740.0
2018-09-07 10:30:00	AAPL	Stock	56.1	56.3055	56.06	56.2925	5847348.0
2018-09-07 11:00:00	AAPL	Stock	56.295	56.32	56.1125	56.205	6331968.0
2018-09-07 11:30:00	AAPL	Stock	56.205	56.3425	56.1275	56.1488	4947752.0
2018-09-07 12:00:00	AAPL	Stock	56.1488	56.1635	55.6952	55.7775	9228440.0
2018-09-07 12:30:00	AAPL	Stock	55.7775	56.0972	55.745	56.0688	5927556.0
2018-09-07 13:00:00	AAPL	Stock	56.0682	56.085	55.7775	55.9075	4529492.0
2018-09-07 13:30:00	AAPL	Stock	55.9075	56.01	55.84	55.85	3380944.0
2018-09-07 14:00:00	AAPL	Stock	55.8475	56.11	55.8425	56.0975	3445948.0
2018-09-07 14:30:00	AAPL	Stock	56.1	56.185	56.0375	56.18	4533204.0
2018-09-07 15:00:00	AAPL	Stock	56.1775	56.21	56.0925	56.155	4218112.0
2018-09-07 15:30:00	AAPL	Stock	56.155	56.1825	55.1775	55.355	40791048.0
2018-09-07 16:00:00	AAPL	Stock	55.325	55.805	55.1575	55.2775	8976636.0
2018-09-07 16:30:00	AAPL	Stock	55.2775	55.325	55.2525	55.27	381020.0
2018-09-07 17:00:00	AAPL	Stock	55.2675	55.275	55.03	55.03	188596.0
2018-09-07 17:30:00	AAPL	Stock	55.0375	55.9808	55.02	55.0525	191816.0
2018-09-07 18:00:00	AAPL	Stock	55.0725	55.0725	54.88	54.98	187168.0
2018-09-07 18:30:00	AAPL	Stock	54.9975	55.05	54.9375	55.0225	52724.0
2018-09-07 19:00:00	AAPL	Stock	55.02	55.025	54.95	54.9875	44392.0
2018-09-07 19:30:00	AAPL	Stock	54.99	55.1575	54.985	55.0825	79380.0
2018-09-07 04:00:00	MSFT	Stock	108.74	108.74	108.74	108.74	100.0
2018-09-07 07:00:00	MSFT	Stock	108.72	108.76	108.72	108.76	2820.0
2018-09-07 07:30:00	MSFT	Stock	108.93	108.94	108.8	108.8	1225.0
2018-09-07 08:00:00	MSFT	Stock	108.83	108.85	108.71	108.71	4471.0
2018-09-07 08:30:00	MSFT	Stock	108.55	108.55	107.92	108.1	19146.0
2018-09-07 09:00:00	MSFT	Stock	108.02	108.12	107.81	108.05	13611.0
2018-09-07 09:30:00	MSFT	Stock	108.23	108.515	107.23	108.515	3384602.0
2018-09-07 10:00:00	MSFT	Stock	108.52	108.72	108.18	108.216	1674267.0
2018-09-07 10:30:00	MSFT	Stock	108.22	108.725	108.05	108.56	1359851.0
2018-09-07 11:00:00	MSFT	Stock	108.57	108.66	108.28	108.54	884049.0
2018-09-07 11:30:00	MSFT	Stock	108.536	108.67	108.38	108.48	804262.0
2018-09-07 12:00:00	MSFT	Stock	108.48	108.535	107.79	108.09	1419636.0
2018-09-07 12:30:00	MSFT	Stock	108.095	108.72	108.08	108.615	851204.0
2018-09-07 13:00:00	MSFT	Stock	108.62	108.64	108.215	108.399	467077.0
2018-09-07 13:30:00	MSFT	Stock	108.4	108.48	108.1	108.12	599797.0
2018-09-07 14:00:00	MSFT	Stock	108.116	108.38	108.1	108.37	572313.0
2018-09-07 14:30:00	MSFT	Stock	108.38	108.38	108.11	108.345	693765.0
2018-09-07 15:00:00	MSFT	Stock	108.34	108.36	108.1	108.2	755478.0
2018-09-07 15:30:00	MSFT	Stock	108.195	108.385	107.98	108.29	3636745.0

> showing 50 of 82,972 rows — these rows as CSV

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