PREVIEW / stock_30min / 2019-11-25

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-11-25.parquet
  size:    1.8 MB
  rows:    85,559
  symbols: 2,516

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-25 04:00:00	AAPL	Stock	65.6675	65.7975	65.6675	65.7925	9972.0
2019-11-25 04:30:00	AAPL	Stock	65.7	65.7	65.7	65.7	2764.0
2019-11-25 05:00:00	AAPL	Stock	65.7475	65.7475	65.7475	65.7475	2396.0
2019-11-25 05:30:00	AAPL	Stock	65.7475	65.75	65.7475	65.75	3512.0
2019-11-25 06:00:00	AAPL	Stock	65.7625	65.7625	65.7625	65.7625	2800.0
2019-11-25 06:30:00	AAPL	Stock	65.745	65.745	65.7375	65.7375	2348.0
2019-11-25 07:00:00	AAPL	Stock	65.7375	65.7375	65.6575	65.6575	49556.0
2019-11-25 07:30:00	AAPL	Stock	65.685	65.7	65.6675	65.6875	9648.0
2019-11-25 08:00:00	AAPL	Stock	65.6625	65.7212	65.4	65.525	311892.0
2019-11-25 08:30:00	AAPL	Stock	65.5475	65.6375	65.5475	65.6375	51024.0
2019-11-25 09:00:00	AAPL	Stock	65.6275	65.6775	65.585	65.6575	64912.0
2019-11-25 09:30:00	AAPL	Stock	65.66	66.21	65.63	66.1425	9022568.0
2019-11-25 10:00:00	AAPL	Stock	66.1475	66.298	66.105	66.2938	4741076.0
2019-11-25 10:30:00	AAPL	Stock	66.2947	66.41	66.2775	66.325	4589676.0
2019-11-25 11:00:00	AAPL	Stock	66.3275	66.37	66.26	66.2925	3283980.0
2019-11-25 11:30:00	AAPL	Stock	66.2915	66.33	66.2125	66.2725	2341380.0
2019-11-25 12:00:00	AAPL	Stock	66.2735	66.305	66.235	66.2565	1715292.0
2019-11-25 12:30:00	AAPL	Stock	66.255	66.305	66.2462	66.275	1185984.0
2019-11-25 13:00:00	AAPL	Stock	66.275	66.3125	66.2125	66.2175	2010888.0
2019-11-25 13:30:00	AAPL	Stock	66.2188	66.2378	66.155	66.184	1925812.0
2019-11-25 14:00:00	AAPL	Stock	66.1825	66.25	66.145	66.25	1799420.0
2019-11-25 14:30:00	AAPL	Stock	66.245	66.3175	66.19	66.3145	2143700.0
2019-11-25 15:00:00	AAPL	Stock	66.31	66.4575	66.2925	66.4475	3867516.0
2019-11-25 15:30:00	AAPL	Stock	66.45	66.61	66.4125	66.605	8194548.0
2019-11-25 16:00:00	AAPL	Stock	66.605	66.605	66.525	66.5625	19370412.0
2019-11-25 16:30:00	AAPL	Stock	66.5625	66.5925	66.555	66.575	126124.0
2019-11-25 17:00:00	AAPL	Stock	66.5625	66.5725	66.5375	66.5725	41536.0
2019-11-25 17:30:00	AAPL	Stock	66.5725	66.575	66.5525	66.5675	16416.0
2019-11-25 18:00:00	AAPL	Stock	66.5675	66.5825	66.5625	66.5825	8128.0
2019-11-25 18:30:00	AAPL	Stock	66.5825	66.5925	66.5675	66.5925	10976.0
2019-11-25 19:00:00	AAPL	Stock	66.605	66.645	66.5775	66.645	45052.0
2019-11-25 19:30:00	AAPL	Stock	66.645	66.6775	66.6375	66.6775	20088.0
2019-11-25 04:00:00	MSFT	Stock	149.98	150.0	149.98	150.0	919.0
2019-11-25 04:30:00	MSFT	Stock	150.2	150.2	150.15	150.2	595.0
2019-11-25 05:00:00	MSFT	Stock	150.21	150.23	150.21	150.23	350.0
2019-11-25 05:30:00	MSFT	Stock	150.22	150.23	150.21	150.23	1599.0
2019-11-25 06:00:00	MSFT	Stock	150.32	150.32	150.25	150.25	497.0
2019-11-25 07:00:00	MSFT	Stock	150.23	150.23	150.01	150.07	9570.0
2019-11-25 07:30:00	MSFT	Stock	150.12	150.15	150.08	150.15	7906.0
2019-11-25 08:00:00	MSFT	Stock	150.07	150.19	150.03	150.15	16908.0
2019-11-25 08:30:00	MSFT	Stock	150.06	150.14	150.06	150.1	6659.0
2019-11-25 09:00:00	MSFT	Stock	150.1	150.1	149.95	150.0	18257.0
2019-11-25 09:30:00	MSFT	Stock	150.02	150.79	149.92	150.64	2249633.0
2019-11-25 10:00:00	MSFT	Stock	150.65	150.67	150.3	150.52	877447.0
2019-11-25 10:30:00	MSFT	Stock	150.522	150.865	150.52	150.77	1009660.0
2019-11-25 11:00:00	MSFT	Stock	150.775	150.96	150.7	150.915	747411.0
2019-11-25 11:30:00	MSFT	Stock	150.915	150.939	150.724	150.8	694409.0
2019-11-25 12:00:00	MSFT	Stock	150.8	150.83	150.66	150.734	535295.0
2019-11-25 12:30:00	MSFT	Stock	150.73	150.82	150.67	150.775	355935.0
2019-11-25 13:00:00	MSFT	Stock	150.78	150.83	150.7	150.795	559385.0

> showing 50 of 85,559 rows — these rows as CSV

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