PREVIEW / stock_30min / 2021-08-02

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-08-02.parquet
  size:    2.2 MB
  rows:    109,603
  symbols: 2,828

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
2021-08-02 04:00:00	AAPL	Stock	146.46	146.75	146.15	146.6	16842.0
2021-08-02 04:30:00	AAPL	Stock	146.7	146.75	146.6	146.67	4492.0
2021-08-02 05:00:00	AAPL	Stock	146.62	146.71	146.6	146.62	16684.0
2021-08-02 05:30:00	AAPL	Stock	146.64	146.68	146.6	146.65	2338.0
2021-08-02 06:00:00	AAPL	Stock	146.6	146.72	146.51	146.6	47747.0
2021-08-02 06:30:00	AAPL	Stock	146.59	146.59	146.5	146.5	26836.0
2021-08-02 07:00:00	AAPL	Stock	146.45	146.88	146.27	146.65	97127.0
2021-08-02 07:30:00	AAPL	Stock	146.67	146.99	146.67	146.8	53130.0
2021-08-02 08:00:00	AAPL	Stock	146.44	146.95	146.27	146.54	175386.0
2021-08-02 08:30:00	AAPL	Stock	146.52	146.73	146.52	146.575	88690.0
2021-08-02 09:00:00	AAPL	Stock	146.58	146.78	146.25	146.4	202029.0
2021-08-02 09:30:00	AAPL	Stock	146.4	146.95	145.25	145.95	10463571.0
2021-08-02 10:00:00	AAPL	Stock	145.93	146.25	145.6	145.9	5365695.0
2021-08-02 10:30:00	AAPL	Stock	145.9	146.08	145.41	146.0201	4117331.0
2021-08-02 11:00:00	AAPL	Stock	146.03	146.5499	145.71	146.53	3759660.0
2021-08-02 11:30:00	AAPL	Stock	146.5382	146.55	145.99	146.0244	2752898.0
2021-08-02 12:00:00	AAPL	Stock	146.0257	146.035	145.5589	145.63	3149797.0
2021-08-02 12:30:00	AAPL	Stock	145.63	145.8693	145.5619	145.75	2183235.0
2021-08-02 13:00:00	AAPL	Stock	145.75	146.2154	145.75	146.045	2550208.0
2021-08-02 13:30:00	AAPL	Stock	146.0497	146.13	145.74	146.045	2093578.0
2021-08-02 14:00:00	AAPL	Stock	146.04	146.18	145.93	145.97	1582463.0
2021-08-02 14:30:00	AAPL	Stock	145.97	146.05	145.86	145.935	1663556.0
2021-08-02 15:00:00	AAPL	Stock	145.935	146.01	145.61	145.615	2533480.0
2021-08-02 15:30:00	AAPL	Stock	145.61	145.76	145.37	145.52	5108430.0
2021-08-02 16:00:00	AAPL	Stock	145.52	145.52	145.37	145.41	3710453.0
2021-08-02 16:30:00	AAPL	Stock	145.4	145.4	145.26	145.34	49095.0
2021-08-02 17:00:00	AAPL	Stock	145.31	145.52	145.27	145.36	56506.0
2021-08-02 17:30:00	AAPL	Stock	145.38	145.38	145.28	145.3	9077.0
2021-08-02 18:00:00	AAPL	Stock	145.31	145.39	145.31	145.3501	11467.0
2021-08-02 18:30:00	AAPL	Stock	145.35	145.41	145.3	145.4	16077.0
2021-08-02 19:00:00	AAPL	Stock	145.35	145.39	145.2901	145.33	15787.0
2021-08-02 19:30:00	AAPL	Stock	145.33	145.3899	145.25	145.25	24553.0
2021-08-02 04:00:00	MSFT	Stock	286.7	286.98	286.5	286.53	1227.0
2021-08-02 05:00:00	MSFT	Stock	286.84	286.85	286.5	286.5	1846.0
2021-08-02 05:30:00	MSFT	Stock	286.7	286.7	286.7	286.7	468.0
2021-08-02 06:00:00	MSFT	Stock	286.55	286.55	286.3	286.3	1449.0
2021-08-02 06:30:00	MSFT	Stock	286.37	286.37	286.28	286.28	243.0
2021-08-02 07:00:00	MSFT	Stock	285.75	286.0	285.75	285.77	5940.0
2021-08-02 07:30:00	MSFT	Stock	285.77	286.14	285.77	286.05	6911.0
2021-08-02 08:00:00	MSFT	Stock	286.0	286.12	285.51	285.75	12716.0
2021-08-02 08:30:00	MSFT	Stock	285.9	285.9	285.75	285.83	5651.0
2021-08-02 09:00:00	MSFT	Stock	285.83	286.5	285.52	286.37	29558.0
2021-08-02 09:30:00	MSFT	Stock	286.3	286.775	283.74	284.795	2134963.0
2021-08-02 10:00:00	MSFT	Stock	284.79	285.79	284.095	285.52	1022632.0
2021-08-02 10:30:00	MSFT	Stock	285.54	285.6198	284.78	285.149	711005.0
2021-08-02 11:00:00	MSFT	Stock	285.16	286.19	284.74	286.18	885018.0
2021-08-02 11:30:00	MSFT	Stock	286.17	286.43	285.67	285.73	570477.0
2021-08-02 12:00:00	MSFT	Stock	285.73	285.78	285.14	285.67	785868.0
2021-08-02 12:30:00	MSFT	Stock	285.7	285.95	285.32	285.52	385907.0
2021-08-02 13:00:00	MSFT	Stock	285.52	286.13	285.45	286.04	481354.0

> showing 50 of 109,603 rows — these rows as CSV

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