PREVIEW / stock_30min / 2019-07-05

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-07-05.parquet
  size:    1.6 MB
  rows:    80,812
  symbols: 2,553

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-07-05 04:00:00	AAPL	Stock	51.1025	51.1375	50.98	50.98	4852.0
2019-07-05 04:30:00	AAPL	Stock	50.98	50.9875	50.895	50.895	1708.0
2019-07-05 05:00:00	AAPL	Stock	50.9175	51.0	50.9175	51.0	2540.0
2019-07-05 05:30:00	AAPL	Stock	50.95	50.95	50.95	50.95	3000.0
2019-07-05 06:00:00	AAPL	Stock	50.9675	51.0	50.9625	51.0	5000.0
2019-07-05 06:30:00	AAPL	Stock	50.9625	50.9625	50.9625	50.9625	2028.0
2019-07-05 07:00:00	AAPL	Stock	50.95	51.025	50.95	51.0	22404.0
2019-07-05 07:30:00	AAPL	Stock	51.01	51.0275	51.01	51.025	10168.0
2019-07-05 08:00:00	AAPL	Stock	51.01	51.0475	50.9775	51.0	61496.0
2019-07-05 08:30:00	AAPL	Stock	51.0	51.075	50.7475	50.825	301432.0
2019-07-05 09:00:00	AAPL	Stock	50.8525	50.895	50.7325	50.8025	193196.0
2019-07-05 09:30:00	AAPL	Stock	50.8375	51.115	50.725	50.9875	9128364.0
2019-07-05 10:00:00	AAPL	Stock	50.99	51.115	50.925	50.9525	4992320.0
2019-07-05 10:30:00	AAPL	Stock	50.9575	51.0142	50.8525	50.9575	4307856.0
2019-07-05 11:00:00	AAPL	Stock	50.96	51.0025	50.895	50.97	2894512.0
2019-07-05 11:30:00	AAPL	Stock	50.9725	50.995	50.8928	50.9725	2291496.0
2019-07-05 12:00:00	AAPL	Stock	50.975	51.1	50.943	51.075	2056968.0
2019-07-05 12:30:00	AAPL	Stock	51.0795	51.135	51.065	51.0675	2549752.0
2019-07-05 13:00:00	AAPL	Stock	51.0682	51.1725	51.0375	51.17	2448420.0
2019-07-05 13:30:00	AAPL	Stock	51.1725	51.24	51.14	51.1975	2293812.0
2019-07-05 14:00:00	AAPL	Stock	51.195	51.235	51.1712	51.2275	1773504.0
2019-07-05 14:30:00	AAPL	Stock	51.2275	51.27	51.1975	51.255	4597124.0
2019-07-05 15:00:00	AAPL	Stock	51.255	51.26	51.13	51.205	3684152.0
2019-07-05 15:30:00	AAPL	Stock	51.205	51.2175	50.93	51.0625	8046616.0
2019-07-05 16:00:00	AAPL	Stock	51.0525	51.18	50.9775	50.9775	6786392.0
2019-07-05 16:30:00	AAPL	Stock	50.9875	51.025	50.985	51.0025	44564.0
2019-07-05 17:00:00	AAPL	Stock	51.0225	51.0225	50.9675	50.9675	34976.0
2019-07-05 17:30:00	AAPL	Stock	51.02	51.02	50.9625	50.975	10380.0
2019-07-05 18:00:00	AAPL	Stock	51.0	51.0	50.99	50.99	2000.0
2019-07-05 18:30:00	AAPL	Stock	50.99	51.0125	50.99	50.9925	6076.0
2019-07-05 19:00:00	AAPL	Stock	50.9925	50.9925	50.975	50.975	14896.0
2019-07-05 19:30:00	AAPL	Stock	50.9825	51.0075	50.97	51.0075	15408.0
2019-07-05 04:00:00	MSFT	Stock	137.73	137.75	137.73	137.75	1000.0
2019-07-05 04:30:00	MSFT	Stock	137.84	138.01	137.5	137.5	17789.0
2019-07-05 05:00:00	MSFT	Stock	137.51	137.54	137.51	137.54	200.0
2019-07-05 05:30:00	MSFT	Stock	137.79	137.79	137.4	137.4	906.0
2019-07-05 06:00:00	MSFT	Stock	137.4	137.78	137.35	137.41	2317.0
2019-07-05 07:00:00	MSFT	Stock	137.48	137.51	137.4	137.46	2520.0
2019-07-05 07:30:00	MSFT	Stock	137.43	137.49	137.4	137.49	3293.0
2019-07-05 08:00:00	MSFT	Stock	137.35	137.64	137.35	137.52	12019.0
2019-07-05 08:30:00	MSFT	Stock	137.51	137.51	136.2	136.75	33396.0
2019-07-05 09:00:00	MSFT	Stock	136.75	136.78	135.89	135.96	33872.0
2019-07-05 09:30:00	MSFT	Stock	135.94	136.9	135.86	135.87	2354771.0
2019-07-05 10:00:00	MSFT	Stock	135.87	136.41	135.87	135.93	1293840.0
2019-07-05 10:30:00	MSFT	Stock	135.93	136.0	135.72	135.88	899577.0
2019-07-05 11:00:00	MSFT	Stock	135.89	136.205	135.77	136.16	813873.0
2019-07-05 11:30:00	MSFT	Stock	136.155	136.24	135.81	135.995	853446.0
2019-07-05 12:00:00	MSFT	Stock	136.0	136.205	135.8	136.16	644166.0
2019-07-05 12:30:00	MSFT	Stock	136.16	136.5	136.16	136.297	627103.0
2019-07-05 13:00:00	MSFT	Stock	136.3	136.7	136.23	136.7	549194.0

> showing 50 of 80,812 rows — these rows as CSV

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