PREVIEW / stock_30min / 2021-04-27

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-04-27.parquet
  size:    2.2 MB
  rows:    110,830
  symbols: 2,964

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-04-27 04:00:00	AAPL	Stock	134.89	135.0	134.69	134.77	3381.0
2021-04-27 04:30:00	AAPL	Stock	134.79	134.84	134.79	134.84	1325.0
2021-04-27 05:00:00	AAPL	Stock	134.86	135.1	134.86	135.08	5747.0
2021-04-27 05:30:00	AAPL	Stock	135.07	135.07	134.65	134.74	16630.0
2021-04-27 06:00:00	AAPL	Stock	134.76	134.9	134.74	134.9	4327.0
2021-04-27 06:30:00	AAPL	Stock	134.92	135.0	134.85	135.0	5153.0
2021-04-27 07:00:00	AAPL	Stock	134.92	135.25	134.9	135.23	99812.0
2021-04-27 07:30:00	AAPL	Stock	135.23	135.47	135.22	135.41	120828.0
2021-04-27 08:00:00	AAPL	Stock	135.2199	135.73	134.945	135.58	329205.0
2021-04-27 08:30:00	AAPL	Stock	135.54	135.74	135.5	135.59	132024.0
2021-04-27 09:00:00	AAPL	Stock	135.59	135.6	135.01	135.04	252457.0
2021-04-27 09:30:00	AAPL	Stock	135.06	135.41	134.27	134.48	9025320.0
2021-04-27 10:00:00	AAPL	Stock	134.47	134.9	134.16	134.8831	5808915.0
2021-04-27 10:30:00	AAPL	Stock	134.88	134.935	134.11	134.375	5638626.0
2021-04-27 11:00:00	AAPL	Stock	134.375	134.67	134.31	134.4627	3248631.0
2021-04-27 11:30:00	AAPL	Stock	134.47	134.52	134.28	134.4114	2499342.0
2021-04-27 12:00:00	AAPL	Stock	134.415	134.75	134.4101	134.71	2722098.0
2021-04-27 12:30:00	AAPL	Stock	134.705	135.0799	134.62	134.6539	3804131.0
2021-04-27 13:00:00	AAPL	Stock	134.655	134.76	134.59	134.625	2009544.0
2021-04-27 13:30:00	AAPL	Stock	134.62	134.6899	134.45	134.5149	1941645.0
2021-04-27 14:00:00	AAPL	Stock	134.515	134.83	134.35	134.83	2885761.0
2021-04-27 14:30:00	AAPL	Stock	134.8296	134.85	134.4	134.5031	3130696.0
2021-04-27 15:00:00	AAPL	Stock	134.5	134.8	134.43	134.66	3239289.0
2021-04-27 15:30:00	AAPL	Stock	134.66	134.77	134.2	134.39	6755700.0
2021-04-27 16:00:00	AAPL	Stock	134.39	134.59	134.2	134.23	4299163.0
2021-04-27 16:30:00	AAPL	Stock	134.23	134.7931	134.23	134.47	170524.0
2021-04-27 17:00:00	AAPL	Stock	134.4701	134.5	134.37	134.44	307224.0
2021-04-27 17:30:00	AAPL	Stock	134.45	134.55	134.44	134.53	58233.0
2021-04-27 18:00:00	AAPL	Stock	134.54	134.78	134.5	134.71	103328.0
2021-04-27 18:30:00	AAPL	Stock	134.73	134.87	134.73	134.86	90004.0
2021-04-27 19:00:00	AAPL	Stock	134.84	134.9	134.81	134.89	51799.0
2021-04-27 19:30:00	AAPL	Stock	134.89	134.95	134.79	134.79	61720.0
2021-04-27 04:00:00	MSFT	Stock	262.39	262.44	262.0	262.23	974.0
2021-04-27 04:30:00	MSFT	Stock	262.4	262.4	262.4	262.4	725.0
2021-04-27 05:00:00	MSFT	Stock	262.4	262.55	262.4	262.55	3307.0
2021-04-27 05:30:00	MSFT	Stock	262.26	262.26	261.55	261.79	1260.0
2021-04-27 06:00:00	MSFT	Stock	261.72	261.72	261.72	261.72	100.0
2021-04-27 06:30:00	MSFT	Stock	261.75	261.99	261.75	261.99	1585.0
2021-04-27 07:00:00	MSFT	Stock	262.17	262.3	261.99	262.3	13373.0
2021-04-27 07:30:00	MSFT	Stock	262.2	262.5	262.04	262.27	17437.0
2021-04-27 08:00:00	MSFT	Stock	262.1934	262.41	262.12	262.3	25075.0
2021-04-27 08:30:00	MSFT	Stock	262.31	262.31	262.01	262.05	10285.0
2021-04-27 09:00:00	MSFT	Stock	262.1	262.2	261.5	261.5	39827.0
2021-04-27 09:30:00	MSFT	Stock	261.51	261.88	260.15	260.73	2440598.0
2021-04-27 10:00:00	MSFT	Stock	260.73	261.62	260.12	261.6	1257326.0
2021-04-27 10:30:00	MSFT	Stock	261.58	261.7016	260.56	260.62	1189240.0
2021-04-27 11:00:00	MSFT	Stock	260.625	261.04	260.4301	260.87	935642.0
2021-04-27 11:30:00	MSFT	Stock	260.88	261.185	260.7	260.98	575033.0
2021-04-27 12:00:00	MSFT	Stock	260.97	261.47	260.6	261.12	974066.0
2021-04-27 12:30:00	MSFT	Stock	261.123	261.63	261.11	261.14	885840.0

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

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