PREVIEW / stock_30min / 2018-12-21

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-12-21.parquet
  size:    1.8 MB
  rows:    87,503
  symbols: 2,746

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-21 04:00:00	AAPL	Stock	39.25	39.25	39.17	39.205	2076.0
2018-12-21 04:30:00	AAPL	Stock	39.0675	39.25	39.0675	39.1175	5260.0
2018-12-21 05:00:00	AAPL	Stock	39.125	39.25	39.1175	39.25	3400.0
2018-12-21 05:30:00	AAPL	Stock	39.25	39.255	39.17	39.255	6792.0
2018-12-21 06:00:00	AAPL	Stock	39.3025	39.3525	39.3025	39.3525	5964.0
2018-12-21 06:30:00	AAPL	Stock	39.32	39.3625	39.32	39.3625	9200.0
2018-12-21 07:00:00	AAPL	Stock	39.335	39.365	39.1125	39.175	90416.0
2018-12-21 07:30:00	AAPL	Stock	39.195	39.2325	39.1	39.2075	78492.0
2018-12-21 08:00:00	AAPL	Stock	39.2125	39.4	39.1025	39.35	244856.0
2018-12-21 08:30:00	AAPL	Stock	39.35	39.55	39.3475	39.375	1134592.0
2018-12-21 09:00:00	AAPL	Stock	39.4	39.535	38.775	39.39	2583344.0
2018-12-21 09:30:00	AAPL	Stock	39.215	39.54	38.93	39.2975	51323232.0
2018-12-21 10:00:00	AAPL	Stock	39.3	39.44	38.8825	39.2688	17156220.0
2018-12-21 10:30:00	AAPL	Stock	39.2668	39.3125	38.9375	39.01	11069656.0
2018-12-21 11:00:00	AAPL	Stock	39.005	39.0175	38.5475	38.805	17657156.0
2018-12-21 11:30:00	AAPL	Stock	38.8025	38.8625	38.5475	38.6025	11148068.0
2018-12-21 12:00:00	AAPL	Stock	38.605	38.62	38.1425	38.2025	16573264.0
2018-12-21 12:30:00	AAPL	Stock	38.1875	38.52	38.015	38.4575	16437228.0
2018-12-21 13:00:00	AAPL	Stock	38.4552	38.58	38.1975	38.3212	11004768.0
2018-12-21 13:30:00	AAPL	Stock	38.3275	38.4525	38.1125	38.2048	8288944.0
2018-12-21 14:00:00	AAPL	Stock	38.2075	38.4125	38.1025	38.2475	10606024.0
2018-12-21 14:30:00	AAPL	Stock	38.247	38.3425	38.035	38.1075	8672216.0
2018-12-21 15:00:00	AAPL	Stock	38.105	38.1525	37.6075	37.6102	17891772.0
2018-12-21 15:30:00	AAPL	Stock	37.615	37.865	37.4075	37.69	36580244.0
2018-12-21 16:00:00	AAPL	Stock	37.68	37.7775	37.55	37.57	93071640.0
2018-12-21 16:30:00	AAPL	Stock	37.575	37.7	37.575	37.66	128160.0
2018-12-21 17:00:00	AAPL	Stock	37.6575	37.7	37.6175	37.6725	233400.0
2018-12-21 17:30:00	AAPL	Stock	37.6675	37.6725	37.55	37.61	144672.0
2018-12-21 18:00:00	AAPL	Stock	37.585	37.6	37.54	37.5575	62000.0
2018-12-21 18:30:00	AAPL	Stock	37.5575	37.5625	37.525	37.535	30616.0
2018-12-21 19:00:00	AAPL	Stock	37.5375	37.5625	37.5125	37.5375	71816.0
2018-12-21 19:30:00	AAPL	Stock	37.5375	37.5425	37.5	37.525	73832.0
2018-12-21 04:00:00	MSFT	Stock	102.3	102.3	101.7	101.85	1439.0
2018-12-21 04:30:00	MSFT	Stock	101.8	101.8	101.8	101.8	1040.0
2018-12-21 06:00:00	MSFT	Stock	102.09	102.35	102.09	102.3	1224.0
2018-12-21 06:30:00	MSFT	Stock	102.27	102.3	102.24	102.25	400.0
2018-12-21 07:00:00	MSFT	Stock	102.02	102.1	101.8	101.85	5690.0
2018-12-21 07:30:00	MSFT	Stock	101.8	101.92	101.59	101.92	9245.0
2018-12-21 08:00:00	MSFT	Stock	101.92	102.25	101.59	102.07	21435.0
2018-12-21 08:30:00	MSFT	Stock	102.15	102.69	102.15	102.39	37303.0
2018-12-21 09:00:00	MSFT	Stock	102.39	102.99	100.3	102.38	1635752.0
2018-12-21 09:30:00	MSFT	Stock	102.38	103.0	100.28	100.65	17608902.0
2018-12-21 10:00:00	MSFT	Stock	100.66	102.65	99.98	102.1	6047619.0
2018-12-21 10:30:00	MSFT	Stock	102.09	102.152	101.43	101.58	2646518.0
2018-12-21 11:00:00	MSFT	Stock	101.58	101.6	100.52	101.27	2772448.0
2018-12-21 11:30:00	MSFT	Stock	101.28	101.36	100.21	100.36	2735963.0
2018-12-21 12:00:00	MSFT	Stock	100.36	100.41	98.71	98.83	5061865.0
2018-12-21 12:30:00	MSFT	Stock	98.82	100.15	98.13	99.45	4655137.0
2018-12-21 13:00:00	MSFT	Stock	99.45	100.24	99.16	99.79	3154930.0
2018-12-21 13:30:00	MSFT	Stock	99.78	100.22	99.29	99.62	3314695.0

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

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