PREVIEW / stock_30min / 2019-06-12

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-06-12.parquet
  size:    1.7 MB
  rows:    82,802
  symbols: 2,593

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-06-12 04:00:00	AAPL	Stock	48.5425	48.5425	48.3275	48.3275	5356.0
2019-06-12 05:00:00	AAPL	Stock	48.35	48.35	48.35	48.35	3500.0
2019-06-12 06:00:00	AAPL	Stock	48.2975	48.2975	48.2975	48.2975	644.0
2019-06-12 06:30:00	AAPL	Stock	48.31	48.35	48.3	48.35	7728.0
2019-06-12 07:00:00	AAPL	Stock	48.37	48.4125	48.28	48.3	55020.0
2019-06-12 07:30:00	AAPL	Stock	48.2875	48.3425	48.285	48.295	24448.0
2019-06-12 08:00:00	AAPL	Stock	48.3975	48.425	48.2655	48.2925	124324.0
2019-06-12 08:30:00	AAPL	Stock	48.32	48.4125	48.3	48.3175	72328.0
2019-06-12 09:00:00	AAPL	Stock	48.335	48.525	48.325	48.525	102472.0
2019-06-12 09:30:00	AAPL	Stock	48.49	48.808	48.3462	48.795	12200424.0
2019-06-12 10:00:00	AAPL	Stock	48.7975	48.8058	48.6125	48.6675	5749680.0
2019-06-12 10:30:00	AAPL	Stock	48.6698	48.9925	48.5825	48.7875	7348132.0
2019-06-12 11:00:00	AAPL	Stock	48.79	48.8525	48.705	48.735	3343024.0
2019-06-12 11:30:00	AAPL	Stock	48.74	48.775	48.635	48.6775	3287712.0
2019-06-12 12:00:00	AAPL	Stock	48.6825	48.75	48.5938	48.6875	3767568.0
2019-06-12 12:30:00	AAPL	Stock	48.6875	48.7625	48.6325	48.71	3042232.0
2019-06-12 13:00:00	AAPL	Stock	48.708	48.7475	48.6145	48.655	2422444.0
2019-06-12 13:30:00	AAPL	Stock	48.66	48.67	48.6025	48.6412	1812208.0
2019-06-12 14:00:00	AAPL	Stock	48.645	48.6875	48.515	48.56	2748928.0
2019-06-12 14:30:00	AAPL	Stock	48.5625	48.655	48.545	48.5985	3036516.0
2019-06-12 15:00:00	AAPL	Stock	48.6012	48.6082	48.52	48.5375	2580728.0
2019-06-12 15:30:00	AAPL	Stock	48.535	48.6025	48.4475	48.5475	5892504.0
2019-06-12 16:00:00	AAPL	Stock	48.5475	48.5475	48.5	48.52	4241348.0
2019-06-12 16:30:00	AAPL	Stock	48.5275	48.5375	48.5275	48.535	21024.0
2019-06-12 17:00:00	AAPL	Stock	48.525	48.525	48.5	48.5	6588.0
2019-06-12 17:30:00	AAPL	Stock	48.5025	48.5225	48.5025	48.5225	7776.0
2019-06-12 18:00:00	AAPL	Stock	48.525	48.5375	48.525	48.5375	17204.0
2019-06-12 18:30:00	AAPL	Stock	48.5375	48.625	48.5275	48.5975	33968.0
2019-06-12 19:00:00	AAPL	Stock	48.5975	48.6125	48.575	48.6125	5476.0
2019-06-12 19:30:00	AAPL	Stock	48.625	48.675	48.6	48.675	54112.0
2019-06-12 04:00:00	MSFT	Stock	132.45	132.45	132.45	132.45	100.0
2019-06-12 05:30:00	MSFT	Stock	131.42	131.42	131.42	131.42	100.0
2019-06-12 06:00:00	MSFT	Stock	131.32	131.32	131.32	131.32	200.0
2019-06-12 06:30:00	MSFT	Stock	131.69	131.7	131.69	131.69	1145.0
2019-06-12 07:00:00	MSFT	Stock	131.4	131.69	131.4	131.4	2169.0
2019-06-12 07:30:00	MSFT	Stock	131.5	131.66	131.5	131.5	2106.0
2019-06-12 08:00:00	MSFT	Stock	131.58	132.43	131.58	131.73	8289.0
2019-06-12 08:30:00	MSFT	Stock	131.85	131.99	131.61	131.69	12342.0
2019-06-12 09:00:00	MSFT	Stock	131.7	131.75	131.4	131.4	18013.0
2019-06-12 09:30:00	MSFT	Stock	131.4	131.97	130.79	131.44	2317726.0
2019-06-12 10:00:00	MSFT	Stock	131.45	131.69	130.8	130.81	1100680.0
2019-06-12 10:30:00	MSFT	Stock	130.81	131.38	130.71	130.91	1319551.0
2019-06-12 11:00:00	MSFT	Stock	130.91	131.18	130.85	131.1	863034.0
2019-06-12 11:30:00	MSFT	Stock	131.095	131.23	130.855	130.88	831121.0
2019-06-12 12:00:00	MSFT	Stock	130.88	131.205	130.81	131.16	702536.0
2019-06-12 12:30:00	MSFT	Stock	131.16	131.324	131.11	131.3	663778.0
2019-06-12 13:00:00	MSFT	Stock	131.29	131.43	131.15	131.245	558321.0
2019-06-12 13:30:00	MSFT	Stock	131.24	131.26	131.08	131.138	491846.0
2019-06-12 14:00:00	MSFT	Stock	131.14	131.25	130.99	131.22	524702.0
2019-06-12 14:30:00	MSFT	Stock	131.23	131.4	131.17	131.364	778879.0

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

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