PREVIEW / stock_30min / 2019-05-13

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-05-13.parquet
  size:    1.7 MB
  rows:    85,774
  symbols: 2,620

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-05-13 04:00:00	AAPL	Stock	48.25	48.3175	48.1075	48.25	31144.0
2019-05-13 04:30:00	AAPL	Stock	48.25	48.3375	48.2	48.2	9452.0
2019-05-13 05:00:00	AAPL	Stock	48.3325	48.3375	48.205	48.2475	6840.0
2019-05-13 05:30:00	AAPL	Stock	48.25	48.275	48.25	48.2675	24376.0
2019-05-13 06:00:00	AAPL	Stock	48.2875	48.3125	48.15	48.16	23444.0
2019-05-13 06:30:00	AAPL	Stock	48.2125	48.245	48.115	48.2125	34184.0
2019-05-13 07:00:00	AAPL	Stock	48.24	48.2975	48.025	48.04	162600.0
2019-05-13 07:30:00	AAPL	Stock	48.05	48.12	47.875	47.8925	180224.0
2019-05-13 08:00:00	AAPL	Stock	48.165	48.2525	47.4675	47.4675	1619900.0
2019-05-13 08:30:00	AAPL	Stock	47.4875	47.49	47.275	47.345	949392.0
2019-05-13 09:00:00	AAPL	Stock	47.345	47.3625	46.8625	46.915	1679832.0
2019-05-13 09:30:00	AAPL	Stock	46.9225	47.37	46.5	47.06	40410372.0
2019-05-13 10:00:00	AAPL	Stock	47.0525	47.0573	46.425	46.791	22829632.0
2019-05-13 10:30:00	AAPL	Stock	46.7925	47.125	46.625	46.9585	12767284.0
2019-05-13 11:00:00	AAPL	Stock	46.9592	46.9975	46.6275	46.8	8736064.0
2019-05-13 11:30:00	AAPL	Stock	46.795	46.8752	46.5625	46.7635	8606252.0
2019-05-13 12:00:00	AAPL	Stock	46.77	46.78	46.54	46.6462	6304768.0
2019-05-13 12:30:00	AAPL	Stock	46.645	46.71	46.45	46.4738	7160044.0
2019-05-13 13:00:00	AAPL	Stock	46.47	46.4725	46.27	46.3425	10298724.0
2019-05-13 13:30:00	AAPL	Stock	46.3425	46.7	46.3175	46.6775	9269960.0
2019-05-13 14:00:00	AAPL	Stock	46.675	46.88	46.46	46.7597	9961152.0
2019-05-13 14:30:00	AAPL	Stock	46.7675	46.8625	46.6312	46.7742	7826128.0
2019-05-13 15:00:00	AAPL	Stock	46.7725	46.8525	46.3725	46.3725	8718436.0
2019-05-13 15:30:00	AAPL	Stock	46.3675	46.47	45.7125	46.43	21484708.0
2019-05-13 16:00:00	AAPL	Stock	46.432	46.75	46.3475	46.3475	20041492.0
2019-05-13 16:30:00	AAPL	Stock	46.3475	46.3875	46.32	46.3875	72188.0
2019-05-13 17:00:00	AAPL	Stock	46.375	46.41	46.2325	46.2725	157144.0
2019-05-13 17:30:00	AAPL	Stock	46.2725	46.3	46.225	46.2465	68844.0
2019-05-13 18:00:00	AAPL	Stock	46.235	46.235	46.16	46.1725	98316.0
2019-05-13 18:30:00	AAPL	Stock	46.175	46.2375	46.16	46.2375	64100.0
2019-05-13 19:00:00	AAPL	Stock	46.2425	46.2625	46.1875	46.25	34644.0
2019-05-13 19:30:00	AAPL	Stock	46.2625	46.2625	46.0575	46.0575	70540.0
2019-05-13 04:00:00	MSFT	Stock	125.07	125.07	124.8	125.03	1220.0
2019-05-13 04:30:00	MSFT	Stock	125.09	125.35	125.04	125.04	3276.0
2019-05-13 05:00:00	MSFT	Stock	125.1	125.1	125.01	125.01	862.0
2019-05-13 06:00:00	MSFT	Stock	125.22	125.25	125.06	125.06	1008.0
2019-05-13 06:30:00	MSFT	Stock	125.0	125.2	124.89	125.2	2324.0
2019-05-13 07:00:00	MSFT	Stock	125.29	125.43	125.04	125.12	8487.0
2019-05-13 07:30:00	MSFT	Stock	125.21	125.33	124.86	124.92	21007.0
2019-05-13 08:00:00	MSFT	Stock	125.3	125.45	124.0	124.35	46728.0
2019-05-13 08:30:00	MSFT	Stock	124.55	124.55	124.07	124.38	32048.0
2019-05-13 09:00:00	MSFT	Stock	124.14	124.4	124.02	124.2	42163.0
2019-05-13 09:30:00	MSFT	Stock	124.14	125.55	124.02	124.43	3161523.0
2019-05-13 10:00:00	MSFT	Stock	124.435	124.435	123.64	124.04	2463165.0
2019-05-13 10:30:00	MSFT	Stock	124.035	124.57	123.81	124.28	1891500.0
2019-05-13 11:00:00	MSFT	Stock	124.29	124.46	123.63	123.84	1735414.0
2019-05-13 11:30:00	MSFT	Stock	123.84	124.05	123.59	124.01	1591341.0
2019-05-13 12:00:00	MSFT	Stock	124.006	124.02	123.46	123.565	1298603.0
2019-05-13 12:30:00	MSFT	Stock	123.56	123.78	123.35	123.37	1281067.0
2019-05-13 13:00:00	MSFT	Stock	123.38	123.56	123.15	123.3	1217216.0

> showing 50 of 85,774 rows — these rows as CSV

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