PREVIEW / stock_30min / 2019-05-20

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-05-20.parquet
  size:    1.7 MB
  rows:    83,899
  symbols: 2,589

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-20 04:00:00	AAPL	Stock	47.325	47.45	47.325	47.3625	25268.0
2019-05-20 04:30:00	AAPL	Stock	47.3325	47.3325	46.7	46.715	91896.0
2019-05-20 05:00:00	AAPL	Stock	46.705	46.85	46.6125	46.75	56780.0
2019-05-20 05:30:00	AAPL	Stock	46.7525	46.7775	46.6975	46.7375	34656.0
2019-05-20 06:00:00	AAPL	Stock	46.6325	46.6325	46.235	46.25	243344.0
2019-05-20 06:30:00	AAPL	Stock	46.2275	46.35	46.035	46.05	159180.0
2019-05-20 07:00:00	AAPL	Stock	46.0475	46.2175	45.9625	46.2125	484892.0
2019-05-20 07:30:00	AAPL	Stock	46.21	46.21	46.025	46.0825	358344.0
2019-05-20 08:00:00	AAPL	Stock	46.0975	46.2	45.875	45.9575	701648.0
2019-05-20 08:30:00	AAPL	Stock	45.95	46.06	45.825	45.9125	575552.0
2019-05-20 09:00:00	AAPL	Stock	45.9375	46.1	45.775	45.8975	824596.0
2019-05-20 09:30:00	AAPL	Stock	45.9075	45.9975	45.071	45.7425	33343480.0
2019-05-20 10:00:00	AAPL	Stock	45.74	45.97	45.5375	45.9128	13961284.0
2019-05-20 10:30:00	AAPL	Stock	45.9222	46.0872	45.7062	45.8375	10291204.0
2019-05-20 11:00:00	AAPL	Stock	45.83	45.8875	45.5625	45.6875	6958960.0
2019-05-20 11:30:00	AAPL	Stock	45.685	45.825	45.5825	45.717	5870432.0
2019-05-20 12:00:00	AAPL	Stock	45.7125	45.855	45.6275	45.7075	5765492.0
2019-05-20 12:30:00	AAPL	Stock	45.7125	45.8	45.62	45.6618	4083068.0
2019-05-20 13:00:00	AAPL	Stock	45.6575	45.6875	45.55	45.67	3831952.0
2019-05-20 13:30:00	AAPL	Stock	45.6685	45.7675	45.635	45.685	4074268.0
2019-05-20 14:00:00	AAPL	Stock	45.6875	45.7125	45.5525	45.6075	3768348.0
2019-05-20 14:30:00	AAPL	Stock	45.605	45.665	45.47	45.4975	6586580.0
2019-05-20 15:00:00	AAPL	Stock	45.5	45.7175	45.437	45.71	7242564.0
2019-05-20 15:30:00	AAPL	Stock	45.7025	45.8125	45.0925	45.7725	11276176.0
2019-05-20 16:00:00	AAPL	Stock	45.7725	45.8075	45.7375	45.795	13689220.0
2019-05-20 16:30:00	AAPL	Stock	45.7975	45.875	45.7725	45.875	365140.0
2019-05-20 17:00:00	AAPL	Stock	45.82	45.87	45.7875	45.79	16656.0
2019-05-20 17:30:00	AAPL	Stock	45.7925	45.825	45.7725	45.82	506200.0
2019-05-20 18:00:00	AAPL	Stock	45.82	45.85	45.8025	45.825	33600.0
2019-05-20 18:30:00	AAPL	Stock	45.8125	45.835	45.8	45.8275	10492.0
2019-05-20 19:00:00	AAPL	Stock	45.835	45.8875	45.825	45.875	31252.0
2019-05-20 19:30:00	AAPL	Stock	45.8875	45.89	45.845	45.8875	56792.0
2019-05-20 04:00:00	MSFT	Stock	127.86	128.55	127.86	128.55	500.0
2019-05-20 04:30:00	MSFT	Stock	128.57	128.57	127.61	127.61	1410.0
2019-05-20 05:00:00	MSFT	Stock	127.8	127.8	127.66	127.66	1158.0
2019-05-20 06:00:00	MSFT	Stock	127.6	127.66	127.0	127.0	2540.0
2019-05-20 06:30:00	MSFT	Stock	127.3	127.35	127.0	127.0	1700.0
2019-05-20 07:00:00	MSFT	Stock	127.05	127.2	126.88	126.91	8544.0
2019-05-20 07:30:00	MSFT	Stock	127.0	127.2	127.0	127.0	7337.0
2019-05-20 08:00:00	MSFT	Stock	127.085	127.2	126.83	126.9	28106.0
2019-05-20 08:30:00	MSFT	Stock	126.91	126.946	126.3	126.7	30265.0
2019-05-20 09:00:00	MSFT	Stock	126.46	126.94	126.4	126.5	55607.0
2019-05-20 09:30:00	MSFT	Stock	126.51	127.04	125.761	127.02	3328245.0
2019-05-20 10:00:00	MSFT	Stock	127.027	127.589	126.48	127.36	1639461.0
2019-05-20 10:30:00	MSFT	Stock	127.35	127.58	127.0	127.44	1245058.0
2019-05-20 11:00:00	MSFT	Stock	127.45	127.575	126.936	127.03	1012105.0
2019-05-20 11:30:00	MSFT	Stock	127.02	127.28	126.69	126.89	1000633.0
2019-05-20 12:00:00	MSFT	Stock	126.89	127.35	126.78	127.017	716473.0
2019-05-20 12:30:00	MSFT	Stock	127.02	127.14	126.583	126.62	833493.0
2019-05-20 13:00:00	MSFT	Stock	126.62	126.69	126.424	126.62	754475.0

> showing 50 of 83,899 rows — these rows as CSV

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