PREVIEW / stock_30min / 2020-08-13

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-08-13.parquet
  size:    1.9 MB
  rows:    96,412
  symbols: 2,429

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-08-13 04:00:00	AAPL	Stock	113.1225	113.1225	112.7125	112.7125	6364.0
2020-08-13 04:30:00	AAPL	Stock	112.675	112.925	112.675	112.925	3772.0
2020-08-13 05:00:00	AAPL	Stock	112.9175	112.9175	112.8725	112.875	2872.0
2020-08-13 05:30:00	AAPL	Stock	112.875	112.875	112.875	112.875	5176.0
2020-08-13 06:00:00	AAPL	Stock	112.915	113.6925	112.875	113.6225	64664.0
2020-08-13 06:30:00	AAPL	Stock	113.5425	113.6025	113.47	113.495	18140.0
2020-08-13 07:00:00	AAPL	Stock	113.505	113.75	113.2575	113.6275	333644.0
2020-08-13 07:30:00	AAPL	Stock	113.6375	113.7175	113.425	113.6875	102912.0
2020-08-13 08:00:00	AAPL	Stock	113.625	113.9125	113.2575	113.8115	727944.0
2020-08-13 08:30:00	AAPL	Stock	113.8725	114.4825	113.825	114.2975	1186040.0
2020-08-13 09:00:00	AAPL	Stock	114.2625	114.545	114.1625	114.44	737400.0
2020-08-13 09:30:00	AAPL	Stock	114.4425	115.12	114.01	114.48	25337576.0
2020-08-13 10:00:00	AAPL	Stock	114.49	114.6675	113.9275	114.6112	11380344.0
2020-08-13 10:30:00	AAPL	Stock	114.615	115.3125	114.5525	115.057	14790392.0
2020-08-13 11:00:00	AAPL	Stock	115.0625	115.5825	115.0475	115.3082	11399668.0
2020-08-13 11:30:00	AAPL	Stock	115.31	115.375	114.89	115.2812	8255508.0
2020-08-13 12:00:00	AAPL	Stock	115.2875	115.665	115.2725	115.5418	9005076.0
2020-08-13 12:30:00	AAPL	Stock	115.545	115.9525	115.52	115.94	8801172.0
2020-08-13 13:00:00	AAPL	Stock	115.945	116.0425	115.0	115.2988	9791236.0
2020-08-13 13:30:00	AAPL	Stock	115.305	115.6395	114.9125	115.3638	9904440.0
2020-08-13 14:00:00	AAPL	Stock	115.3638	115.4245	114.585	114.9875	10376940.0
2020-08-13 14:30:00	AAPL	Stock	114.98	115.095	114.1925	114.4738	12725032.0
2020-08-13 15:00:00	AAPL	Stock	114.465	115.1775	114.325	115.0425	10556788.0
2020-08-13 15:30:00	AAPL	Stock	115.055	115.325	114.815	115.0075	12694148.0
2020-08-13 16:00:00	AAPL	Stock	115.01	115.01	114.875	114.925	4062328.0
2020-08-13 16:30:00	AAPL	Stock	114.9375	114.9975	114.9075	114.975	92280.0
2020-08-13 17:00:00	AAPL	Stock	114.9575	114.9575	114.375	114.66	378316.0
2020-08-13 17:30:00	AAPL	Stock	114.705	114.8325	114.6	114.78	106368.0
2020-08-13 18:00:00	AAPL	Stock	114.8075	114.875	114.7625	114.875	89000.0
2020-08-13 18:30:00	AAPL	Stock	114.9625	114.9625	114.8375	114.8425	64620.0
2020-08-13 19:00:00	AAPL	Stock	114.85	114.925	114.845	114.9075	69764.0
2020-08-13 19:30:00	AAPL	Stock	114.925	114.985	114.875	114.875	128588.0
2020-08-13 04:00:00	MSFT	Stock	209.1	209.1	208.85	208.85	1211.0
2020-08-13 05:30:00	MSFT	Stock	208.96	208.96	208.85	208.85	398.0
2020-08-13 06:00:00	MSFT	Stock	208.86	208.9	208.84	208.85	836.0
2020-08-13 06:30:00	MSFT	Stock	208.89	208.95	208.82	208.82	591.0
2020-08-13 07:00:00	MSFT	Stock	208.96	209.19	208.72	209.06	6636.0
2020-08-13 07:30:00	MSFT	Stock	208.87	208.98	208.67	208.98	5606.0
2020-08-13 08:00:00	MSFT	Stock	209.144	209.71	208.65	209.25	27993.0
2020-08-13 08:30:00	MSFT	Stock	209.33	209.9	209.202	209.84	52072.0
2020-08-13 09:00:00	MSFT	Stock	209.72	209.859	209.5	209.51	38018.0
2020-08-13 09:30:00	MSFT	Stock	209.41	211.29	209.21	210.26	3022685.0
2020-08-13 10:00:00	MSFT	Stock	210.255	210.27	208.841	210.18	1742016.0
2020-08-13 10:30:00	MSFT	Stock	210.19	210.83	210.16	210.36	1446339.0
2020-08-13 11:00:00	MSFT	Stock	210.362	210.9	210.34	210.625	819383.0
2020-08-13 11:30:00	MSFT	Stock	210.624	210.953	210.45	210.87	995615.0
2020-08-13 12:00:00	MSFT	Stock	210.88	211.35	210.78	211.02	933017.0
2020-08-13 12:30:00	MSFT	Stock	211.03	211.28	210.6	210.92	629794.0
2020-08-13 13:00:00	MSFT	Stock	210.94	211.04	209.66	209.71	825872.0
2020-08-13 13:30:00	MSFT	Stock	209.74	209.99	209.25	209.855	963277.0

> showing 50 of 96,412 rows — these rows as CSV

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