PREVIEW / stock_30min / 2007-02-13

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-02-13.parquet
  size:    1.0 MB
  rows:    55,094
  symbols: 2,509

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
2007-02-13 04:30:00	AAPL	Stock	3.0393	3.0393	3.0393	3.0393	5600.0
2007-02-13 07:00:00	AAPL	Stock	3.0525	3.0543	3.0364	3.0446	56000.0
2007-02-13 07:30:00	AAPL	Stock	3.0429	3.0482	3.0407	3.0411	257600.0
2007-02-13 08:00:00	AAPL	Stock	3.0429	3.0482	3.0411	3.0464	860300.0
2007-02-13 08:30:00	AAPL	Stock	3.0464	3.0464	3.0393	3.0439	1071980.0
2007-02-13 09:00:00	AAPL	Stock	3.0414	3.045	3.0379	3.0425	711984.0
2007-02-13 09:30:00	AAPL	Stock	3.0414	3.0461	3.0182	3.0289	91821324.0
2007-02-13 10:00:00	AAPL	Stock	3.0289	3.0325	3.0136	3.0189	63430360.0
2007-02-13 10:30:00	AAPL	Stock	3.0193	3.0236	3.0107	3.0193	42733544.0
2007-02-13 11:00:00	AAPL	Stock	3.0193	3.0457	3.0186	3.0389	75765704.0
2007-02-13 11:30:00	AAPL	Stock	3.0389	3.0446	3.0329	3.0361	46371248.0
2007-02-13 12:00:00	AAPL	Stock	3.0357	3.0425	3.0336	3.0372	27936580.0
2007-02-13 12:30:00	AAPL	Stock	3.0371	3.0425	3.035	3.0354	22013180.0
2007-02-13 13:00:00	AAPL	Stock	3.035	3.0379	3.0268	3.0271	31056592.0
2007-02-13 13:30:00	AAPL	Stock	3.0268	3.0286	3.0189	3.0236	27492052.0
2007-02-13 14:00:00	AAPL	Stock	3.0236	3.0293	3.02	3.0221	25115328.0
2007-02-13 14:30:00	AAPL	Stock	3.0218	3.025	3.0143	3.0218	37753044.0
2007-02-13 15:00:00	AAPL	Stock	3.0218	3.0229	3.0125	3.0225	26351444.0
2007-02-13 15:30:00	AAPL	Stock	3.0225	3.0264	3.0182	3.0232	41293700.0
2007-02-13 16:00:00	AAPL	Stock	3.0225	3.0286	3.0225	3.0236	2071384.0
2007-02-13 16:30:00	AAPL	Stock	3.0243	3.025	3.0221	3.025	438060.0
2007-02-13 17:00:00	AAPL	Stock	3.025	3.025	3.0246	3.025	216664.0
2007-02-13 17:30:00	AAPL	Stock	3.0246	3.0268	3.0243	3.0268	364644.0
2007-02-13 18:00:00	AAPL	Stock	3.0264	3.0282	3.025	3.0282	133840.0
2007-02-13 18:30:00	AAPL	Stock	3.0257	3.0279	3.0225	3.0275	69860.0
2007-02-13 19:00:00	AAPL	Stock	3.0279	3.0279	3.0257	3.0279	30660.0
2007-02-13 19:30:00	AAPL	Stock	3.025	3.0286	3.025	3.0286	868448.0
2007-02-13 07:00:00	MSFT	Stock	28.9	28.9	28.85	28.85	7367.0
2007-02-13 08:00:00	MSFT	Stock	28.9	28.97	28.9	28.94	39004.0
2007-02-13 08:30:00	MSFT	Stock	28.94	29.0	28.9	28.98	83579.0
2007-02-13 09:00:00	MSFT	Stock	28.98	29.05	28.9	29.05	201987.0
2007-02-13 09:30:00	MSFT	Stock	29.04	29.13	29.01	29.09	7585583.0
2007-02-13 10:00:00	MSFT	Stock	29.09	29.1	28.97	29.01	5705294.0
2007-02-13 10:30:00	MSFT	Stock	29.0	29.05	28.96	28.96	5411902.0
2007-02-13 11:00:00	MSFT	Stock	28.97	29.049	28.96	28.99	2510890.0
2007-02-13 11:30:00	MSFT	Stock	28.98	29.02	28.97	29.0	2291195.0
2007-02-13 12:00:00	MSFT	Stock	29.0	29.2	28.99	29.08	4818524.0
2007-02-13 12:30:00	MSFT	Stock	29.07	29.1	29.02	29.03	3327836.0
2007-02-13 13:00:00	MSFT	Stock	29.04	29.1	29.03	29.04	1731684.0
2007-02-13 13:30:00	MSFT	Stock	29.04	29.08	29.01	29.03	1628631.0
2007-02-13 14:00:00	MSFT	Stock	29.03	29.07	29.02	29.05	1652483.0
2007-02-13 14:30:00	MSFT	Stock	29.05	29.06	28.99	29.04	3417918.0
2007-02-13 15:00:00	MSFT	Stock	29.03	29.05	28.99	29.03	2321999.0
2007-02-13 15:30:00	MSFT	Stock	29.04	29.08	29.0	29.04	4776119.0
2007-02-13 16:00:00	MSFT	Stock	29.04	29.05	29.02	29.03	185027.0
2007-02-13 16:30:00	MSFT	Stock	29.03	29.03	29.0	29.03	3150.0
2007-02-13 17:00:00	MSFT	Stock	29.03	29.03	29.0	29.01	3878.0
2007-02-13 17:30:00	MSFT	Stock	29.03	29.03	29.01	29.01	1200.0
2007-02-13 18:00:00	MSFT	Stock	29.01	29.02	29.01	29.02	600.0
2007-02-13 18:30:00	MSFT	Stock	29.03	29.03	29.03	29.03	1665.0

> showing 50 of 55,094 rows — these rows as CSV

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