PREVIEW / stock_30min / 2019-09-12

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-09-12.parquet
  size:    1.7 MB
  rows:    85,604
  symbols: 2,558

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-09-12 04:00:00	AAPL	Stock	56.3275	56.3275	56.06	56.1375	41392.0
2019-09-12 04:30:00	AAPL	Stock	56.125	56.125	56.0	56.0	4728.0
2019-09-12 05:00:00	AAPL	Stock	55.97	56.05	55.95	56.0025	26408.0
2019-09-12 05:30:00	AAPL	Stock	56.0175	56.075	55.975	55.975	31912.0
2019-09-12 06:00:00	AAPL	Stock	55.975	56.0475	55.95	55.95	18672.0
2019-09-12 06:30:00	AAPL	Stock	56.0	56.0	55.985	55.99	4032.0
2019-09-12 07:00:00	AAPL	Stock	55.995	56.1875	55.9875	56.16	232984.0
2019-09-12 07:30:00	AAPL	Stock	56.1625	56.3	56.0825	56.1875	323896.0
2019-09-12 08:00:00	AAPL	Stock	56.12	56.2625	56.0275	56.1625	356200.0
2019-09-12 08:30:00	AAPL	Stock	56.185	56.2825	56.1825	56.22	282264.0
2019-09-12 09:00:00	AAPL	Stock	56.2125	56.26	56.165	56.22	411180.0
2019-09-12 09:30:00	AAPL	Stock	56.2	56.4375	55.755	56.0625	23573784.0
2019-09-12 10:00:00	AAPL	Stock	56.0675	56.605	56.015	56.48	15659424.0
2019-09-12 10:30:00	AAPL	Stock	56.4775	56.5	55.95	56.119	9082680.0
2019-09-12 11:00:00	AAPL	Stock	56.115	56.415	56.0875	56.3725	5726068.0
2019-09-12 11:30:00	AAPL	Stock	56.3775	56.465	56.2325	56.4475	4903152.0
2019-09-12 12:00:00	AAPL	Stock	56.445	56.4512	56.28	56.3125	4295848.0
2019-09-12 12:30:00	AAPL	Stock	56.315	56.38	56.265	56.3715	2777840.0
2019-09-12 13:00:00	AAPL	Stock	56.3725	56.4725	56.25	56.2775	4091196.0
2019-09-12 13:30:00	AAPL	Stock	56.28	56.3525	56.2275	56.2775	2752428.0
2019-09-12 14:00:00	AAPL	Stock	56.277	56.2975	56.1625	56.23	2926836.0
2019-09-12 14:30:00	AAPL	Stock	56.23	56.3325	56.2002	56.2462	2833956.0
2019-09-12 15:00:00	AAPL	Stock	56.2475	56.25	56.105	56.1375	3444512.0
2019-09-12 15:30:00	AAPL	Stock	56.1375	56.2175	55.715	55.7725	10626268.0
2019-09-12 16:00:00	AAPL	Stock	55.79	56.1515	55.625	55.65	13892588.0
2019-09-12 16:30:00	AAPL	Stock	55.6775	55.7712	55.6375	55.675	63748.0
2019-09-12 17:00:00	AAPL	Stock	55.65	55.715	55.65	55.715	21044.0
2019-09-12 17:30:00	AAPL	Stock	55.7	55.75	55.6875	55.75	26428.0
2019-09-12 18:00:00	AAPL	Stock	55.75	55.915	55.75	55.8375	92924.0
2019-09-12 18:30:00	AAPL	Stock	55.7875	55.8625	55.7875	55.85	33288.0
2019-09-12 19:00:00	AAPL	Stock	55.8375	55.85	55.785	55.785	18984.0
2019-09-12 19:30:00	AAPL	Stock	55.8	55.8725	55.795	55.85	60700.0
2019-09-12 04:00:00	MSFT	Stock	136.88	136.88	136.65	136.65	868.0
2019-09-12 04:30:00	MSFT	Stock	136.7	136.7	136.7	136.7	285.0
2019-09-12 05:00:00	MSFT	Stock	136.56	136.7	136.51	136.7	1083.0
2019-09-12 05:30:00	MSFT	Stock	136.61	136.62	136.5	136.6	2976.0
2019-09-12 06:00:00	MSFT	Stock	136.65	136.65	136.4	136.4	1400.0
2019-09-12 06:30:00	MSFT	Stock	136.52	136.52	136.52	136.52	100.0
2019-09-12 07:00:00	MSFT	Stock	136.52	136.7	136.42	136.6	9062.0
2019-09-12 07:30:00	MSFT	Stock	136.6	136.99	136.5	136.8	10916.0
2019-09-12 08:00:00	MSFT	Stock	136.75	136.98	136.49	136.87	16455.0
2019-09-12 08:30:00	MSFT	Stock	136.95	137.17	136.8	137.001	24504.0
2019-09-12 09:00:00	MSFT	Stock	136.9	137.88	136.9	137.47	73904.0
2019-09-12 09:30:00	MSFT	Stock	137.85	137.85	136.87	137.09	3690022.0
2019-09-12 10:00:00	MSFT	Stock	137.11	138.15	137.01	137.869	3066187.0
2019-09-12 10:30:00	MSFT	Stock	137.87	138.0	137.07	137.44	1356461.0
2019-09-12 11:00:00	MSFT	Stock	137.42	137.682	137.02	137.58	876104.0
2019-09-12 11:30:00	MSFT	Stock	137.58	137.62	137.23	137.49	691106.0
2019-09-12 12:00:00	MSFT	Stock	137.49	137.75	137.33	137.75	788052.0
2019-09-12 12:30:00	MSFT	Stock	137.745	138.11	137.74	138.065	1182929.0

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

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