PREVIEW / stock_30min / 2020-04-29

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-04-29.parquet
  size:    1.9 MB
  rows:    97,490
  symbols: 2,408

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-04-29 04:00:00	AAPL	Stock	70.58	70.7	70.5025	70.515	5000.0
2020-04-29 04:30:00	AAPL	Stock	70.6475	70.7	70.6475	70.7	3552.0
2020-04-29 05:00:00	AAPL	Stock	70.63	70.63	70.5475	70.615	5688.0
2020-04-29 05:30:00	AAPL	Stock	70.63	70.63	70.5	70.5	12856.0
2020-04-29 06:00:00	AAPL	Stock	70.375	70.375	70.275	70.29	5400.0
2020-04-29 06:30:00	AAPL	Stock	70.275	70.375	70.275	70.375	15100.0
2020-04-29 07:00:00	AAPL	Stock	70.3275	70.45	70.15	70.25	104560.0
2020-04-29 07:30:00	AAPL	Stock	70.225	70.325	70.125	70.25	61788.0
2020-04-29 08:00:00	AAPL	Stock	70.4488	70.4542	70.125	70.325	151448.0
2020-04-29 08:30:00	AAPL	Stock	70.3475	71.4025	70.3475	71.4025	816652.0
2020-04-29 09:00:00	AAPL	Stock	71.42	71.625	71.125	71.24	1028120.0
2020-04-29 09:30:00	AAPL	Stock	71.1825	72.01	70.9725	71.725	18304936.0
2020-04-29 10:00:00	AAPL	Stock	71.725	72.1375	71.6175	72.0825	10404604.0
2020-04-29 10:30:00	AAPL	Stock	72.0825	72.4175	71.95	71.9562	9557472.0
2020-04-29 11:00:00	AAPL	Stock	71.9562	72.04	71.8125	71.8825	6053896.0
2020-04-29 11:30:00	AAPL	Stock	71.89	71.97	71.6875	71.7192	5131344.0
2020-04-29 12:00:00	AAPL	Stock	71.72	71.82	71.6825	71.7775	3935900.0
2020-04-29 12:30:00	AAPL	Stock	71.7825	71.995	71.7475	71.7975	3961500.0
2020-04-29 13:00:00	AAPL	Stock	71.7975	72.005	71.7625	71.79	4069844.0
2020-04-29 13:30:00	AAPL	Stock	71.7925	71.8282	71.65	71.7755	3915868.0
2020-04-29 14:00:00	AAPL	Stock	71.7825	71.925	71.5825	71.84	5360636.0
2020-04-29 14:30:00	AAPL	Stock	71.8475	72.1575	71.753	72.1225	5284424.0
2020-04-29 15:00:00	AAPL	Stock	72.1125	72.2125	71.9125	72.175	5767956.0
2020-04-29 15:30:00	AAPL	Stock	72.175	72.3325	71.8325	71.9575	10813380.0
2020-04-29 16:00:00	AAPL	Stock	71.8675	72.5	71.75	72.485	9262832.0
2020-04-29 16:30:00	AAPL	Stock	72.4525	72.6875	71.9325	72.62	434736.0
2020-04-29 17:00:00	AAPL	Stock	72.625	72.8725	72.625	72.87	252692.0
2020-04-29 17:30:00	AAPL	Stock	72.8725	73.1225	72.85	72.9475	330084.0
2020-04-29 18:00:00	AAPL	Stock	72.9525	73.0	72.755	72.85	184984.0
2020-04-29 18:30:00	AAPL	Stock	72.875	72.95	72.8625	72.925	49932.0
2020-04-29 19:00:00	AAPL	Stock	72.9	72.95	72.83	72.89	63972.0
2020-04-29 19:30:00	AAPL	Stock	72.92	73.095	72.8875	73.075	157296.0
2020-04-29 04:00:00	MSFT	Stock	173.3	173.35	172.85	173.03	8190.0
2020-04-29 04:30:00	MSFT	Stock	173.2	173.9	173.13	173.88	3589.0
2020-04-29 05:00:00	MSFT	Stock	173.78	173.8	173.38	173.45	3799.0
2020-04-29 05:30:00	MSFT	Stock	173.46	173.52	173.11	173.11	5072.0
2020-04-29 06:00:00	MSFT	Stock	173.11	173.18	172.68	172.68	2682.0
2020-04-29 06:30:00	MSFT	Stock	172.69	173.4	172.66	173.02	9413.0
2020-04-29 07:00:00	MSFT	Stock	173.22	173.24	172.12	172.28	67798.0
2020-04-29 07:30:00	MSFT	Stock	172.35	172.6	171.8	172.35	40304.0
2020-04-29 08:00:00	MSFT	Stock	173.01	173.2	171.8	172.75	106692.0
2020-04-29 08:30:00	MSFT	Stock	172.75	173.8	172.75	173.8	150348.0
2020-04-29 09:00:00	MSFT	Stock	173.8	174.4	173.0	173.22	193429.0
2020-04-29 09:30:00	MSFT	Stock	173.22	174.52	171.88	173.98	5100486.0
2020-04-29 10:00:00	MSFT	Stock	173.97	175.062	173.5	175.035	2983793.0
2020-04-29 10:30:00	MSFT	Stock	175.06	175.18	174.0	174.32	1928445.0
2020-04-29 11:00:00	MSFT	Stock	174.32	175.025	174.1	174.55	1889984.0
2020-04-29 11:30:00	MSFT	Stock	174.55	174.99	174.33	174.86	1475101.0
2020-04-29 12:00:00	MSFT	Stock	174.86	175.89	174.86	175.872	2018522.0
2020-04-29 12:30:00	MSFT	Stock	175.88	176.17	175.71	175.893	2079926.0

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

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