PREVIEW / stock_30min / 2019-11-01

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-11-01.parquet
  size:    1.7 MB
  rows:    83,946
  symbols: 2,485

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-11-01 04:00:00	AAPL	Stock	62.3575	62.4	62.25	62.25	11848.0
2019-11-01 04:30:00	AAPL	Stock	62.255	62.3625	62.2475	62.3625	15124.0
2019-11-01 05:00:00	AAPL	Stock	62.3625	62.3625	62.3625	62.3625	400.0
2019-11-01 05:30:00	AAPL	Stock	62.3475	62.35	62.3475	62.35	5552.0
2019-11-01 06:00:00	AAPL	Stock	62.345	62.345	62.345	62.345	5840.0
2019-11-01 06:30:00	AAPL	Stock	62.3225	62.3425	62.3225	62.3425	1200.0
2019-11-01 07:00:00	AAPL	Stock	62.3325	62.35	62.2725	62.275	35548.0
2019-11-01 07:30:00	AAPL	Stock	62.275	62.295	62.15	62.15	102216.0
2019-11-01 08:00:00	AAPL	Stock	62.33	62.35	62.15	62.225	248912.0
2019-11-01 08:30:00	AAPL	Stock	62.235	62.4275	62.235	62.375	437280.0
2019-11-01 09:00:00	AAPL	Stock	62.38	62.4475	62.3225	62.4	417308.0
2019-11-01 09:30:00	AAPL	Stock	62.385	62.99	62.29	62.9475	22659828.0
2019-11-01 10:00:00	AAPL	Stock	62.94	63.35	62.8125	63.345	15685440.0
2019-11-01 10:30:00	AAPL	Stock	63.3475	63.4325	63.1752	63.325	10877812.0
2019-11-01 11:00:00	AAPL	Stock	63.33	63.4225	63.25	63.325	7149348.0
2019-11-01 11:30:00	AAPL	Stock	63.3275	63.4475	63.275	63.31	5944884.0
2019-11-01 12:00:00	AAPL	Stock	63.3125	63.3275	63.1525	63.2508	6751920.0
2019-11-01 12:30:00	AAPL	Stock	63.2575	63.2725	63.1075	63.1375	4088944.0
2019-11-01 13:00:00	AAPL	Stock	63.135	63.405	63.1125	63.3625	5683316.0
2019-11-01 13:30:00	AAPL	Stock	63.3625	63.4575	63.325	63.4125	4600092.0
2019-11-01 14:00:00	AAPL	Stock	63.41	63.455	63.3275	63.4538	3481520.0
2019-11-01 14:30:00	AAPL	Stock	63.455	63.595	63.4425	63.5862	6057404.0
2019-11-01 15:00:00	AAPL	Stock	63.585	63.707	63.5325	63.6488	7747484.0
2019-11-01 15:30:00	AAPL	Stock	63.655	63.9825	63.6425	63.96	18871196.0
2019-11-01 16:00:00	AAPL	Stock	63.955	63.975	63.29	63.94	9923716.0
2019-11-01 16:30:00	AAPL	Stock	63.94	63.9625	63.9228	63.9425	206264.0
2019-11-01 17:00:00	AAPL	Stock	63.96	63.9975	63.945	63.9925	132112.0
2019-11-01 17:30:00	AAPL	Stock	63.9975	63.9975	63.9625	63.9725	60888.0
2019-11-01 18:00:00	AAPL	Stock	63.975	63.9925	63.9625	63.9675	25616.0
2019-11-01 18:30:00	AAPL	Stock	63.965	64.0	63.965	63.9875	31460.0
2019-11-01 19:00:00	AAPL	Stock	63.975	63.995	63.965	63.9875	29892.0
2019-11-01 19:30:00	AAPL	Stock	63.97	64.05	63.97	64.025	67248.0
2019-11-01 04:00:00	MSFT	Stock	143.87	143.87	143.87	143.87	279.0
2019-11-01 05:00:00	MSFT	Stock	143.95	143.95	143.89	143.89	968.0
2019-11-01 05:30:00	MSFT	Stock	143.9	143.94	143.9	143.94	1100.0
2019-11-01 07:00:00	MSFT	Stock	143.97	143.97	143.75	143.8	5069.0
2019-11-01 07:30:00	MSFT	Stock	143.87	143.94	143.75	143.75	2893.0
2019-11-01 08:00:00	MSFT	Stock	143.89	143.94	143.7	143.72	7747.0
2019-11-01 08:30:00	MSFT	Stock	143.75	144.3	143.75	144.16	46134.0
2019-11-01 09:00:00	MSFT	Stock	144.1	144.45	144.1	144.3	35741.0
2019-11-01 09:30:00	MSFT	Stock	144.26	144.42	143.23	143.28	2639772.0
2019-11-01 10:00:00	MSFT	Stock	143.28	143.84	143.03	143.609	1824956.0
2019-11-01 10:30:00	MSFT	Stock	143.6	143.67	143.4	143.52	982488.0
2019-11-01 11:00:00	MSFT	Stock	143.52	143.71	143.36	143.475	976384.0
2019-11-01 11:30:00	MSFT	Stock	143.477	143.525	143.32	143.41	697878.0
2019-11-01 12:00:00	MSFT	Stock	143.42	143.43	142.965	143.27	1032745.0
2019-11-01 12:30:00	MSFT	Stock	143.27	143.28	142.99	143.02	712602.0
2019-11-01 13:00:00	MSFT	Stock	143.027	143.238	142.98	143.1	1024781.0
2019-11-01 13:30:00	MSFT	Stock	143.1	143.35	143.075	143.326	1267010.0
2019-11-01 14:00:00	MSFT	Stock	143.325	143.37	143.22	143.32	1010437.0

> showing 50 of 83,946 rows — these rows as CSV

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