PREVIEW / stock_30min / 2020-04-16

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-04-16.parquet
  size:    1.9 MB
  rows:    96,132
  symbols: 2,389

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
2020-04-16 04:00:00	AAPL	Stock	71.9175	72.1425	71.9175	72.125	37040.0
2020-04-16 04:30:00	AAPL	Stock	72.0875	72.1725	72.0525	72.11	13424.0
2020-04-16 05:00:00	AAPL	Stock	71.89	72.045	71.85	71.95	4880.0
2020-04-16 05:30:00	AAPL	Stock	71.9425	72.0475	71.9425	72.025	6692.0
2020-04-16 06:00:00	AAPL	Stock	72.025	72.2075	71.9525	72.2075	13664.0
2020-04-16 06:30:00	AAPL	Stock	72.2	72.2525	72.0625	72.15	29448.0
2020-04-16 07:00:00	AAPL	Stock	72.0875	72.125	71.86	71.8775	132588.0
2020-04-16 07:30:00	AAPL	Stock	71.9025	71.9175	71.67	71.7375	147488.0
2020-04-16 08:00:00	AAPL	Stock	71.9375	72.05	71.285	71.85	404560.0
2020-04-16 08:30:00	AAPL	Stock	71.84	72.2125	71.84	72.015	622684.0
2020-04-16 09:00:00	AAPL	Stock	72.045	72.25	71.8	71.825	350288.0
2020-04-16 09:30:00	AAPL	Stock	71.825	72.0495	71.265	71.3025	18705656.0
2020-04-16 10:00:00	AAPL	Stock	71.3075	71.48	70.8825	71.465	13349776.0
2020-04-16 10:30:00	AAPL	Stock	71.4645	71.705	71.075	71.6625	9770188.0
2020-04-16 11:00:00	AAPL	Stock	71.67	71.9725	71.4525	71.914	8502848.0
2020-04-16 11:30:00	AAPL	Stock	71.912	71.95	71.5275	71.7025	6821216.0
2020-04-16 12:00:00	AAPL	Stock	71.6875	71.75	70.8875	70.96	7900380.0
2020-04-16 12:30:00	AAPL	Stock	70.955	71.0625	70.5875	70.985	7043368.0
2020-04-16 13:00:00	AAPL	Stock	70.99	71.2475	70.965	71.118	4814456.0
2020-04-16 13:30:00	AAPL	Stock	71.11	71.22	70.815	70.89	4743100.0
2020-04-16 14:00:00	AAPL	Stock	70.8975	71.2325	70.7113	71.0683	6756884.0
2020-04-16 14:30:00	AAPL	Stock	71.065	71.2975	70.96	71.162	5530548.0
2020-04-16 15:00:00	AAPL	Stock	71.154	71.275	70.95	71.27	5744196.0
2020-04-16 15:30:00	AAPL	Stock	71.2725	71.8025	71.2525	71.68	14710968.0
2020-04-16 16:00:00	AAPL	Stock	71.6102	71.7475	71.4355	71.6675	11163564.0
2020-04-16 16:30:00	AAPL	Stock	71.675	72.3	71.65	72.3	616256.0
2020-04-16 17:00:00	AAPL	Stock	72.305	73.21	72.25	72.9	444396.0
2020-04-16 17:30:00	AAPL	Stock	72.875	73.35	72.7875	73.25	436560.0
2020-04-16 18:00:00	AAPL	Stock	73.2725	73.475	72.785	73.425	391392.0
2020-04-16 18:30:00	AAPL	Stock	73.425	73.8875	73.4125	73.775	412188.0
2020-04-16 19:00:00	AAPL	Stock	73.81	74.2125	73.75	74.0625	434056.0
2020-04-16 19:30:00	AAPL	Stock	74.06	74.0725	73.5925	73.8425	340424.0
2020-04-16 04:00:00	MSFT	Stock	173.66	174.3	173.66	174.3	9333.0
2020-04-16 04:30:00	MSFT	Stock	174.2	174.47	173.97	174.11	5623.0
2020-04-16 05:00:00	MSFT	Stock	174.1	174.32	173.5	174.0	10026.0
2020-04-16 05:30:00	MSFT	Stock	173.9	174.68	173.9	174.35	28387.0
2020-04-16 06:00:00	MSFT	Stock	174.31	174.77	174.08	174.77	4170.0
2020-04-16 06:30:00	MSFT	Stock	174.75	175.0	174.5	174.85	62973.0
2020-04-16 07:00:00	MSFT	Stock	174.85	175.0	174.16	174.65	145130.0
2020-04-16 07:30:00	MSFT	Stock	174.6	174.6	173.51	173.82	52816.0
2020-04-16 08:00:00	MSFT	Stock	174.551	174.8	172.3	174.0	98615.0
2020-04-16 08:30:00	MSFT	Stock	174.28	174.94	174.118	174.58	85290.0
2020-04-16 09:00:00	MSFT	Stock	174.58	174.94	174.25	174.3	64762.0
2020-04-16 09:30:00	MSFT	Stock	174.3	175.38	173.52	173.66	5246756.0
2020-04-16 10:00:00	MSFT	Stock	173.7	174.28	172.9	174.01	3120884.0
2020-04-16 10:30:00	MSFT	Stock	174.015	175.0	173.68	174.89	2631631.0
2020-04-16 11:00:00	MSFT	Stock	174.9	176.69	174.71	176.36	3605815.0
2020-04-16 11:30:00	MSFT	Stock	176.36	176.74	175.73	176.47	2569545.0
2020-04-16 12:00:00	MSFT	Stock	176.48	176.66	174.13	174.46	2523542.0
2020-04-16 12:30:00	MSFT	Stock	174.48	174.48	173.12	174.11	2347646.0

> showing 50 of 96,132 rows — these rows as CSV

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