PREVIEW / stock_30min / 2020-01-17

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-01-17.parquet
  size:    1.8 MB
  rows:    86,657
  symbols: 2,468

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-01-17 04:00:00	AAPL	Stock	79.01	79.26	79.01	79.26	18148.0
2020-01-17 04:30:00	AAPL	Stock	79.2625	79.3	79.21	79.2475	18972.0
2020-01-17 05:00:00	AAPL	Stock	79.2825	79.3375	79.265	79.325	24356.0
2020-01-17 05:30:00	AAPL	Stock	79.3225	79.325	79.255	79.255	20464.0
2020-01-17 06:00:00	AAPL	Stock	79.2525	79.27	79.25	79.25	7424.0
2020-01-17 06:30:00	AAPL	Stock	79.2525	79.3	79.2425	79.2875	31220.0
2020-01-17 07:00:00	AAPL	Stock	79.255	79.31	79.1525	79.2075	198684.0
2020-01-17 07:30:00	AAPL	Stock	79.2075	79.2125	79.0025	79.155	152056.0
2020-01-17 08:00:00	AAPL	Stock	79.275	79.295	78.9925	79.0625	480912.0
2020-01-17 08:30:00	AAPL	Stock	79.0625	79.2625	79.0625	79.1825	604692.0
2020-01-17 09:00:00	AAPL	Stock	79.175	79.225	78.81	79.07	1001860.0
2020-01-17 09:30:00	AAPL	Stock	79.05	79.2625	78.8925	79.2338	22520604.0
2020-01-17 10:00:00	AAPL	Stock	79.2225	79.3125	78.9775	79.16	9187976.0
2020-01-17 10:30:00	AAPL	Stock	79.16	79.2	79.005	79.07	5823364.0
2020-01-17 11:00:00	AAPL	Stock	79.075	79.1	78.75	78.9775	7056132.0
2020-01-17 11:30:00	AAPL	Stock	78.9785	79.0975	78.925	79.09	3832640.0
2020-01-17 12:00:00	AAPL	Stock	79.0912	79.2325	79.065	79.105	5272956.0
2020-01-17 12:30:00	AAPL	Stock	79.106	79.195	78.9375	78.955	3695024.0
2020-01-17 13:00:00	AAPL	Stock	78.955	79.1202	78.8475	79.1	4570156.0
2020-01-17 13:30:00	AAPL	Stock	79.095	79.2075	79.055	79.1925	3392036.0
2020-01-17 14:00:00	AAPL	Stock	79.1938	79.25	79.1275	79.2025	4339924.0
2020-01-17 14:30:00	AAPL	Stock	79.205	79.2675	79.105	79.2675	4320540.0
2020-01-17 15:00:00	AAPL	Stock	79.2675	79.325	79.155	79.3067	7026584.0
2020-01-17 15:30:00	AAPL	Stock	79.3075	79.685	79.2975	79.6675	15391492.0
2020-01-17 16:00:00	AAPL	Stock	79.6675	79.695	79.625	79.6375	14053796.0
2020-01-17 16:30:00	AAPL	Stock	79.6375	79.6825	79.6025	79.6625	210656.0
2020-01-17 17:00:00	AAPL	Stock	79.64	79.68	79.6275	79.6575	66360.0
2020-01-17 17:30:00	AAPL	Stock	79.6625	79.6825	79.645	79.66	31344.0
2020-01-17 18:00:00	AAPL	Stock	79.6625	79.68	79.6575	79.6725	31116.0
2020-01-17 18:30:00	AAPL	Stock	79.6625	79.675	79.6525	79.6675	29124.0
2020-01-17 19:00:00	AAPL	Stock	79.675	79.675	79.6525	79.6575	30528.0
2020-01-17 19:30:00	AAPL	Stock	79.6575	79.6825	79.65	79.6625	50076.0
2020-01-17 04:00:00	MSFT	Stock	167.05	167.15	167.05	167.05	4089.0
2020-01-17 04:30:00	MSFT	Stock	166.97	167.05	166.97	167.0	4686.0
2020-01-17 05:00:00	MSFT	Stock	167.0	167.31	167.0	167.25	2618.0
2020-01-17 05:30:00	MSFT	Stock	167.2	167.4	167.2	167.4	3403.0
2020-01-17 06:00:00	MSFT	Stock	167.3	167.3	167.1	167.2	4314.0
2020-01-17 06:30:00	MSFT	Stock	167.18	167.29	167.1	167.2	2402.0
2020-01-17 07:00:00	MSFT	Stock	167.3	167.32	167.05	167.13	39092.0
2020-01-17 07:30:00	MSFT	Stock	167.14	167.19	167.03	167.09	6267.0
2020-01-17 08:00:00	MSFT	Stock	167.2	167.32	167.02	167.3	43947.0
2020-01-17 08:30:00	MSFT	Stock	167.27	167.49	167.25	167.372	33288.0
2020-01-17 09:00:00	MSFT	Stock	167.376	167.66	166.17	167.39	412445.0
2020-01-17 09:30:00	MSFT	Stock	167.42	167.468	165.77	166.57	7029011.0
2020-01-17 10:00:00	MSFT	Stock	166.56	166.58	165.81	166.365	1621397.0
2020-01-17 10:30:00	MSFT	Stock	166.37	166.45	166.0	166.027	1256107.0
2020-01-17 11:00:00	MSFT	Stock	166.025	166.13	165.46	165.675	1195675.0
2020-01-17 11:30:00	MSFT	Stock	165.68	165.768	165.43	165.7	855733.0
2020-01-17 12:00:00	MSFT	Stock	165.704	166.17	165.53	166.14	972111.0
2020-01-17 12:30:00	MSFT	Stock	166.135	166.3	165.98	166.03	674580.0

> showing 50 of 86,657 rows — these rows as CSV

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