PREVIEW / stock_30min / 2020-02-25

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-02-25.parquet
  size:    1.9 MB
  rows:    91,145
  symbols: 2,469

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-02-25 04:00:00	AAPL	Stock	75.5	75.625	75.175	75.25	45996.0
2020-02-25 04:30:00	AAPL	Stock	75.25	75.3425	75.12	75.135	30464.0
2020-02-25 05:00:00	AAPL	Stock	75.125	75.135	75.0	75.05	6560.0
2020-02-25 05:30:00	AAPL	Stock	74.875	75.05	74.63	74.875	32228.0
2020-02-25 06:00:00	AAPL	Stock	74.875	74.9625	74.79	74.9	10596.0
2020-02-25 06:30:00	AAPL	Stock	74.9675	75.2225	74.9675	75.0525	18028.0
2020-02-25 07:00:00	AAPL	Stock	75.125	75.3675	75.0	75.195	291448.0
2020-02-25 07:30:00	AAPL	Stock	75.19	75.6225	75.165	75.6075	280720.0
2020-02-25 08:00:00	AAPL	Stock	75.225	75.617	75.025	75.325	443348.0
2020-02-25 08:30:00	AAPL	Stock	75.325	75.4775	75.25	75.35	323312.0
2020-02-25 09:00:00	AAPL	Stock	75.3875	75.5175	75.2125	75.25	459176.0
2020-02-25 09:30:00	AAPL	Stock	75.25	75.6325	74.7125	75.0225	20315760.0
2020-02-25 10:00:00	AAPL	Stock	75.01	75.22	74.32	74.4225	11171204.0
2020-02-25 10:30:00	AAPL	Stock	74.4225	74.58	73.6125	73.8478	14948484.0
2020-02-25 11:00:00	AAPL	Stock	73.8375	74.0	72.5875	73.0738	19274824.0
2020-02-25 11:30:00	AAPL	Stock	73.0578	74.02	72.855	73.8125	11529772.0
2020-02-25 12:00:00	AAPL	Stock	73.8335	74.1532	73.455	73.5525	7569616.0
2020-02-25 12:30:00	AAPL	Stock	73.545	73.97	73.3125	73.5225	6852428.0
2020-02-25 13:00:00	AAPL	Stock	73.515	73.855	73.3625	73.585	7781684.0
2020-02-25 13:30:00	AAPL	Stock	73.5858	73.5858	73.1525	73.1675	8098756.0
2020-02-25 14:00:00	AAPL	Stock	73.1688	73.2125	72.415	72.421	12338172.0
2020-02-25 14:30:00	AAPL	Stock	72.4175	72.8325	72.21	72.705	13729900.0
2020-02-25 15:00:00	AAPL	Stock	72.7125	73.12	72.0	72.1615	12538200.0
2020-02-25 15:30:00	AAPL	Stock	72.1525	72.375	71.5325	72.02	23280880.0
2020-02-25 16:00:00	AAPL	Stock	72.02	72.2	71.8925	72.0375	12920172.0
2020-02-25 16:30:00	AAPL	Stock	72.0875	72.425	72.02	72.205	334604.0
2020-02-25 17:00:00	AAPL	Stock	72.25	72.2875	72.0	72.0	63660.0
2020-02-25 17:30:00	AAPL	Stock	72.0	72.02	71.8625	71.9375	3529408.0
2020-02-25 18:00:00	AAPL	Stock	72.0	72.425	72.0	72.4125	177324.0
2020-02-25 18:30:00	AAPL	Stock	72.4125	72.4875	72.275	72.45	73584.0
2020-02-25 19:00:00	AAPL	Stock	72.4375	72.475	72.25	72.41	52572.0
2020-02-25 19:30:00	AAPL	Stock	72.41	72.45	72.075	72.075	89188.0
2020-02-25 04:00:00	MSFT	Stock	172.86	173.5	172.32	172.73	15708.0
2020-02-25 04:30:00	MSFT	Stock	172.57	172.7	172.4	172.45	7611.0
2020-02-25 05:00:00	MSFT	Stock	172.6	172.6	172.12	172.12	2584.0
2020-02-25 05:30:00	MSFT	Stock	172.02	172.2	171.14	171.62	2725.0
2020-02-25 06:00:00	MSFT	Stock	171.63	171.63	171.31	171.45	1189.0
2020-02-25 06:30:00	MSFT	Stock	171.6	172.68	171.6	172.46	3591.0
2020-02-25 07:00:00	MSFT	Stock	172.65	173.08	171.89	172.9	28503.0
2020-02-25 07:30:00	MSFT	Stock	172.8	174.0	172.59	173.69	51516.0
2020-02-25 08:00:00	MSFT	Stock	172.93	174.05	171.31	173.32	121530.0
2020-02-25 08:30:00	MSFT	Stock	173.49	174.25	173.0	173.67	72947.0
2020-02-25 09:00:00	MSFT	Stock	173.96	174.2	171.563	174.19	90970.0
2020-02-25 09:30:00	MSFT	Stock	174.19	174.84	172.08	173.4	6404414.0
2020-02-25 10:00:00	MSFT	Stock	173.402	173.89	171.51	171.975	3236250.0
2020-02-25 10:30:00	MSFT	Stock	171.95	172.9	170.59	171.47	3623235.0
2020-02-25 11:00:00	MSFT	Stock	171.44	171.79	169.88	171.2	4159569.0
2020-02-25 11:30:00	MSFT	Stock	171.21	172.519	170.64	172.27	2828571.0
2020-02-25 12:00:00	MSFT	Stock	172.26	172.84	171.45	171.78	2563681.0
2020-02-25 12:30:00	MSFT	Stock	171.77	172.6	170.81	171.26	2091953.0

> showing 50 of 91,145 rows — these rows as CSV

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