PREVIEW / stock_30min / 2019-10-15

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-10-15.parquet
  size:    1.7 MB
  rows:    82,948
  symbols: 2,500

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
2019-10-15 04:00:00	AAPL	Stock	59.3125	59.3375	59.3125	59.3125	5920.0
2019-10-15 04:30:00	AAPL	Stock	59.335	59.3525	59.2625	59.2625	12844.0
2019-10-15 05:00:00	AAPL	Stock	59.2725	59.2725	59.2725	59.2725	400.0
2019-10-15 05:30:00	AAPL	Stock	59.25	59.2525	59.25	59.2525	2728.0
2019-10-15 06:00:00	AAPL	Stock	59.25	59.255	59.05	59.1275	32504.0
2019-10-15 06:30:00	AAPL	Stock	59.1675	59.1675	59.1425	59.1425	800.0
2019-10-15 07:00:00	AAPL	Stock	59.2	59.275	59.15	59.2075	98024.0
2019-10-15 07:30:00	AAPL	Stock	59.21	59.2375	59.1275	59.18	85720.0
2019-10-15 08:00:00	AAPL	Stock	59.2575	59.2575	59.13	59.1675	143372.0
2019-10-15 08:30:00	AAPL	Stock	59.17	59.1875	59.08	59.11	95704.0
2019-10-15 09:00:00	AAPL	Stock	59.11	59.1875	59.0825	59.0825	181208.0
2019-10-15 09:30:00	AAPL	Stock	59.0975	59.3075	59.0125	59.19	9667764.0
2019-10-15 10:00:00	AAPL	Stock	59.1925	59.2925	59.0925	59.2225	5904160.0
2019-10-15 10:30:00	AAPL	Stock	59.2325	59.4125	59.2	59.3625	5433728.0
2019-10-15 11:00:00	AAPL	Stock	59.365	59.365	58.9625	59.0325	7661420.0
2019-10-15 11:30:00	AAPL	Stock	59.0395	59.0525	58.72	58.9238	7308696.0
2019-10-15 12:00:00	AAPL	Stock	58.9275	59.05	58.8875	58.9825	3729184.0
2019-10-15 12:30:00	AAPL	Stock	58.98	59.055	58.935	59.0075	2472808.0
2019-10-15 13:00:00	AAPL	Stock	59.01	59.025	58.88	58.9025	2492304.0
2019-10-15 13:30:00	AAPL	Stock	58.9035	59.0025	58.885	58.9515	2525744.0
2019-10-15 14:00:00	AAPL	Stock	58.955	58.9712	58.9175	58.948	2208104.0
2019-10-15 14:30:00	AAPL	Stock	58.9475	59.0425	58.94	58.975	2806848.0
2019-10-15 15:00:00	AAPL	Stock	58.9725	59.015	58.9275	58.9898	2663320.0
2019-10-15 15:30:00	AAPL	Stock	58.9925	58.9975	58.755	58.83	8029772.0
2019-10-15 16:00:00	AAPL	Stock	58.83	58.9	58.83	58.8625	10882396.0
2019-10-15 16:30:00	AAPL	Stock	58.8625	58.8678	58.83	58.865	204748.0
2019-10-15 17:00:00	AAPL	Stock	58.8875	59.574	58.875	58.8875	26916.0
2019-10-15 17:30:00	AAPL	Stock	58.8925	59.574	58.8925	58.9	45560.0
2019-10-15 18:00:00	AAPL	Stock	58.9	58.91	58.8625	58.875	20180.0
2019-10-15 18:30:00	AAPL	Stock	58.875	58.8975	58.8625	58.8625	18484.0
2019-10-15 19:00:00	AAPL	Stock	58.8575	58.8575	58.735	58.7575	57892.0
2019-10-15 19:30:00	AAPL	Stock	58.7625	58.785	58.75	58.75	74824.0
2019-10-15 04:30:00	MSFT	Stock	140.24	140.25	140.24	140.25	700.0
2019-10-15 05:30:00	MSFT	Stock	140.29	140.3	140.29	140.3	1041.0
2019-10-15 06:00:00	MSFT	Stock	140.29	140.29	140.02	140.02	1041.0
2019-10-15 07:00:00	MSFT	Stock	140.15	140.15	139.85	139.93	8403.0
2019-10-15 07:30:00	MSFT	Stock	139.96	140.2	139.88	140.2	2259.0
2019-10-15 08:00:00	MSFT	Stock	139.9	140.02	139.85	139.94	8018.0
2019-10-15 08:30:00	MSFT	Stock	139.99	140.05	139.93	140.05	2750.0
2019-10-15 09:00:00	MSFT	Stock	140.1	140.17	140.05	140.06	18952.0
2019-10-15 09:30:00	MSFT	Stock	140.06	140.65	139.81	140.46	1795417.0
2019-10-15 10:00:00	MSFT	Stock	140.465	141.35	140.465	141.31	1812923.0
2019-10-15 10:30:00	MSFT	Stock	141.31	141.79	141.23	141.61	1957610.0
2019-10-15 11:00:00	MSFT	Stock	141.61	141.74	141.16	141.5	1234863.0
2019-10-15 11:30:00	MSFT	Stock	141.51	141.54	141.2	141.415	845871.0
2019-10-15 12:00:00	MSFT	Stock	141.41	141.63	141.38	141.44	950288.0
2019-10-15 12:30:00	MSFT	Stock	141.445	141.53	141.333	141.47	499237.0
2019-10-15 13:00:00	MSFT	Stock	141.48	141.63	141.454	141.5	820373.0
2019-10-15 13:30:00	MSFT	Stock	141.5	141.67	141.5	141.61	665186.0
2019-10-15 14:00:00	MSFT	Stock	141.61	141.65	141.5	141.6	636911.0

> showing 50 of 82,948 rows — these rows as CSV

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