PREVIEW / stock_30min / 2018-12-20

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-12-20.parquet
  size:    1.8 MB
  rows:    87,754
  symbols: 2,763

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-12-20 04:00:00	AAPL	Stock	40.0475	40.25	40.0475	40.2425	4292.0
2018-12-20 04:30:00	AAPL	Stock	40.1875	40.2425	40.1525	40.235	7616.0
2018-12-20 05:00:00	AAPL	Stock	40.155	40.25	40.155	40.2225	9580.0
2018-12-20 05:30:00	AAPL	Stock	40.175	40.175	40.1	40.175	14228.0
2018-12-20 06:00:00	AAPL	Stock	40.21	40.25	40.21	40.25	3840.0
2018-12-20 06:30:00	AAPL	Stock	40.25	40.3125	40.25	40.3	20412.0
2018-12-20 07:00:00	AAPL	Stock	40.3025	40.4225	40.3025	40.3375	102432.0
2018-12-20 07:30:00	AAPL	Stock	40.345	40.4125	40.2875	40.3675	100920.0
2018-12-20 08:00:00	AAPL	Stock	40.4375	40.4375	40.025	40.25	502528.0
2018-12-20 08:30:00	AAPL	Stock	40.225	40.275	39.98	40.0125	384824.0
2018-12-20 09:00:00	AAPL	Stock	40.0	40.2225	39.975	40.0175	331732.0
2018-12-20 09:30:00	AAPL	Stock	40.09	40.5275	39.935	40.385	25432380.0
2018-12-20 10:00:00	AAPL	Stock	40.385	40.5175	40.115	40.124	13339092.0
2018-12-20 10:30:00	AAPL	Stock	40.1175	40.4125	40.045	40.1412	11404984.0
2018-12-20 11:00:00	AAPL	Stock	40.1375	40.2	39.8525	39.9762	11886832.0
2018-12-20 11:30:00	AAPL	Stock	39.9775	40.07	39.66	39.8475	16647044.0
2018-12-20 12:00:00	AAPL	Stock	39.8475	39.91	39.3975	39.705	14721104.0
2018-12-20 12:30:00	AAPL	Stock	39.7075	39.75	39.385	39.5938	11631952.0
2018-12-20 13:00:00	AAPL	Stock	39.5938	39.6135	39.4225	39.43	9919252.0
2018-12-20 13:30:00	AAPL	Stock	39.43	39.435	39.1025	39.1375	14531172.0
2018-12-20 14:00:00	AAPL	Stock	39.135	39.2675	38.825	39.25	20356160.0
2018-12-20 14:30:00	AAPL	Stock	39.2472	39.645	39.2318	39.3925	17849992.0
2018-12-20 15:00:00	AAPL	Stock	39.39	39.585	39.245	39.2775	13870900.0
2018-12-20 15:30:00	AAPL	Stock	39.2738	39.475	39.0075	39.225	29178732.0
2018-12-20 16:00:00	AAPL	Stock	39.225	39.46	39.175	39.425	20332916.0
2018-12-20 16:30:00	AAPL	Stock	39.43	39.5	39.4125	39.47	133472.0
2018-12-20 17:00:00	AAPL	Stock	39.4375	39.4875	39.3875	39.465	55592.0
2018-12-20 17:30:00	AAPL	Stock	39.44	39.4775	39.4125	39.46	24948.0
2018-12-20 18:00:00	AAPL	Stock	39.46	39.535	39.415	39.45	72532.0
2018-12-20 18:30:00	AAPL	Stock	39.4775	39.5	39.3875	39.4	37588.0
2018-12-20 19:00:00	AAPL	Stock	39.39	39.39	39.305	39.3375	29608.0
2018-12-20 19:30:00	AAPL	Stock	39.3275	39.375	39.3025	39.375	53944.0
2018-12-20 04:00:00	MSFT	Stock	103.2	103.51	103.2	103.51	1847.0
2018-12-20 04:30:00	MSFT	Stock	103.7	103.7	103.6	103.6	200.0
2018-12-20 05:00:00	MSFT	Stock	103.6	103.68	103.55	103.65	1810.0
2018-12-20 05:30:00	MSFT	Stock	103.55	103.55	103.5	103.5	1200.0
2018-12-20 06:00:00	MSFT	Stock	103.55	103.83	103.55	103.82	1725.0
2018-12-20 06:30:00	MSFT	Stock	103.85	104.08	103.85	104.08	2439.0
2018-12-20 07:00:00	MSFT	Stock	104.02	104.3	103.9	103.91	13216.0
2018-12-20 07:30:00	MSFT	Stock	103.93	104.05	103.85	104.05	5488.0
2018-12-20 08:00:00	MSFT	Stock	104.17	104.3	103.59	103.62	26710.0
2018-12-20 08:30:00	MSFT	Stock	103.64	103.93	103.2	103.25	15878.0
2018-12-20 09:00:00	MSFT	Stock	103.25	103.69	103.06	103.06	26375.0
2018-12-20 09:30:00	MSFT	Stock	103.06	104.31	102.48	103.15	4912614.0
2018-12-20 10:00:00	MSFT	Stock	103.15	103.98	102.825	102.972	3317693.0
2018-12-20 10:30:00	MSFT	Stock	102.97	103.49	102.32	102.585	3036879.0
2018-12-20 11:00:00	MSFT	Stock	102.56	102.647	101.12	101.19	4155279.0
2018-12-20 11:30:00	MSFT	Stock	101.185	101.42	98.78	100.33	6978539.0
2018-12-20 12:00:00	MSFT	Stock	100.35	101.31	99.8	101.26	4508929.0
2018-12-20 12:30:00	MSFT	Stock	101.24	101.4	100.5	101.2	2619355.0

> showing 50 of 87,754 rows — these rows as CSV

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