PREVIEW / stock_30min / 2010-10-04

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-10-04.parquet
  size:    1.4 MB
  rows:    74,364
  symbols: 3,488

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
2010-10-04 04:30:00	AAPL	Stock	10.0396	10.0396	10.0396	10.0396	2800.0
2010-10-04 05:00:00	AAPL	Stock	10.0357	10.0375	10.0357	10.0375	5600.0
2010-10-04 05:30:00	AAPL	Stock	10.0357	10.0357	10.0357	10.0357	2800.0
2010-10-04 06:30:00	AAPL	Stock	10.0321	10.0321	10.0321	10.0321	16800.0
2010-10-04 07:00:00	AAPL	Stock	10.0679	10.0775	10.0607	10.0775	42280.0
2010-10-04 07:30:00	AAPL	Stock	10.0714	10.0768	10.0464	10.0543	58100.0
2010-10-04 08:00:00	AAPL	Stock	10.0636	10.0871	10.0536	10.0554	766808.0
2010-10-04 08:30:00	AAPL	Stock	10.0554	10.0643	10.0429	10.0561	612724.0
2010-10-04 09:00:00	AAPL	Stock	10.0543	10.0596	10.0464	10.0529	833840.0
2010-10-04 09:30:00	AAPL	Stock	10.0571	10.1036	10.0143	10.0625	77258860.0
2010-10-04 10:00:00	AAPL	Stock	10.0632	10.0786	10.0393	10.0614	35639912.0
2010-10-04 10:30:00	AAPL	Stock	10.0587	10.0693	10.0321	10.0586	27551496.0
2010-10-04 11:00:00	AAPL	Stock	10.0589	10.0596	9.9418	9.9671	54987408.0
2010-10-04 11:30:00	AAPL	Stock	9.9661	9.9804	9.9404	9.9443	23959572.0
2010-10-04 12:00:00	AAPL	Stock	9.9432	9.9493	9.9204	9.9325	33996592.0
2010-10-04 12:30:00	AAPL	Stock	9.9325	9.9528	9.9254	9.9361	18440744.0
2010-10-04 13:00:00	AAPL	Stock	9.9375	9.9629	9.9336	9.9593	17885280.0
2010-10-04 13:30:00	AAPL	Stock	9.9596	9.9629	9.9239	9.9446	16995076.0
2010-10-04 14:00:00	AAPL	Stock	9.945	9.9518	9.9257	9.9366	21994616.0
2010-10-04 14:30:00	AAPL	Stock	9.9386	9.9761	9.9311	9.9646	25953144.0
2010-10-04 15:00:00	AAPL	Stock	9.9643	9.9925	9.9518	9.9687	26011496.0
2010-10-04 15:30:00	AAPL	Stock	9.9691	9.98	9.9446	9.95	38330796.0
2010-10-04 16:00:00	AAPL	Stock	9.9514	9.9923	9.9262	9.9568	7854812.0
2010-10-04 16:30:00	AAPL	Stock	9.9575	10.068	9.9514	9.9514	781592.0
2010-10-04 17:00:00	AAPL	Stock	9.9668	9.9714	9.9664	9.9714	126644.0
2010-10-04 17:30:00	AAPL	Stock	9.97	9.9732	9.97	9.9732	118860.0
2010-10-04 18:00:00	AAPL	Stock	9.9729	9.9739	9.9514	9.9696	248976.0
2010-10-04 18:30:00	AAPL	Stock	9.9732	9.9804	9.9714	9.9782	200480.0
2010-10-04 19:00:00	AAPL	Stock	9.9732	9.9779	9.9714	9.9714	98700.0
2010-10-04 19:30:00	AAPL	Stock	9.9729	9.9754	9.9714	9.9732	68180.0
2010-10-04 04:00:00	MSFT	Stock	24.33	24.33	24.05	24.1	500.0
2010-10-04 04:30:00	MSFT	Stock	24.01	24.01	23.8	23.8	2380.0
2010-10-04 05:00:00	MSFT	Stock	23.93	23.99	23.91	23.99	2000.0
2010-10-04 05:30:00	MSFT	Stock	23.92	23.92	23.9	23.9	3000.0
2010-10-04 06:00:00	MSFT	Stock	23.91	23.91	23.91	23.91	1000.0
2010-10-04 06:30:00	MSFT	Stock	23.9	23.9	23.88	23.9	16200.0
2010-10-04 07:00:00	MSFT	Stock	23.88	23.9	23.83	23.9	29800.0
2010-10-04 07:30:00	MSFT	Stock	23.92	23.97	23.9	23.93	30499.0
2010-10-04 08:00:00	MSFT	Stock	23.94	24.0	23.91	23.96	104910.0
2010-10-04 08:30:00	MSFT	Stock	23.96	24.0	23.96	24.0	312855.0
2010-10-04 09:00:00	MSFT	Stock	24.0	24.38	23.91	23.98	393963.0
2010-10-04 09:30:00	MSFT	Stock	23.96	23.99	23.83	23.91	19415760.0
2010-10-04 10:00:00	MSFT	Stock	23.885	23.96	23.84	23.93	8402604.0
2010-10-04 10:30:00	MSFT	Stock	23.94	23.98	23.86	23.911	7901142.0
2010-10-04 11:00:00	MSFT	Stock	23.91	23.92	23.78	23.83	7186378.0
2010-10-04 11:30:00	MSFT	Stock	23.82	23.91	23.81	23.86	4821269.0
2010-10-04 12:00:00	MSFT	Stock	23.87	23.9	23.81	23.84	4841028.0
2010-10-04 12:30:00	MSFT	Stock	23.835	23.87	23.79	23.795	3715226.0
2010-10-04 13:00:00	MSFT	Stock	23.8	23.85	23.795	23.83	2325043.0
2010-10-04 13:30:00	MSFT	Stock	23.82	23.85	23.79	23.82	4266114.0

> showing 50 of 74,364 rows — these rows as CSV

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