PREVIEW / stock_30min / 2019-06-18

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-06-18.parquet
  size:    1.7 MB
  rows:    85,627
  symbols: 2,609

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-06-18 04:00:00	AAPL	Stock	48.4725	48.75	48.4725	48.75	3640.0
2019-06-18 04:30:00	AAPL	Stock	48.75	48.8425	48.75	48.775	13284.0
2019-06-18 05:00:00	AAPL	Stock	48.8	48.8175	48.8	48.8175	16564.0
2019-06-18 05:30:00	AAPL	Stock	48.835	48.835	48.7825	48.7825	4604.0
2019-06-18 06:00:00	AAPL	Stock	48.775	48.7775	48.725	48.75	6448.0
2019-06-18 06:30:00	AAPL	Stock	48.7725	48.9225	48.7175	48.8875	44872.0
2019-06-18 07:00:00	AAPL	Stock	48.8075	48.875	48.7725	48.825	93560.0
2019-06-18 07:30:00	AAPL	Stock	48.8	48.975	48.7925	48.9125	104360.0
2019-06-18 08:00:00	AAPL	Stock	48.775	49.0125	48.7725	48.975	190600.0
2019-06-18 08:30:00	AAPL	Stock	48.9975	49.0	48.8825	48.95	82780.0
2019-06-18 09:00:00	AAPL	Stock	48.9575	49.005	48.8775	49.0025	107124.0
2019-06-18 09:30:00	AAPL	Stock	49.005	49.96	48.8025	49.765	23120144.0
2019-06-18 10:00:00	AAPL	Stock	49.765	50.0	49.74	49.88	11724592.0
2019-06-18 10:30:00	AAPL	Stock	49.875	50.0725	49.8625	50.0018	9243396.0
2019-06-18 11:00:00	AAPL	Stock	50.0025	50.0675	49.75	49.7525	7406888.0
2019-06-18 11:30:00	AAPL	Stock	49.7525	49.8325	49.5875	49.63	5118060.0
2019-06-18 12:00:00	AAPL	Stock	49.63	49.7475	49.6	49.71	3024760.0
2019-06-18 12:30:00	AAPL	Stock	49.71	49.7725	49.6365	49.69	2417824.0
2019-06-18 13:00:00	AAPL	Stock	49.6875	49.6875	49.5375	49.5665	2347680.0
2019-06-18 13:30:00	AAPL	Stock	49.5625	49.6618	49.515	49.64	2447312.0
2019-06-18 14:00:00	AAPL	Stock	49.64	49.7475	49.64	49.7075	2542636.0
2019-06-18 14:30:00	AAPL	Stock	49.7125	49.7575	49.67	49.7325	2125124.0
2019-06-18 15:00:00	AAPL	Stock	49.73	49.7475	49.6275	49.6625	3002524.0
2019-06-18 15:30:00	AAPL	Stock	49.6625	49.675	49.475	49.625	8514864.0
2019-06-18 16:00:00	AAPL	Stock	49.6125	49.8625	49.5775	49.7875	7846500.0
2019-06-18 16:30:00	AAPL	Stock	49.8	49.8	49.6125	49.7375	41640.0
2019-06-18 17:00:00	AAPL	Stock	49.7475	49.7475	49.65	49.7	11984.0
2019-06-18 17:30:00	AAPL	Stock	49.6675	49.7	49.6625	49.6625	21492.0
2019-06-18 18:00:00	AAPL	Stock	49.6625	49.695	49.6525	49.6575	23380.0
2019-06-18 18:30:00	AAPL	Stock	49.6875	49.695	49.66	49.68	16708.0
2019-06-18 19:00:00	AAPL	Stock	49.695	49.75	49.6875	49.75	17224.0
2019-06-18 19:30:00	AAPL	Stock	49.7375	49.825	49.705	49.825	41540.0
2019-06-18 04:00:00	MSFT	Stock	133.28	133.59	133.28	133.59	300.0
2019-06-18 05:00:00	MSFT	Stock	133.88	133.88	133.88	133.88	100.0
2019-06-18 05:30:00	MSFT	Stock	133.61	133.61	133.61	133.61	100.0
2019-06-18 06:30:00	MSFT	Stock	133.78	134.09	133.78	134.09	1998.0
2019-06-18 07:00:00	MSFT	Stock	133.97	133.97	133.85	133.95	16226.0
2019-06-18 07:30:00	MSFT	Stock	133.87	134.2	133.87	134.14	18442.0
2019-06-18 08:00:00	MSFT	Stock	134.038	134.25	133.18	134.2	26983.0
2019-06-18 08:30:00	MSFT	Stock	134.2	134.25	134.0	134.12	13807.0
2019-06-18 09:00:00	MSFT	Stock	134.118	134.29	133.8	134.02	37046.0
2019-06-18 09:30:00	MSFT	Stock	134.11	135.0	133.57	134.72	3559582.0
2019-06-18 10:00:00	MSFT	Stock	134.72	135.145	134.535	134.63	2126406.0
2019-06-18 10:30:00	MSFT	Stock	134.62	135.163	134.589	135.045	1452516.0
2019-06-18 11:00:00	MSFT	Stock	135.04	135.15	134.44	134.6	1632661.0
2019-06-18 11:30:00	MSFT	Stock	134.61	134.925	134.59	134.63	995821.0
2019-06-18 12:00:00	MSFT	Stock	134.625	134.8	134.18	134.24	1041516.0
2019-06-18 12:30:00	MSFT	Stock	134.23	134.66	134.21	134.56	788224.0
2019-06-18 13:00:00	MSFT	Stock	134.55	134.64	134.29	134.5	766156.0
2019-06-18 13:30:00	MSFT	Stock	134.5	134.73	134.48	134.64	633739.0

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

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