PREVIEW / stock_30min / 2020-02-12

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-02-12.parquet
  size:    1.8 MB
  rows:    87,409
  symbols: 2,415

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-12 04:00:00	AAPL	Stock	80.305	80.305	80.25	80.25	8492.0
2020-02-12 04:30:00	AAPL	Stock	80.285	80.325	80.285	80.3125	8256.0
2020-02-12 05:00:00	AAPL	Stock	80.32	80.32	80.25	80.25	5752.0
2020-02-12 05:30:00	AAPL	Stock	80.2625	80.2875	80.2075	80.2075	3164.0
2020-02-12 06:00:00	AAPL	Stock	80.3	80.315	80.235	80.3125	6028.0
2020-02-12 06:30:00	AAPL	Stock	80.24	80.275	80.225	80.25	11928.0
2020-02-12 07:00:00	AAPL	Stock	80.25	80.2975	80.155	80.265	126016.0
2020-02-12 07:30:00	AAPL	Stock	80.265	80.2925	80.165	80.2925	74848.0
2020-02-12 08:00:00	AAPL	Stock	80.25	80.455	80.15	80.3975	268896.0
2020-02-12 08:30:00	AAPL	Stock	80.4	80.475	80.3445	80.4225	116664.0
2020-02-12 09:00:00	AAPL	Stock	80.425	80.6025	80.3075	80.39	486320.0
2020-02-12 09:30:00	AAPL	Stock	80.3875	80.9725	80.3675	80.8652	13775368.0
2020-02-12 10:00:00	AAPL	Stock	80.8725	80.913	80.575	80.59	6886688.0
2020-02-12 10:30:00	AAPL	Stock	80.59	80.8725	80.575	80.81	5408660.0
2020-02-12 11:00:00	AAPL	Stock	80.8175	81.16	80.7925	81.04	7285024.0
2020-02-12 11:30:00	AAPL	Stock	81.045	81.145	80.9275	81.0975	4144208.0
2020-02-12 12:00:00	AAPL	Stock	81.095	81.205	81.0	81.2	3412560.0
2020-02-12 12:30:00	AAPL	Stock	81.1975	81.35	81.14	81.3225	6042468.0
2020-02-12 13:00:00	AAPL	Stock	81.325	81.335	81.1575	81.275	4305148.0
2020-02-12 13:30:00	AAPL	Stock	81.2775	81.315	81.2	81.2875	2402024.0
2020-02-12 14:00:00	AAPL	Stock	81.2825	81.335	81.1825	81.24	2982288.0
2020-02-12 14:30:00	AAPL	Stock	81.239	81.3825	81.2125	81.315	3353608.0
2020-02-12 15:00:00	AAPL	Stock	81.3175	81.3675	81.2175	81.35	3943464.0
2020-02-12 15:30:00	AAPL	Stock	81.3475	81.8025	81.3	81.8	14425128.0
2020-02-12 16:00:00	AAPL	Stock	81.8	81.8375	81.7	81.8375	8697332.0
2020-02-12 16:30:00	AAPL	Stock	81.8325	81.8375	81.78	81.8	129136.0
2020-02-12 17:00:00	AAPL	Stock	81.7775	81.7875	81.7	81.71	161872.0
2020-02-12 17:30:00	AAPL	Stock	81.7125	81.8	81.7	81.7125	39028.0
2020-02-12 18:00:00	AAPL	Stock	81.7	81.7875	81.7	81.7875	51928.0
2020-02-12 18:30:00	AAPL	Stock	81.7875	81.8125	81.25	81.3025	244548.0
2020-02-12 19:00:00	AAPL	Stock	81.3875	81.445	81.2275	81.2275	203752.0
2020-02-12 19:30:00	AAPL	Stock	81.2275	81.3375	81.125	81.2625	195512.0
2020-02-12 04:00:00	MSFT	Stock	185.5	186.29	185.5	186.09	9296.0
2020-02-12 04:30:00	MSFT	Stock	186.02	186.37	185.95	186.37	6926.0
2020-02-12 05:00:00	MSFT	Stock	186.27	186.27	186.07	186.16	2145.0
2020-02-12 05:30:00	MSFT	Stock	186.34	186.38	186.07	186.38	4324.0
2020-02-12 06:00:00	MSFT	Stock	186.19	186.4	186.19	186.23	2696.0
2020-02-12 06:30:00	MSFT	Stock	186.37	186.5	186.35	186.35	5250.0
2020-02-12 07:00:00	MSFT	Stock	186.31	186.49	185.86	186.03	49782.0
2020-02-12 07:30:00	MSFT	Stock	186.05	186.05	185.57	185.9	26750.0
2020-02-12 08:00:00	MSFT	Stock	186.4	186.49	184.9	186.23	129339.0
2020-02-12 08:30:00	MSFT	Stock	186.16	186.214	185.9	186.04	55582.0
2020-02-12 09:00:00	MSFT	Stock	186.06	186.49	185.52	185.66	162595.0
2020-02-12 09:30:00	MSFT	Stock	185.6	185.835	181.85	182.89	9066818.0
2020-02-12 10:00:00	MSFT	Stock	182.89	183.72	182.42	182.98	4729575.0
2020-02-12 10:30:00	MSFT	Stock	182.98	183.03	182.05	182.535	2958983.0
2020-02-12 11:00:00	MSFT	Stock	182.54	184.384	182.54	184.01	3386667.0
2020-02-12 11:30:00	MSFT	Stock	184.02	184.94	183.88	184.26	2759627.0
2020-02-12 12:00:00	MSFT	Stock	184.242	184.57	183.97	184.43	1307487.0
2020-02-12 12:30:00	MSFT	Stock	184.44	185.25	184.4	184.81	1776860.0

> showing 50 of 87,409 rows — these rows as CSV

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