PREVIEW / stock_30min / 2019-07-15

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-07-15.parquet
  size:    1.7 MB
  rows:    82,588
  symbols: 2,572

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-07-15 04:00:00	AAPL	Stock	50.8825	50.8825	50.865	50.865	1200.0
2019-07-15 05:00:00	AAPL	Stock	50.8875	50.8875	50.8875	50.8875	1000.0
2019-07-15 05:30:00	AAPL	Stock	50.8625	50.865	50.8625	50.865	2400.0
2019-07-15 06:00:00	AAPL	Stock	50.865	50.865	50.865	50.865	4320.0
2019-07-15 07:00:00	AAPL	Stock	50.88	50.9625	50.88	50.9325	16936.0
2019-07-15 07:30:00	AAPL	Stock	50.9625	50.9625	50.93	50.95	22492.0
2019-07-15 08:00:00	AAPL	Stock	50.9125	50.9875	50.9	50.9875	73932.0
2019-07-15 08:30:00	AAPL	Stock	50.98	51.0	50.9575	50.9775	38048.0
2019-07-15 09:00:00	AAPL	Stock	50.9675	51.0325	50.965	51.0275	100880.0
2019-07-15 09:30:00	AAPL	Stock	51.0225	51.4675	51.0	51.29	14580420.0
2019-07-15 10:00:00	AAPL	Stock	51.286	51.3525	51.215	51.28	5795516.0
2019-07-15 10:30:00	AAPL	Stock	51.2725	51.2975	51.22	51.2325	3106848.0
2019-07-15 11:00:00	AAPL	Stock	51.2325	51.2738	51.2	51.2338	2540660.0
2019-07-15 11:30:00	AAPL	Stock	51.2338	51.2625	51.1825	51.2088	2184132.0
2019-07-15 12:00:00	AAPL	Stock	51.2125	51.2325	51.135	51.1438	2297280.0
2019-07-15 12:30:00	AAPL	Stock	51.1425	51.145	51.03	51.11	2755384.0
2019-07-15 13:00:00	AAPL	Stock	51.1088	51.2	51.105	51.196	2002312.0
2019-07-15 13:30:00	AAPL	Stock	51.1975	51.2425	51.17	51.23	1669864.0
2019-07-15 14:00:00	AAPL	Stock	51.2288	51.275	51.2175	51.2425	2101536.0
2019-07-15 14:30:00	AAPL	Stock	51.2425	51.2825	51.2325	51.2675	1748832.0
2019-07-15 15:00:00	AAPL	Stock	51.2675	51.3	51.2475	51.275	2222480.0
2019-07-15 15:30:00	AAPL	Stock	51.275	51.305	51.19	51.3	5479648.0
2019-07-15 16:00:00	AAPL	Stock	51.3	51.3025	51.275	51.29	6668276.0
2019-07-15 16:30:00	AAPL	Stock	51.3025	51.3025	51.2775	51.2775	42756.0
2019-07-15 17:00:00	AAPL	Stock	51.2775	51.2975	51.275	51.2775	21024.0
2019-07-15 17:30:00	AAPL	Stock	51.291	51.2975	51.291	51.2975	2836.0
2019-07-15 18:00:00	AAPL	Stock	51.2975	51.2975	51.275	51.295	6200.0
2019-07-15 18:30:00	AAPL	Stock	51.275	51.275	51.275	51.275	1100.0
2019-07-15 19:30:00	AAPL	Stock	51.2975	51.3	51.2875	51.2975	23864.0
2019-07-15 04:00:00	MSFT	Stock	139.46	139.46	139.0	139.0	1080.0
2019-07-15 04:30:00	MSFT	Stock	139.25	139.25	139.2	139.2	700.0
2019-07-15 05:00:00	MSFT	Stock	139.25	139.25	139.15	139.15	639.0
2019-07-15 05:30:00	MSFT	Stock	139.0	139.15	139.0	139.15	700.0
2019-07-15 06:30:00	MSFT	Stock	139.15	139.35	139.15	139.35	1250.0
2019-07-15 07:00:00	MSFT	Stock	139.2	139.33	139.2	139.32	2844.0
2019-07-15 07:30:00	MSFT	Stock	139.32	139.4	139.3	139.3	3570.0
2019-07-15 08:00:00	MSFT	Stock	139.25	139.42	138.9	139.4	277503.0
2019-07-15 08:30:00	MSFT	Stock	139.42	139.49	139.35	139.474	10068.0
2019-07-15 09:00:00	MSFT	Stock	139.447	139.635	139.4	139.56	22363.0
2019-07-15 09:30:00	MSFT	Stock	139.5	139.54	138.46	138.93	2276805.0
2019-07-15 10:00:00	MSFT	Stock	138.935	138.99	138.58	138.81	1076203.0
2019-07-15 10:30:00	MSFT	Stock	138.81	138.92	138.56	138.86	818376.0
2019-07-15 11:00:00	MSFT	Stock	138.86	139.0	138.82	138.829	839197.0
2019-07-15 11:30:00	MSFT	Stock	138.83	138.93	138.715	138.81	683975.0
2019-07-15 12:00:00	MSFT	Stock	138.815	138.9	138.79	138.85	526879.0
2019-07-15 12:30:00	MSFT	Stock	138.85	138.86	138.69	138.77	467545.0
2019-07-15 13:00:00	MSFT	Stock	138.76	138.85	138.71	138.842	438512.0
2019-07-15 13:30:00	MSFT	Stock	138.845	138.89	138.75	138.8	425553.0
2019-07-15 14:00:00	MSFT	Stock	138.8	139.0	138.76	138.982	818573.0
2019-07-15 14:30:00	MSFT	Stock	138.99	139.0	138.88	138.902	507771.0

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

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