PREVIEW / stock_30min / 2020-02-19

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-02-19.parquet
  size:    1.8 MB
  rows:    87,953
  symbols: 2,443

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-19 04:00:00	AAPL	Stock	80.0375	80.2475	80.0375	80.1625	18876.0
2020-02-19 04:30:00	AAPL	Stock	80.2325	80.2475	80.075	80.075	16956.0
2020-02-19 05:00:00	AAPL	Stock	80.1375	80.31	80.1375	80.25	15368.0
2020-02-19 05:30:00	AAPL	Stock	80.275	80.3375	80.175	80.2	4440.0
2020-02-19 06:00:00	AAPL	Stock	80.175	80.175	80.1125	80.14	7732.0
2020-02-19 06:30:00	AAPL	Stock	80.15	80.15	80.0125	80.1475	20000.0
2020-02-19 07:00:00	AAPL	Stock	80.1125	80.1875	80.1	80.1875	79208.0
2020-02-19 07:30:00	AAPL	Stock	80.19	80.32	80.1875	80.32	94544.0
2020-02-19 08:00:00	AAPL	Stock	80.1475	80.3325	80.09	80.1375	408560.0
2020-02-19 08:30:00	AAPL	Stock	80.1375	80.175	80.075	80.105	167436.0
2020-02-19 09:00:00	AAPL	Stock	80.105	80.194	79.75	80.0075	869152.0
2020-02-19 09:30:00	AAPL	Stock	80.0075	80.745	80.0	80.6775	14636508.0
2020-02-19 10:00:00	AAPL	Stock	80.6775	80.8225	80.485	80.7925	6545312.0
2020-02-19 10:30:00	AAPL	Stock	80.7998	80.9062	80.7055	80.8908	5690128.0
2020-02-19 11:00:00	AAPL	Stock	80.8975	81.1425	80.8775	81.0325	5469956.0
2020-02-19 11:30:00	AAPL	Stock	81.03	81.1088	80.9375	80.99	3877104.0
2020-02-19 12:00:00	AAPL	Stock	80.9875	81.075	80.9	80.9855	3307924.0
2020-02-19 12:30:00	AAPL	Stock	80.99	81.14	80.975	81.102	2357016.0
2020-02-19 13:00:00	AAPL	Stock	81.105	81.11	80.9625	81.0572	2130416.0
2020-02-19 13:30:00	AAPL	Stock	81.055	81.055	80.8875	80.9842	2139236.0
2020-02-19 14:00:00	AAPL	Stock	80.9822	81.045	80.9125	80.9838	2282352.0
2020-02-19 14:30:00	AAPL	Stock	80.985	81.075	80.9782	80.998	2152936.0
2020-02-19 15:00:00	AAPL	Stock	81.0	81.0425	80.845	80.9175	3342848.0
2020-02-19 15:30:00	AAPL	Stock	80.92	80.985	80.73	80.905	7728672.0
2020-02-19 16:00:00	AAPL	Stock	80.905	80.965	80.875	80.875	11660676.0
2020-02-19 16:30:00	AAPL	Stock	80.875	80.905	80.815	80.85	100108.0
2020-02-19 17:00:00	AAPL	Stock	80.87	80.8975	80.8275	80.8275	64560.0
2020-02-19 17:30:00	AAPL	Stock	80.85	80.92	80.85	80.9125	29760.0
2020-02-19 18:00:00	AAPL	Stock	80.92	80.9625	80.8775	80.935	26128.0
2020-02-19 18:30:00	AAPL	Stock	80.9225	80.9675	80.905	80.965	20428.0
2020-02-19 19:00:00	AAPL	Stock	80.9825	81.075	80.975	81.04	68704.0
2020-02-19 19:30:00	AAPL	Stock	81.05	81.12	81.025	81.055	48456.0
2020-02-19 04:00:00	MSFT	Stock	186.76	187.43	186.76	187.43	9005.0
2020-02-19 04:30:00	MSFT	Stock	187.5	187.64	187.5	187.64	4110.0
2020-02-19 05:00:00	MSFT	Stock	187.68	187.8	187.65	187.8	12265.0
2020-02-19 05:30:00	MSFT	Stock	187.8	187.8	187.53	187.53	3588.0
2020-02-19 06:00:00	MSFT	Stock	187.55	187.65	187.5	187.65	1006.0
2020-02-19 06:30:00	MSFT	Stock	187.6	187.6	187.39	187.5	2335.0
2020-02-19 07:00:00	MSFT	Stock	187.62	187.67	187.5	187.55	19767.0
2020-02-19 07:30:00	MSFT	Stock	187.56	187.75	187.5	187.75	26189.0
2020-02-19 08:00:00	MSFT	Stock	187.57	187.99	187.5	187.75	85968.0
2020-02-19 08:30:00	MSFT	Stock	187.8	187.96	187.7	187.74	33494.0
2020-02-19 09:00:00	MSFT	Stock	187.84	188.24	186.72	188.05	288989.0
2020-02-19 09:30:00	MSFT	Stock	188.04	188.18	186.47	187.36	3588377.0
2020-02-19 10:00:00	MSFT	Stock	187.35	187.505	186.89	186.975	1572670.0
2020-02-19 10:30:00	MSFT	Stock	186.98	187.08	186.67	187.035	1474554.0
2020-02-19 11:00:00	MSFT	Stock	187.04	187.66	186.94	187.5	1448997.0
2020-02-19 11:30:00	MSFT	Stock	187.508	187.59	187.03	187.252	981597.0
2020-02-19 12:00:00	MSFT	Stock	187.254	187.26	186.955	187.0	766911.0
2020-02-19 12:30:00	MSFT	Stock	187.01	187.44	186.99	187.33	629801.0

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

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