PREVIEW / stock_30min / 2020-02-05

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-02-05.parquet
  size:    1.8 MB
  rows:    87,604
  symbols: 2,428

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-05 04:00:00	AAPL	Stock	80.1625	80.495	79.9975	80.455	123148.0
2020-02-05 04:30:00	AAPL	Stock	80.4875	80.9	80.41	80.5975	127424.0
2020-02-05 05:00:00	AAPL	Stock	80.575	80.6925	80.4475	80.4475	52720.0
2020-02-05 05:30:00	AAPL	Stock	80.485	80.485	80.25	80.375	77932.0
2020-02-05 06:00:00	AAPL	Stock	80.315	80.575	80.315	80.575	24444.0
2020-02-05 06:30:00	AAPL	Stock	80.5375	80.575	80.2525	80.325	40656.0
2020-02-05 07:00:00	AAPL	Stock	80.36	80.5875	80.2125	80.4975	459060.0
2020-02-05 07:30:00	AAPL	Stock	80.5225	80.525	80.45	80.47	241632.0
2020-02-05 08:00:00	AAPL	Stock	80.2625	80.74	80.215	80.6975	620592.0
2020-02-05 08:30:00	AAPL	Stock	80.7025	80.82	80.6325	80.8	538476.0
2020-02-05 09:00:00	AAPL	Stock	80.8	80.91	80.725	80.875	741256.0
2020-02-05 09:30:00	AAPL	Stock	80.8775	81.19	80.2278	80.75	19472248.0
2020-02-05 10:00:00	AAPL	Stock	80.75	80.875	80.015	80.175	9679756.0
2020-02-05 10:30:00	AAPL	Stock	80.175	80.295	79.7375	80.195	11077340.0
2020-02-05 11:00:00	AAPL	Stock	80.185	80.3972	80.075	80.2425	6738996.0
2020-02-05 11:30:00	AAPL	Stock	80.235	80.35	79.93	80.3425	5800516.0
2020-02-05 12:00:00	AAPL	Stock	80.3375	80.5125	80.225	80.34	5022144.0
2020-02-05 12:30:00	AAPL	Stock	80.3375	80.43	80.25	80.3425	2369620.0
2020-02-05 13:00:00	AAPL	Stock	80.345	80.3525	79.9875	80.0625	3748904.0
2020-02-05 13:30:00	AAPL	Stock	80.0575	80.2275	80.01	80.1525	2690004.0
2020-02-05 14:00:00	AAPL	Stock	80.1525	80.2825	80.0175	80.1888	2926060.0
2020-02-05 14:30:00	AAPL	Stock	80.1888	80.38	80.15	80.3162	3819884.0
2020-02-05 15:00:00	AAPL	Stock	80.3162	80.625	80.3162	80.545	5937648.0
2020-02-05 15:30:00	AAPL	Stock	80.545	80.5625	80.1325	80.395	10395560.0
2020-02-05 16:00:00	AAPL	Stock	80.3625	80.4475	80.265	80.39	6879176.0
2020-02-05 16:30:00	AAPL	Stock	80.3942	80.5125	80.3625	80.4375	136832.0
2020-02-05 17:00:00	AAPL	Stock	80.4575	80.4575	80.3625	80.4	467512.0
2020-02-05 17:30:00	AAPL	Stock	80.4	80.475	80.4	80.475	36428.0
2020-02-05 18:00:00	AAPL	Stock	80.45	80.4975	80.4275	80.49	27644.0
2020-02-05 18:30:00	AAPL	Stock	80.4875	80.5	80.425	80.4675	19896.0
2020-02-05 19:00:00	AAPL	Stock	80.4375	80.4625	80.4125	80.445	49916.0
2020-02-05 19:30:00	AAPL	Stock	80.445	80.5	80.4125	80.5	70952.0
2020-02-05 04:00:00	MSFT	Stock	181.2	182.35	181.2	182.35	3587.0
2020-02-05 04:30:00	MSFT	Stock	182.5	183.2	182.5	183.2	10571.0
2020-02-05 05:00:00	MSFT	Stock	183.18	183.18	182.85	182.85	8173.0
2020-02-05 05:30:00	MSFT	Stock	182.77	183.36	182.68	183.25	4502.0
2020-02-05 06:00:00	MSFT	Stock	183.27	183.39	183.1	183.3	3815.0
2020-02-05 06:30:00	MSFT	Stock	183.3	183.3	182.4	182.6	6799.0
2020-02-05 07:00:00	MSFT	Stock	182.78	183.71	182.44	183.69	139402.0
2020-02-05 07:30:00	MSFT	Stock	183.62	183.83	183.35	183.5	90518.0
2020-02-05 08:00:00	MSFT	Stock	182.79	183.98	182.75	183.8	113131.0
2020-02-05 08:30:00	MSFT	Stock	183.8	184.25	183.76	184.0	111039.0
2020-02-05 09:00:00	MSFT	Stock	184.02	184.24	183.72	184.04	71650.0
2020-02-05 09:30:00	MSFT	Stock	184.03	184.2	181.06	181.46	5593493.0
2020-02-05 10:00:00	MSFT	Stock	181.47	182.327	181.1	181.27	2693834.0
2020-02-05 10:30:00	MSFT	Stock	181.25	181.39	179.92	180.37	3246403.0
2020-02-05 11:00:00	MSFT	Stock	180.37	180.38	179.01	179.38	2556762.0
2020-02-05 11:30:00	MSFT	Stock	179.38	179.55	178.41	179.16	2282192.0
2020-02-05 12:00:00	MSFT	Stock	179.16	180.09	179.08	179.75	1754175.0
2020-02-05 12:30:00	MSFT	Stock	179.76	179.76	179.33	179.39	983591.0

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

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