PREVIEW / stock_30min / 2020-09-16

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-09-16.parquet
  size:    1.9 MB
  rows:    96,660
  symbols: 2,484

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-09-16 04:00:00	AAPL	Stock	115.51	116.3	115.25	116.11	44757.0
2020-09-16 04:30:00	AAPL	Stock	116.11	116.2	115.97	116.0	40058.0
2020-09-16 05:00:00	AAPL	Stock	116.08	116.5	116.08	116.4	22284.0
2020-09-16 05:30:00	AAPL	Stock	116.4	116.5	116.1	116.18	18553.0
2020-09-16 06:00:00	AAPL	Stock	116.18	116.24	115.6	115.98	22205.0
2020-09-16 06:30:00	AAPL	Stock	115.98	116.64	115.98	116.39	35673.0
2020-09-16 07:00:00	AAPL	Stock	116.33	116.35	115.03	115.15	401855.0
2020-09-16 07:30:00	AAPL	Stock	115.14	115.6	114.88	115.6	230052.0
2020-09-16 08:00:00	AAPL	Stock	115.61	116.21	114.88	115.45	577505.0
2020-09-16 08:30:00	AAPL	Stock	115.42	115.42	114.92	115.12	381675.0
2020-09-16 09:00:00	AAPL	Stock	115.11	115.25	114.58	115.18	853328.0
2020-09-16 09:30:00	AAPL	Stock	115.17	116.0	114.18	114.86	15495412.0
2020-09-16 10:00:00	AAPL	Stock	114.87	115.05	114.04	114.39	9035602.0
2020-09-16 10:30:00	AAPL	Stock	114.39	114.58	113.35	113.87	10973885.0
2020-09-16 11:00:00	AAPL	Stock	113.87	114.39	113.71	114.106	6955184.0
2020-09-16 11:30:00	AAPL	Stock	114.11	114.32	113.6	113.676	6043729.0
2020-09-16 12:00:00	AAPL	Stock	113.67	113.85	113.36	113.694	6010572.0
2020-09-16 12:30:00	AAPL	Stock	113.7	113.73	113.14	113.345	5972625.0
2020-09-16 13:00:00	AAPL	Stock	113.346	113.57	112.82	113.105	7156228.0
2020-09-16 13:30:00	AAPL	Stock	113.11	113.51	112.75	113.41	6950636.0
2020-09-16 14:00:00	AAPL	Stock	113.463	114.6	113.02	114.13	10983402.0
2020-09-16 14:30:00	AAPL	Stock	114.15	114.42	113.04	113.295	8903802.0
2020-09-16 15:00:00	AAPL	Stock	113.295	113.46	112.5	112.63	10557435.0
2020-09-16 15:30:00	AAPL	Stock	112.625	113.137	112.04	112.13	15116933.0
2020-09-16 16:00:00	AAPL	Stock	112.11	114.403	112.0	112.4	8983174.0
2020-09-16 16:30:00	AAPL	Stock	112.4	112.72	112.13	112.54	229127.0
2020-09-16 17:00:00	AAPL	Stock	112.54	112.65	112.45	112.6	90857.0
2020-09-16 17:30:00	AAPL	Stock	112.6	112.7	112.56	112.7	84312.0
2020-09-16 18:00:00	AAPL	Stock	112.71	112.8	112.5	112.76	109373.0
2020-09-16 18:30:00	AAPL	Stock	112.74	112.78	112.7	112.71	57013.0
2020-09-16 19:00:00	AAPL	Stock	112.73	112.75	112.6	112.7	58745.0
2020-09-16 19:30:00	AAPL	Stock	112.67	112.82	112.56	112.8	102956.0
2020-09-16 04:00:00	MSFT	Stock	210.5	211.26	210.5	211.1	3282.0
2020-09-16 04:30:00	MSFT	Stock	211.08	211.26	211.01	211.01	2587.0
2020-09-16 05:00:00	MSFT	Stock	211.24	211.28	211.24	211.28	1324.0
2020-09-16 05:30:00	MSFT	Stock	211.2	211.45	211.05	211.05	2350.0
2020-09-16 06:00:00	MSFT	Stock	211.08	211.08	210.75	210.75	1004.0
2020-09-16 06:30:00	MSFT	Stock	210.6	211.2	210.6	211.2	3043.0
2020-09-16 07:00:00	MSFT	Stock	211.28	211.4	210.22	210.5	40489.0
2020-09-16 07:30:00	MSFT	Stock	210.4	210.93	210.22	210.93	37606.0
2020-09-16 08:00:00	MSFT	Stock	211.1	211.146	210.33	210.6	33417.0
2020-09-16 08:30:00	MSFT	Stock	210.57	211.0	210.1	210.75	40231.0
2020-09-16 09:00:00	MSFT	Stock	210.82	210.82	210.1	210.46	34947.0
2020-09-16 09:30:00	MSFT	Stock	210.61	210.65	207.81	208.74	2633569.0
2020-09-16 10:00:00	MSFT	Stock	208.75	208.9	207.3	207.828	1360449.0
2020-09-16 10:30:00	MSFT	Stock	207.825	207.97	206.78	207.69	1244994.0
2020-09-16 11:00:00	MSFT	Stock	207.68	209.21	207.51	208.56	1236112.0
2020-09-16 11:30:00	MSFT	Stock	208.59	208.92	208.22	208.22	645566.0
2020-09-16 12:00:00	MSFT	Stock	208.23	208.79	207.78	208.05	677488.0
2020-09-16 12:30:00	MSFT	Stock	208.04	208.11	207.39	207.79	522479.0

> showing 50 of 96,660 rows — these rows as CSV

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