PREVIEW / stock_30min / 2021-04-20

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-04-20.parquet
  size:    2.2 MB
  rows:    110,490
  symbols: 2,977

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-20 04:00:00	AAPL	Stock	135.0	135.1	134.38	135.03	19579.0
2021-04-20 04:30:00	AAPL	Stock	134.84	135.18	134.84	135.05	8951.0
2021-04-20 05:00:00	AAPL	Stock	135.01	135.09	134.85	134.85	6189.0
2021-04-20 05:30:00	AAPL	Stock	134.78	134.79	134.3	134.4	15779.0
2021-04-20 06:00:00	AAPL	Stock	134.41	134.41	134.22	134.4	5026.0
2021-04-20 06:30:00	AAPL	Stock	134.4	134.6	134.12	134.42	18779.0
2021-04-20 07:00:00	AAPL	Stock	134.43	134.55	134.33	134.42	64041.0
2021-04-20 07:30:00	AAPL	Stock	134.41	134.75	134.39	134.65	44732.0
2021-04-20 08:00:00	AAPL	Stock	134.47	134.86	134.2522	134.66	208294.0
2021-04-20 08:30:00	AAPL	Stock	134.66	134.84	134.5	134.65	126523.0
2021-04-20 09:00:00	AAPL	Stock	134.66	135.0596	134.64	135.03	164308.0
2021-04-20 09:30:00	AAPL	Stock	135.02	135.53	134.44	135.21	11077585.0
2021-04-20 10:00:00	AAPL	Stock	135.215	135.44	134.22	134.4	6697331.0
2021-04-20 10:30:00	AAPL	Stock	134.39	134.46	133.49	133.68	6607368.0
2021-04-20 11:00:00	AAPL	Stock	133.675	133.8	132.51	132.81	6689720.0
2021-04-20 11:30:00	AAPL	Stock	132.81	133.35	132.28	133.155	6353904.0
2021-04-20 12:00:00	AAPL	Stock	133.16	133.74	133.11	133.62	3761405.0
2021-04-20 12:30:00	AAPL	Stock	133.6201	133.669	133.2	133.5597	3087323.0
2021-04-20 13:00:00	AAPL	Stock	133.55	133.82	132.3599	132.38	6093675.0
2021-04-20 13:30:00	AAPL	Stock	132.3877	133.23	132.37	133.1617	4399820.0
2021-04-20 14:00:00	AAPL	Stock	133.16	133.1699	132.485	132.5102	4623360.0
2021-04-20 14:30:00	AAPL	Stock	132.51	132.57	131.81	131.985	4944722.0
2021-04-20 15:00:00	AAPL	Stock	131.9899	132.68	131.9899	132.64	4601835.0
2021-04-20 15:30:00	AAPL	Stock	132.65	133.2	132.51	133.12	7901034.0
2021-04-20 16:00:00	AAPL	Stock	133.11	133.16	132.52	132.65	5230062.0
2021-04-20 16:30:00	AAPL	Stock	132.64	132.7	132.55	132.61	45318.0
2021-04-20 17:00:00	AAPL	Stock	132.6	132.65	132.51	132.63	43492.0
2021-04-20 17:30:00	AAPL	Stock	132.6	132.71	132.6	132.63	41715.0
2021-04-20 18:00:00	AAPL	Stock	132.62	132.75	132.53	132.7	34509.0
2021-04-20 18:30:00	AAPL	Stock	132.7	132.7	132.48	132.55	24508.0
2021-04-20 19:00:00	AAPL	Stock	132.53	132.56	132.3	132.4	32212.0
2021-04-20 19:30:00	AAPL	Stock	132.4	132.54	132.2	132.3	60394.0
2021-04-20 04:00:00	MSFT	Stock	258.83	258.83	258.83	258.83	175.0
2021-04-20 04:30:00	MSFT	Stock	259.4	259.4	259.4	259.4	103.0
2021-04-20 05:00:00	MSFT	Stock	259.03	259.03	258.92	258.92	2689.0
2021-04-20 05:30:00	MSFT	Stock	258.5	258.5	258.02	258.02	1472.0
2021-04-20 06:00:00	MSFT	Stock	257.83	257.83	257.83	257.83	100.0
2021-04-20 06:30:00	MSFT	Stock	257.97	257.98	257.55	257.98	1400.0
2021-04-20 07:00:00	MSFT	Stock	257.76	258.01	257.72	257.81	7353.0
2021-04-20 07:30:00	MSFT	Stock	257.78	258.17	257.78	258.11	4038.0
2021-04-20 08:00:00	MSFT	Stock	257.7101	258.38	257.71	258.17	13470.0
2021-04-20 08:30:00	MSFT	Stock	258.2	258.37	258.05	258.05	12770.0
2021-04-20 09:00:00	MSFT	Stock	258.07	258.75	257.75	257.98	17499.0
2021-04-20 09:30:00	MSFT	Stock	257.98	260.2	257.82	259.685	1467155.0
2021-04-20 10:00:00	MSFT	Stock	259.67	259.87	258.9632	259.52	902261.0
2021-04-20 10:30:00	MSFT	Stock	259.47	259.73	258.245	258.25	1130014.0
2021-04-20 11:00:00	MSFT	Stock	258.255	258.4	257.16	257.48	1206831.0
2021-04-20 11:30:00	MSFT	Stock	257.48	257.77	256.84	257.38	1037871.0
2021-04-20 12:00:00	MSFT	Stock	257.41	258.79	257.24	258.62	923387.0
2021-04-20 12:30:00	MSFT	Stock	258.63	258.705	257.67	257.91	673605.0

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

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