PREVIEW / stock_30min / 2020-05-13

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-05-13.parquet
  size:    1.9 MB
  rows:    94,918
  symbols: 2,388

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-05-13 04:00:00	AAPL	Stock	77.7525	78.09	77.6875	78.075	30544.0
2020-05-13 04:30:00	AAPL	Stock	78.115	78.2475	77.9	77.975	21988.0
2020-05-13 05:00:00	AAPL	Stock	78.025	78.1	77.9775	78.075	14728.0
2020-05-13 05:30:00	AAPL	Stock	78.095	78.27	78.095	78.27	15192.0
2020-05-13 06:00:00	AAPL	Stock	78.21	78.285	78.205	78.25	29388.0
2020-05-13 06:30:00	AAPL	Stock	78.1825	78.2975	78.1475	78.2475	20736.0
2020-05-13 07:00:00	AAPL	Stock	78.165	78.3625	78.0175	78.33	169416.0
2020-05-13 07:30:00	AAPL	Stock	78.35	78.5	78.255	78.45	210392.0
2020-05-13 08:00:00	AAPL	Stock	78.125	78.5	78.005	78.4375	503128.0
2020-05-13 08:30:00	AAPL	Stock	78.425	78.4375	78.225	78.3275	268248.0
2020-05-13 09:00:00	AAPL	Stock	78.32	78.32	77.725	78.0075	703160.0
2020-05-13 09:30:00	AAPL	Stock	78.025	78.3725	77.5275	78.3075	21041764.0
2020-05-13 10:00:00	AAPL	Stock	78.3	78.835	78.27	78.7825	13676064.0
2020-05-13 10:30:00	AAPL	Stock	78.7875	78.9875	78.1495	78.2192	11410072.0
2020-05-13 11:00:00	AAPL	Stock	78.22	78.5982	77.7675	77.985	11640472.0
2020-05-13 11:30:00	AAPL	Stock	77.985	78.125	77.195	77.315	13205096.0
2020-05-13 12:00:00	AAPL	Stock	77.3165	77.335	75.8025	76.6112	19623132.0
2020-05-13 12:30:00	AAPL	Stock	76.6175	77.04	76.3625	76.805	10310052.0
2020-05-13 13:00:00	AAPL	Stock	76.8	76.8475	76.1375	76.375	8772344.0
2020-05-13 13:30:00	AAPL	Stock	76.3675	76.5325	76.1325	76.1775	6025536.0
2020-05-13 14:00:00	AAPL	Stock	76.1775	76.725	75.955	76.4178	7138140.0
2020-05-13 14:30:00	AAPL	Stock	76.42	76.4675	75.9275	75.9362	7266128.0
2020-05-13 15:00:00	AAPL	Stock	75.9342	76.5	75.8188	76.185	10795488.0
2020-05-13 15:30:00	AAPL	Stock	76.1825	77.1	76.0502	76.92	16033308.0
2020-05-13 16:00:00	AAPL	Stock	76.9125	77.1	76.9	76.995	8096636.0
2020-05-13 16:30:00	AAPL	Stock	77.0	77.0875	76.9975	77.065	72436.0
2020-05-13 17:00:00	AAPL	Stock	77.065	77.1875	77.0475	77.1775	58388.0
2020-05-13 17:30:00	AAPL	Stock	77.1825	77.195	77.125	77.195	45148.0
2020-05-13 18:00:00	AAPL	Stock	77.1925	77.2425	77.135	77.1875	44260.0
2020-05-13 18:30:00	AAPL	Stock	77.1375	77.2225	77.1375	77.1875	34580.0
2020-05-13 19:00:00	AAPL	Stock	77.2225	77.25	77.175	77.235	36880.0
2020-05-13 19:30:00	AAPL	Stock	77.25	77.37	77.0625	77.125	91592.0
2020-05-13 04:00:00	MSFT	Stock	182.36	183.2	182.07	182.94	7323.0
2020-05-13 04:30:00	MSFT	Stock	183.4	183.48	182.67	182.67	4939.0
2020-05-13 05:00:00	MSFT	Stock	182.71	183.3	182.71	183.09	1824.0
2020-05-13 05:30:00	MSFT	Stock	182.88	183.67	182.88	183.61	1811.0
2020-05-13 06:00:00	MSFT	Stock	183.65	184.27	183.61	183.9	7114.0
2020-05-13 06:30:00	MSFT	Stock	183.9	183.94	183.6	183.89	4816.0
2020-05-13 07:00:00	MSFT	Stock	183.6	183.7	183.16	183.7	34526.0
2020-05-13 07:30:00	MSFT	Stock	183.5	184.0	183.41	183.86	19577.0
2020-05-13 08:00:00	MSFT	Stock	183.358	184.0	183.15	183.77	41399.0
2020-05-13 08:30:00	MSFT	Stock	183.7	183.81	183.18	183.499	30981.0
2020-05-13 09:00:00	MSFT	Stock	183.32	183.5	182.27	182.42	95654.0
2020-05-13 09:30:00	MSFT	Stock	182.42	182.89	180.22	181.97	4423545.0
2020-05-13 10:00:00	MSFT	Stock	181.97	183.45	181.88	183.34	2808916.0
2020-05-13 10:30:00	MSFT	Stock	183.34	184.05	182.03	182.15	1902151.0
2020-05-13 11:00:00	MSFT	Stock	182.19	182.86	180.87	181.49	1892268.0
2020-05-13 11:30:00	MSFT	Stock	181.475	181.66	179.035	179.4	2905181.0
2020-05-13 12:00:00	MSFT	Stock	179.39	179.59	176.54	178.609	4197617.0
2020-05-13 12:30:00	MSFT	Stock	178.6	179.88	177.84	179.55	2701660.0

> showing 50 of 94,918 rows — these rows as CSV

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