PREVIEW / stock_30min / 2020-05-12

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-05-12.parquet
  size:    1.9 MB
  rows:    94,919
  symbols: 2,373

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-05-12 04:00:00	AAPL	Stock	78.8025	78.8025	78.56	78.675	18524.0
2020-05-12 04:30:00	AAPL	Stock	78.63	78.63	78.63	78.63	400.0
2020-05-12 05:00:00	AAPL	Stock	78.6	78.65	78.5025	78.65	6344.0
2020-05-12 05:30:00	AAPL	Stock	78.6	78.75	78.535	78.7175	10540.0
2020-05-12 06:00:00	AAPL	Stock	78.7475	78.925	78.7475	78.9225	15188.0
2020-05-12 06:30:00	AAPL	Stock	78.9575	79.0375	78.9	78.9	17516.0
2020-05-12 07:00:00	AAPL	Stock	78.995	79.4875	78.995	79.4875	355188.0
2020-05-12 07:30:00	AAPL	Stock	79.485	79.4975	79.27	79.3725	139760.0
2020-05-12 08:00:00	AAPL	Stock	79.375	79.4975	79.0	79.375	371584.0
2020-05-12 08:30:00	AAPL	Stock	79.325	79.3875	79.1775	79.36	193980.0
2020-05-12 09:00:00	AAPL	Stock	79.375	79.52	79.2675	79.48	254872.0
2020-05-12 09:30:00	AAPL	Stock	79.48	79.775	78.9375	79.38	24524976.0
2020-05-12 10:00:00	AAPL	Stock	79.38	79.4795	79.02	79.2925	9690960.0
2020-05-12 10:30:00	AAPL	Stock	79.295	79.6	79.2175	79.5512	7429596.0
2020-05-12 11:00:00	AAPL	Stock	79.555	79.7825	79.49	79.55	6630400.0
2020-05-12 11:30:00	AAPL	Stock	79.5525	79.67	79.4075	79.5923	4759156.0
2020-05-12 12:00:00	AAPL	Stock	79.5975	79.72	79.495	79.6575	4640620.0
2020-05-12 12:30:00	AAPL	Stock	79.6625	79.922	79.6425	79.84	5903380.0
2020-05-12 13:00:00	AAPL	Stock	79.8372	79.8525	79.085	79.28	8492944.0
2020-05-12 13:30:00	AAPL	Stock	79.285	79.6475	79.1525	79.6075	5767244.0
2020-05-12 14:00:00	AAPL	Stock	79.615	79.6275	79.2255	79.3868	5583912.0
2020-05-12 14:30:00	AAPL	Stock	79.3825	79.4125	79.0725	79.3175	6338448.0
2020-05-12 15:00:00	AAPL	Stock	79.3125	79.375	78.755	78.8625	7628504.0
2020-05-12 15:30:00	AAPL	Stock	78.8665	78.95	77.7275	77.835	22161520.0
2020-05-12 16:00:00	AAPL	Stock	77.8358	79.1002	77.6275	77.6575	9997412.0
2020-05-12 16:30:00	AAPL	Stock	77.625	77.69	77.275	77.275	560856.0
2020-05-12 17:00:00	AAPL	Stock	77.3125	77.3725	77.15	77.3375	266700.0
2020-05-12 17:30:00	AAPL	Stock	77.3325	77.49	77.3025	77.4375	126696.0
2020-05-12 18:00:00	AAPL	Stock	77.4375	77.625	77.3	77.515	230392.0
2020-05-12 18:30:00	AAPL	Stock	77.5025	77.5175	77.3725	77.3875	67952.0
2020-05-12 19:00:00	AAPL	Stock	77.365	77.435	77.355	77.425	39556.0
2020-05-12 19:30:00	AAPL	Stock	77.4	77.4125	77.25	77.25	338384.0
2020-05-12 04:00:00	MSFT	Stock	186.04	186.04	186.04	186.04	120.0
2020-05-12 04:30:00	MSFT	Stock	186.48	186.48	186.48	186.48	105.0
2020-05-12 05:00:00	MSFT	Stock	186.21	186.21	186.07	186.07	615.0
2020-05-12 05:30:00	MSFT	Stock	186.3	186.3	186.3	186.3	849.0
2020-05-12 06:00:00	MSFT	Stock	186.69	186.69	186.69	186.69	100.0
2020-05-12 06:30:00	MSFT	Stock	186.9	186.9	186.9	186.9	100.0
2020-05-12 07:00:00	MSFT	Stock	187.4	187.49	186.76	187.47	12046.0
2020-05-12 07:30:00	MSFT	Stock	187.47	187.49	186.95	187.24	19945.0
2020-05-12 08:00:00	MSFT	Stock	186.9	187.49	186.83	187.03	104240.0
2020-05-12 08:30:00	MSFT	Stock	187.03	187.36	186.74	187.35	36845.0
2020-05-12 09:00:00	MSFT	Stock	187.37	187.45	186.69	186.87	61055.0
2020-05-12 09:30:00	MSFT	Stock	186.89	187.0	185.09	185.82	4272750.0
2020-05-12 10:00:00	MSFT	Stock	185.84	186.15	185.25	185.88	1730931.0
2020-05-12 10:30:00	MSFT	Stock	185.84	186.55	185.72	186.37	1736909.0
2020-05-12 11:00:00	MSFT	Stock	186.42	187.04	186.33	186.54	1311350.0
2020-05-12 11:30:00	MSFT	Stock	186.57	186.76	186.05	186.48	779741.0
2020-05-12 12:00:00	MSFT	Stock	186.49	186.93	186.44	186.852	923039.0
2020-05-12 12:30:00	MSFT	Stock	186.85	186.94	186.57	186.8	757187.0

> showing 50 of 94,919 rows — these rows as CSV

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