PREVIEW / stock_30min / 2020-03-03

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-03-03.parquet
  size:    1.9 MB
  rows:    90,923
  symbols: 2,416

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-03-03 04:00:00	AAPL	Stock	75.075	75.43	74.75	75.005	82656.0
2020-03-03 04:30:00	AAPL	Stock	75.0375	75.37	74.9	75.25	103512.0
2020-03-03 05:00:00	AAPL	Stock	75.25	75.3575	75.175	75.3575	67228.0
2020-03-03 05:30:00	AAPL	Stock	75.3375	75.375	75.15	75.2375	97916.0
2020-03-03 06:00:00	AAPL	Stock	75.23	75.23	74.5675	74.8	69040.0
2020-03-03 06:30:00	AAPL	Stock	74.85	74.93	74.6275	74.7775	36160.0
2020-03-03 07:00:00	AAPL	Stock	74.87	75.55	74.7975	75.525	777220.0
2020-03-03 07:30:00	AAPL	Stock	75.55	75.7925	74.75	75.1975	1533528.0
2020-03-03 08:00:00	AAPL	Stock	75.13	75.7525	74.7	75.32	1876084.0
2020-03-03 08:30:00	AAPL	Stock	75.3275	75.4225	74.925	75.1025	719836.0
2020-03-03 09:00:00	AAPL	Stock	75.1	76.0375	74.95	75.9175	1279592.0
2020-03-03 09:30:00	AAPL	Stock	75.9175	75.9825	73.065	73.585	42457992.0
2020-03-03 10:00:00	AAPL	Stock	73.565	76.0	73.51	74.9225	38555164.0
2020-03-03 10:30:00	AAPL	Stock	74.91	75.235	74.265	74.845	16459368.0
2020-03-03 11:00:00	AAPL	Stock	74.8175	74.9825	72.7725	73.0075	19512308.0
2020-03-03 11:30:00	AAPL	Stock	72.9775	74.165	72.895	73.9675	14144308.0
2020-03-03 12:00:00	AAPL	Stock	73.9875	74.3725	73.385	73.455	9839568.0
2020-03-03 12:30:00	AAPL	Stock	73.4715	73.8975	73.19	73.4175	7107280.0
2020-03-03 13:00:00	AAPL	Stock	73.425	73.425	72.38	72.845	11307220.0
2020-03-03 13:30:00	AAPL	Stock	72.8375	73.055	72.0	72.04	10974332.0
2020-03-03 14:00:00	AAPL	Stock	72.0575	72.315	71.45	71.975	17033632.0
2020-03-03 14:30:00	AAPL	Stock	71.98	72.6835	71.735	72.57	14467352.0
2020-03-03 15:00:00	AAPL	Stock	72.5775	73.3575	72.4025	73.2622	16224108.0
2020-03-03 15:30:00	AAPL	Stock	73.25	73.25	71.96	72.3275	22700076.0
2020-03-03 16:00:00	AAPL	Stock	72.33	72.875	72.245	72.3725	15183656.0
2020-03-03 16:30:00	AAPL	Stock	72.325	72.45	72.1275	72.165	87348.0
2020-03-03 17:00:00	AAPL	Stock	72.2475	72.2475	72.0	72.125	44404.0
2020-03-03 17:30:00	AAPL	Stock	72.075	72.125	71.6875	71.75	101208.0
2020-03-03 18:00:00	AAPL	Stock	71.75	71.875	71.3825	71.825	386504.0
2020-03-03 18:30:00	AAPL	Stock	71.8125	71.8125	71.56	71.775	71168.0
2020-03-03 19:00:00	AAPL	Stock	71.75	72.475	71.75	72.375	112632.0
2020-03-03 19:30:00	AAPL	Stock	72.4375	72.75	72.325	72.725	222504.0
2020-03-03 04:00:00	MSFT	Stock	173.83	173.9	172.79	173.42	14617.0
2020-03-03 04:30:00	MSFT	Stock	173.7	174.2	173.4	173.83	10970.0
2020-03-03 05:00:00	MSFT	Stock	173.83	174.65	173.79	174.56	18775.0
2020-03-03 05:30:00	MSFT	Stock	174.33	174.59	174.11	174.39	8668.0
2020-03-03 06:00:00	MSFT	Stock	174.25	174.25	172.23	173.0	31151.0
2020-03-03 06:30:00	MSFT	Stock	173.0	173.33	172.65	173.05	7222.0
2020-03-03 07:00:00	MSFT	Stock	173.05	174.37	173.0	174.0	78476.0
2020-03-03 07:30:00	MSFT	Stock	174.0	174.3	172.01	172.8	176998.0
2020-03-03 08:00:00	MSFT	Stock	172.8	174.3	170.98	173.17	127596.0
2020-03-03 08:30:00	MSFT	Stock	173.2	173.92	172.55	173.45	129249.0
2020-03-03 09:00:00	MSFT	Stock	173.4	174.44	172.79	173.72	181166.0
2020-03-03 09:30:00	MSFT	Stock	173.71	174.0	168.0	168.809	8007953.0
2020-03-03 10:00:00	MSFT	Stock	168.8	175.0	168.67	172.07	7910542.0
2020-03-03 10:30:00	MSFT	Stock	172.015	172.67	170.66	171.701	3187573.0
2020-03-03 11:00:00	MSFT	Stock	171.65	171.91	167.058	167.57	3644107.0
2020-03-03 11:30:00	MSFT	Stock	167.592	170.0	167.34	169.92	2094023.0
2020-03-03 12:00:00	MSFT	Stock	169.91	170.48	168.01	168.14	2057593.0
2020-03-03 12:30:00	MSFT	Stock	168.146	169.06	167.5	168.098	1857068.0

> showing 50 of 90,923 rows — these rows as CSV

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