PREVIEW / stock_30min / 2020-03-06

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-03-06.parquet
  size:    1.9 MB
  rows:    92,190
  symbols: 2,420

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-03-06 04:00:00	AAPL	Stock	72.25	72.25	71.9	71.9025	23544.0
2020-03-06 04:30:00	AAPL	Stock	71.9925	71.9925	71.44	71.575	59652.0
2020-03-06 05:00:00	AAPL	Stock	71.4025	71.4025	71.0025	71.0075	33556.0
2020-03-06 05:30:00	AAPL	Stock	71.0025	71.0025	70.2625	70.75	92660.0
2020-03-06 06:00:00	AAPL	Stock	70.755	71.0	70.5275	70.7825	58748.0
2020-03-06 06:30:00	AAPL	Stock	70.925	71.1325	70.785	70.8775	53660.0
2020-03-06 07:00:00	AAPL	Stock	70.925	71.265	70.345	70.4	651944.0
2020-03-06 07:30:00	AAPL	Stock	70.4	70.6675	70.075	70.56	488952.0
2020-03-06 08:00:00	AAPL	Stock	70.55	71.26	70.06	70.6125	669552.0
2020-03-06 08:30:00	AAPL	Stock	70.62	70.995	70.34	70.88	837576.0
2020-03-06 09:00:00	AAPL	Stock	70.8675	70.8675	70.125	70.475	1261976.0
2020-03-06 09:30:00	AAPL	Stock	70.475	71.3775	70.3075	71.0958	26629128.0
2020-03-06 10:00:00	AAPL	Stock	71.1	72.09	71.0788	72.0325	17970444.0
2020-03-06 10:30:00	AAPL	Stock	72.0275	72.5125	71.6862	71.9575	14373516.0
2020-03-06 11:00:00	AAPL	Stock	71.9625	72.0075	71.2825	71.53	10274340.0
2020-03-06 11:30:00	AAPL	Stock	71.5125	71.86	71.0275	71.1295	9435932.0
2020-03-06 12:00:00	AAPL	Stock	71.14	71.325	70.8975	71.1882	7862708.0
2020-03-06 12:30:00	AAPL	Stock	71.1925	71.8975	71.125	71.32	8743256.0
2020-03-06 13:00:00	AAPL	Stock	71.31	72.0588	71.3025	71.825	7298836.0
2020-03-06 13:30:00	AAPL	Stock	71.8025	71.9375	71.105	71.2	7489320.0
2020-03-06 14:00:00	AAPL	Stock	71.2138	71.3695	70.9675	71.2025	7361816.0
2020-03-06 14:30:00	AAPL	Stock	71.2175	71.2962	70.4975	70.6225	11001692.0
2020-03-06 15:00:00	AAPL	Stock	70.625	71.285	70.4	70.92	13215136.0
2020-03-06 15:30:00	AAPL	Stock	70.9	72.705	70.755	72.245	25884956.0
2020-03-06 16:00:00	AAPL	Stock	72.25	72.45	72.0125	72.2575	14640860.0
2020-03-06 16:30:00	AAPL	Stock	72.225	72.25	72.0	72.0525	195304.0
2020-03-06 17:00:00	AAPL	Stock	72.12	72.2575	71.85	71.8625	101556.0
2020-03-06 17:30:00	AAPL	Stock	71.85	71.8775	71.5975	71.67	126576.0
2020-03-06 18:00:00	AAPL	Stock	71.6125	71.8375	71.6	71.725	50300.0
2020-03-06 18:30:00	AAPL	Stock	71.75	71.75	71.625	71.73	59128.0
2020-03-06 19:00:00	AAPL	Stock	71.6375	71.735	71.625	71.625	33780.0
2020-03-06 19:30:00	AAPL	Stock	71.62	71.6475	71.4625	71.5	59132.0
2020-03-06 04:00:00	MSFT	Stock	164.74	164.74	163.63	163.63	2676.0
2020-03-06 04:30:00	MSFT	Stock	163.65	164.0	162.14	162.14	11704.0
2020-03-06 05:00:00	MSFT	Stock	162.14	162.27	161.66	161.66	6209.0
2020-03-06 05:30:00	MSFT	Stock	161.55	161.55	160.8	161.5	7830.0
2020-03-06 06:00:00	MSFT	Stock	161.5	162.25	161.22	161.45	10970.0
2020-03-06 06:30:00	MSFT	Stock	161.52	162.13	161.33	161.33	7169.0
2020-03-06 07:00:00	MSFT	Stock	161.5	162.89	160.99	161.2	63677.0
2020-03-06 07:30:00	MSFT	Stock	161.31	161.88	160.5	161.17	64132.0
2020-03-06 08:00:00	MSFT	Stock	161.7	162.41	160.1	160.6	108603.0
2020-03-06 08:30:00	MSFT	Stock	160.6	161.78	160.29	161.22	117277.0
2020-03-06 09:00:00	MSFT	Stock	161.22	162.79	159.81	162.56	362156.0
2020-03-06 09:30:00	MSFT	Stock	162.61	163.11	159.67	160.59	7997171.0
2020-03-06 10:00:00	MSFT	Stock	160.59	161.8	159.08	161.67	5208114.0
2020-03-06 10:30:00	MSFT	Stock	161.66	162.44	160.49	161.39	4045596.0
2020-03-06 11:00:00	MSFT	Stock	161.4	161.55	160.6	161.35	2582008.0
2020-03-06 11:30:00	MSFT	Stock	161.34	161.98	160.12	160.36	2371674.0
2020-03-06 12:00:00	MSFT	Stock	160.36	160.58	159.03	159.11	2793077.0
2020-03-06 12:30:00	MSFT	Stock	159.12	160.49	159.0	159.55	2586796.0

> showing 50 of 92,190 rows — these rows as CSV

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