PREVIEW / stock_30min / 2020-12-18

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-12-18.parquet
  size:    2.2 MB
  rows:    110,169
  symbols: 2,693

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-12-18 04:00:00	AAPL	Stock	128.88	129.36	128.59	129.03	15323.0
2020-12-18 04:30:00	AAPL	Stock	128.99	129.07	128.99	129.07	2003.0
2020-12-18 05:00:00	AAPL	Stock	129.1	129.13	128.96	128.96	3506.0
2020-12-18 05:30:00	AAPL	Stock	128.96	128.96	128.7	128.84	11885.0
2020-12-18 06:00:00	AAPL	Stock	128.89	129.2	128.8	128.91	13770.0
2020-12-18 06:30:00	AAPL	Stock	128.92	129.09	128.6	128.84	42676.0
2020-12-18 07:00:00	AAPL	Stock	128.8	129.15	128.72	129.0	131591.0
2020-12-18 07:30:00	AAPL	Stock	129.0	129.15	128.86	128.9	81255.0
2020-12-18 08:00:00	AAPL	Stock	128.93	129.15	128.7	128.94	537484.0
2020-12-18 08:30:00	AAPL	Stock	128.97	129.2	128.55	129.12	200362.0
2020-12-18 09:00:00	AAPL	Stock	129.11	129.35	128.93	129.0	417454.0
2020-12-18 09:30:00	AAPL	Stock	128.93	129.1	127.385	127.61	25751544.0
2020-12-18 10:00:00	AAPL	Stock	127.62	127.815	127.08	127.4	7279721.0
2020-12-18 10:30:00	AAPL	Stock	127.381	127.94	127.37	127.745	4338947.0
2020-12-18 11:00:00	AAPL	Stock	127.745	127.9	127.22	127.44	4675238.0
2020-12-18 11:30:00	AAPL	Stock	127.43	127.68	127.29	127.414	2781337.0
2020-12-18 12:00:00	AAPL	Stock	127.415	127.78	127.3	127.649	3698129.0
2020-12-18 12:30:00	AAPL	Stock	127.645	127.85	127.58	127.695	2836141.0
2020-12-18 13:00:00	AAPL	Stock	127.7	128.0	127.15	127.16	3658910.0
2020-12-18 13:30:00	AAPL	Stock	127.17	127.18	126.625	126.79	5850782.0
2020-12-18 14:00:00	AAPL	Stock	126.79	126.81	126.42	126.748	5172727.0
2020-12-18 14:30:00	AAPL	Stock	126.745	127.99	126.425	126.775	6106893.0
2020-12-18 15:00:00	AAPL	Stock	126.78	126.88	126.12	126.55	7191425.0
2020-12-18 15:30:00	AAPL	Stock	126.55	127.0	126.28	126.65	15925750.0
2020-12-18 16:00:00	AAPL	Stock	126.66	127.06	126.65	126.9	75283482.0
2020-12-18 16:30:00	AAPL	Stock	126.91	127.1	126.89	127.02	230571.0
2020-12-18 17:00:00	AAPL	Stock	127.02	127.39	126.655	127.1	421444.0
2020-12-18 17:30:00	AAPL	Stock	127.13	127.33	126.655	127.18	68319.0
2020-12-18 18:00:00	AAPL	Stock	127.18	127.18	127.01	127.13	34739.0
2020-12-18 18:30:00	AAPL	Stock	127.09	127.16	127.07	127.09	28324.0
2020-12-18 19:00:00	AAPL	Stock	127.1	127.2	127.05	127.18	34794.0
2020-12-18 19:30:00	AAPL	Stock	127.18	127.33	127.17	127.31	85003.0
2020-12-18 04:00:00	MSFT	Stock	219.38	219.4	219.17	219.17	1170.0
2020-12-18 04:30:00	MSFT	Stock	219.05	219.05	219.0	219.0	342.0
2020-12-18 05:00:00	MSFT	Stock	218.85	219.13	218.85	219.13	1705.0
2020-12-18 05:30:00	MSFT	Stock	218.91	218.91	218.03	218.48	7254.0
2020-12-18 06:00:00	MSFT	Stock	218.5	218.84	218.41	218.5	14539.0
2020-12-18 06:30:00	MSFT	Stock	218.5	218.69	218.33	218.5	16528.0
2020-12-18 07:00:00	MSFT	Stock	218.37	218.78	218.36	218.6	23686.0
2020-12-18 07:30:00	MSFT	Stock	218.6	218.65	218.0	218.06	47119.0
2020-12-18 08:00:00	MSFT	Stock	218.59	219.42	218.0	218.14	154373.0
2020-12-18 08:30:00	MSFT	Stock	218.15	218.4	218.08	218.16	81585.0
2020-12-18 09:00:00	MSFT	Stock	218.16	219.21	218.15	218.69	156605.0
2020-12-18 09:30:00	MSFT	Stock	218.69	219.69	217.98	218.195	8318624.0
2020-12-18 10:00:00	MSFT	Stock	218.17	218.17	216.97	217.49	2327210.0
2020-12-18 10:30:00	MSFT	Stock	217.498	218.275	217.42	218.145	1347638.0
2020-12-18 11:00:00	MSFT	Stock	218.17	218.35	217.45	218.24	1460160.0
2020-12-18 11:30:00	MSFT	Stock	218.24	218.75	218.12	218.13	1155351.0
2020-12-18 12:00:00	MSFT	Stock	218.14	218.45	217.89	218.445	846078.0
2020-12-18 12:30:00	MSFT	Stock	218.446	218.56	217.953	218.035	874647.0

> showing 50 of 110,169 rows — these rows as CSV

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