PREVIEW / stock_30min / 2020-06-16

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-06-16.parquet
  size:    2.0 MB
  rows:    100,828
  symbols: 2,419

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-06-16 04:00:00	AAPL	Stock	86.575	86.8975	86.575	86.8125	34568.0
2020-06-16 04:30:00	AAPL	Stock	86.825	86.9075	86.825	86.9	16656.0
2020-06-16 05:00:00	AAPL	Stock	86.835	87.0	86.835	86.935	14880.0
2020-06-16 05:30:00	AAPL	Stock	87.0	87.0675	86.5025	86.8	68792.0
2020-06-16 06:00:00	AAPL	Stock	86.7975	87.115	86.7975	87.0	31536.0
2020-06-16 06:30:00	AAPL	Stock	87.0	87.1125	86.8875	86.8875	14564.0
2020-06-16 07:00:00	AAPL	Stock	86.82	86.925	86.6875	86.875	185280.0
2020-06-16 07:30:00	AAPL	Stock	86.8725	87.375	86.865	87.2875	286528.0
2020-06-16 08:00:00	AAPL	Stock	86.775	87.475	86.6925	87.45	378748.0
2020-06-16 08:30:00	AAPL	Stock	87.4825	88.125	87.4825	87.762	786704.0
2020-06-16 09:00:00	AAPL	Stock	87.76	87.8775	87.6	87.855	417200.0
2020-06-16 09:30:00	AAPL	Stock	87.87	88.255	87.2625	87.9538	21215160.0
2020-06-16 10:00:00	AAPL	Stock	87.95	88.1225	87.7575	87.9525	9158436.0
2020-06-16 10:30:00	AAPL	Stock	87.9625	88.1425	86.54	86.625	12709352.0
2020-06-16 11:00:00	AAPL	Stock	86.5775	87.5875	86.18	87.375	11764548.0
2020-06-16 11:30:00	AAPL	Stock	87.4025	87.905	87.265	87.595	7870308.0
2020-06-16 12:00:00	AAPL	Stock	87.61	87.6875	87.2825	87.64	5214380.0
2020-06-16 12:30:00	AAPL	Stock	87.63	87.9975	87.615	87.7675	7472004.0
2020-06-16 13:00:00	AAPL	Stock	87.79	88.0	87.69	87.9475	5198300.0
2020-06-16 13:30:00	AAPL	Stock	87.9275	88.0	87.6825	87.8725	5628072.0
2020-06-16 14:00:00	AAPL	Stock	87.8718	88.3	87.6975	88.045	9361812.0
2020-06-16 14:30:00	AAPL	Stock	88.0412	88.2375	87.765	87.8348	5375276.0
2020-06-16 15:00:00	AAPL	Stock	87.83	87.9675	87.2925	87.6035	7219696.0
2020-06-16 15:30:00	AAPL	Stock	87.605	88.08	87.452	88.065	11826092.0
2020-06-16 16:00:00	AAPL	Stock	88.02	88.15	87.7025	88.1	9594428.0
2020-06-16 16:30:00	AAPL	Stock	88.1025	88.1025	87.9625	88.0625	56368.0
2020-06-16 17:00:00	AAPL	Stock	88.0275	88.075	87.8	87.8	30540.0
2020-06-16 17:30:00	AAPL	Stock	87.75	87.8725	87.575	87.7475	55404.0
2020-06-16 18:00:00	AAPL	Stock	87.75	87.9725	87.625	87.875	48124.0
2020-06-16 18:30:00	AAPL	Stock	87.7625	88.0825	87.675	88.0725	45480.0
2020-06-16 19:00:00	AAPL	Stock	88.08	88.2225	88.0	88.1925	39656.0
2020-06-16 19:30:00	AAPL	Stock	88.185	88.25	88.1	88.1875	114804.0
2020-06-16 04:00:00	MSFT	Stock	191.35	191.35	191.0	191.15	3356.0
2020-06-16 04:30:00	MSFT	Stock	191.15	191.61	191.15	191.61	3153.0
2020-06-16 05:00:00	MSFT	Stock	191.84	192.17	191.58	192.0	4389.0
2020-06-16 05:30:00	MSFT	Stock	191.99	192.26	191.74	191.91	4030.0
2020-06-16 06:00:00	MSFT	Stock	192.16	192.89	192.16	192.65	2615.0
2020-06-16 06:30:00	MSFT	Stock	192.56	192.82	192.29	192.29	4431.0
2020-06-16 07:00:00	MSFT	Stock	191.75	192.3	191.4	191.78	23058.0
2020-06-16 07:30:00	MSFT	Stock	191.78	191.98	191.75	191.94	10883.0
2020-06-16 08:00:00	MSFT	Stock	191.75	192.3	191.4	192.22	69555.0
2020-06-16 08:30:00	MSFT	Stock	192.25	193.88	192.25	193.61	98119.0
2020-06-16 09:00:00	MSFT	Stock	193.67	193.779	192.5	192.89	70273.0
2020-06-16 09:30:00	MSFT	Stock	192.9	194.49	192.28	193.86	4573876.0
2020-06-16 10:00:00	MSFT	Stock	193.88	195.39	193.7	195.04	2871047.0
2020-06-16 10:30:00	MSFT	Stock	195.04	195.58	192.11	192.28	3473779.0
2020-06-16 11:00:00	MSFT	Stock	192.3	194.4	191.46	193.88	3216920.0
2020-06-16 11:30:00	MSFT	Stock	193.85	194.59	193.18	193.88	1859898.0
2020-06-16 12:00:00	MSFT	Stock	193.9	194.13	192.82	193.41	1531009.0
2020-06-16 12:30:00	MSFT	Stock	193.39	194.12	193.371	193.89	1544996.0

> showing 50 of 100,828 rows — these rows as CSV

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