PREVIEW / stock_30min / 2020-02-27

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-02-27.parquet
  size:    1.9 MB
  rows:    95,577
  symbols: 2,453

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-27 04:00:00	AAPL	Stock	72.275	72.685	72.275	72.6775	107120.0
2020-02-27 04:30:00	AAPL	Stock	72.6825	72.875	72.25	72.25	29544.0
2020-02-27 05:00:00	AAPL	Stock	72.4075	72.475	72.245	72.345	29716.0
2020-02-27 05:30:00	AAPL	Stock	72.3375	72.5	72.0025	72.0025	47824.0
2020-02-27 06:00:00	AAPL	Stock	71.99	72.1625	71.875	72.06	45160.0
2020-02-27 06:30:00	AAPL	Stock	72.1625	72.1625	71.8075	71.8125	18296.0
2020-02-27 07:00:00	AAPL	Stock	71.95	72.0	71.2125	71.2125	319488.0
2020-02-27 07:30:00	AAPL	Stock	71.15	71.6125	70.8625	70.8725	559388.0
2020-02-27 08:00:00	AAPL	Stock	72.0	72.0	70.54	71.1725	1077852.0
2020-02-27 08:30:00	AAPL	Stock	71.125	71.335	70.7725	70.8875	523736.0
2020-02-27 09:00:00	AAPL	Stock	70.88	71.035	70.1525	70.27	1074680.0
2020-02-27 09:30:00	AAPL	Stock	70.275	71.5	70.0	70.7225	37282648.0
2020-02-27 10:00:00	AAPL	Stock	70.7075	71.0325	68.9375	69.2825	27794196.0
2020-02-27 10:30:00	AAPL	Stock	69.264	70.3125	68.435	70.2975	28437244.0
2020-02-27 11:00:00	AAPL	Stock	70.2875	71.1225	70.175	70.2025	19610628.0
2020-02-27 11:30:00	AAPL	Stock	70.2175	70.5875	69.505	70.5128	13975256.0
2020-02-27 12:00:00	AAPL	Stock	70.505	71.1475	70.1525	70.7025	15697296.0
2020-02-27 12:30:00	AAPL	Stock	70.695	71.4125	70.5275	70.57	13562836.0
2020-02-27 13:00:00	AAPL	Stock	70.565	71.055	70.2875	70.3072	8988408.0
2020-02-27 13:30:00	AAPL	Stock	70.3125	70.825	69.7125	70.1458	13104584.0
2020-02-27 14:00:00	AAPL	Stock	70.1125	70.255	69.66	70.2012	10460624.0
2020-02-27 14:30:00	AAPL	Stock	70.19	70.195	69.5112	69.56	7669164.0
2020-02-27 15:00:00	AAPL	Stock	69.5588	70.19	69.2725	69.4375	13792752.0
2020-02-27 15:30:00	AAPL	Stock	69.4375	69.5098	68.24	68.26	26154344.0
2020-02-27 16:00:00	AAPL	Stock	68.38	68.6625	68.025	68.3	19055492.0
2020-02-27 16:30:00	AAPL	Stock	68.3475	68.5	67.45	67.525	917764.0
2020-02-27 17:00:00	AAPL	Stock	67.4675	67.7	67.45	67.575	290600.0
2020-02-27 17:30:00	AAPL	Stock	67.5875	68.38	67.5375	67.5375	189168.0
2020-02-27 18:00:00	AAPL	Stock	67.5375	68.11	67.25	68.0	407044.0
2020-02-27 18:30:00	AAPL	Stock	67.9125	68.095	67.75	68.0	143424.0
2020-02-27 19:00:00	AAPL	Stock	68.0	68.11	67.375	67.43	201932.0
2020-02-27 19:30:00	AAPL	Stock	67.475	67.725	67.375	67.725	570780.0
2020-02-27 04:00:00	MSFT	Stock	166.77	168.36	166.1	168.09	15196.0
2020-02-27 04:30:00	MSFT	Stock	168.0	168.1	167.0	167.0	8302.0
2020-02-27 05:00:00	MSFT	Stock	167.48	167.48	166.8	166.8	10956.0
2020-02-27 05:30:00	MSFT	Stock	166.8	167.05	166.15	166.2	10543.0
2020-02-27 06:00:00	MSFT	Stock	166.2	166.34	165.95	166.06	17487.0
2020-02-27 06:30:00	MSFT	Stock	166.11	166.5	165.77	165.77	6682.0
2020-02-27 07:00:00	MSFT	Stock	165.75	166.0	164.37	164.37	115395.0
2020-02-27 07:30:00	MSFT	Stock	164.37	165.16	163.32	163.5	192345.0
2020-02-27 08:00:00	MSFT	Stock	165.55	165.99	162.2	163.45	288955.0
2020-02-27 08:30:00	MSFT	Stock	163.5	170.17	163.45	163.45	237341.0
2020-02-27 09:00:00	MSFT	Stock	163.64	163.64	162.5	163.27	247000.0
2020-02-27 09:30:00	MSFT	Stock	163.37	166.66	162.5	165.97	11555536.0
2020-02-27 10:00:00	MSFT	Stock	165.94	166.45	163.49	163.86	6856953.0
2020-02-27 10:30:00	MSFT	Stock	163.86	164.97	161.86	164.95	6339934.0
2020-02-27 11:00:00	MSFT	Stock	164.91	166.465	164.42	164.52	5022274.0
2020-02-27 11:30:00	MSFT	Stock	164.5	165.25	163.409	165.092	3633604.0
2020-02-27 12:00:00	MSFT	Stock	165.08	165.96	164.24	165.35	3209531.0
2020-02-27 12:30:00	MSFT	Stock	165.34	167.03	165.12	165.58	3741302.0

> showing 50 of 95,577 rows — these rows as CSV

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