PREVIEW / stock_30min / 2010-11-01

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-11-01.parquet
  size:    1.4 MB
  rows:    75,068
  symbols: 3,516

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-11-01 05:00:00	AAPL	Stock	10.8471	10.8571	10.8464	10.8571	19880.0
2010-11-01 05:30:00	AAPL	Stock	10.8571	10.8571	10.8425	10.8425	5600.0
2010-11-01 06:00:00	AAPL	Stock	10.8207	10.8207	10.8207	10.8207	2800.0
2010-11-01 06:30:00	AAPL	Stock	10.8304	10.8304	10.8304	10.8304	2800.0
2010-11-01 07:00:00	AAPL	Stock	10.8179	10.8304	10.8125	10.8214	211680.0
2010-11-01 07:30:00	AAPL	Stock	10.8214	10.8243	10.8029	10.8029	157612.0
2010-11-01 08:00:00	AAPL	Stock	10.8039	10.8179	10.7454	10.7964	1128372.0
2010-11-01 08:30:00	AAPL	Stock	10.7982	10.7982	10.78	10.785	887012.0
2010-11-01 09:00:00	AAPL	Stock	10.7846	10.8132	10.7493	10.8079	994924.0
2010-11-01 09:30:00	AAPL	Stock	10.8025	10.9107	10.7929	10.8886	91375872.0
2010-11-01 10:00:00	AAPL	Stock	10.8892	10.9143	10.8757	10.8893	47327980.0
2010-11-01 10:30:00	AAPL	Stock	10.8892	10.8914	10.8607	10.87	31482640.0
2010-11-01 11:00:00	AAPL	Stock	10.8679	10.875	10.8143	10.8189	46339720.0
2010-11-01 11:30:00	AAPL	Stock	10.8174	10.8561	10.7975	10.8546	36679972.0
2010-11-01 12:00:00	AAPL	Stock	10.855	10.8704	10.8393	10.8607	21274876.0
2010-11-01 12:30:00	AAPL	Stock	10.8596	10.8643	10.8393	10.85	11688264.0
2010-11-01 13:00:00	AAPL	Stock	10.8502	10.8657	10.8393	10.8539	15092028.0
2010-11-01 13:30:00	AAPL	Stock	10.8536	10.8661	10.8393	10.8536	11867100.0
2010-11-01 14:00:00	AAPL	Stock	10.8531	10.8668	10.8393	10.8504	14858228.0
2010-11-01 14:30:00	AAPL	Stock	10.8521	10.8582	10.8286	10.8491	18745328.0
2010-11-01 15:00:00	AAPL	Stock	10.8486	10.85	10.8036	10.8357	34152216.0
2010-11-01 15:30:00	AAPL	Stock	10.8368	10.8643	10.8312	10.8636	28856744.0
2010-11-01 16:00:00	AAPL	Stock	10.8639	10.8704	10.7454	10.8451	7392056.0
2010-11-01 16:30:00	AAPL	Stock	10.8593	10.8636	10.8149	10.8621	183232.0
2010-11-01 17:00:00	AAPL	Stock	10.8621	10.8636	10.8561	10.8593	276556.0
2010-11-01 17:30:00	AAPL	Stock	10.8596	10.8596	10.8486	10.8546	398160.0
2010-11-01 18:00:00	AAPL	Stock	10.8536	10.8636	10.8518	10.8521	104384.0
2010-11-01 18:30:00	AAPL	Stock	10.8539	10.8554	10.8375	10.8375	588840.0
2010-11-01 19:00:00	AAPL	Stock	10.8357	10.8389	10.8329	10.8386	286804.0
2010-11-01 19:30:00	AAPL	Stock	10.8386	10.8511	10.8386	10.8464	658700.0
2010-11-01 07:00:00	MSFT	Stock	26.85	26.92	26.85	26.9	5300.0
2010-11-01 07:30:00	MSFT	Stock	26.9	26.9	26.88	26.88	1900.0
2010-11-01 08:00:00	MSFT	Stock	26.85	26.88	26.74	26.78	41210.0
2010-11-01 08:30:00	MSFT	Stock	26.77	26.78	26.65	26.76	73393.0
2010-11-01 09:00:00	MSFT	Stock	26.77	26.9	26.64	26.88	125333.0
2010-11-01 09:30:00	MSFT	Stock	26.88	27.1	26.8	27.05	8043564.0
2010-11-01 10:00:00	MSFT	Stock	27.06	27.22	27.05	27.17	7483305.0
2010-11-01 10:30:00	MSFT	Stock	27.165	27.18	27.06	27.102	4487238.0
2010-11-01 11:00:00	MSFT	Stock	27.105	27.11	26.95	27.0	4132297.0
2010-11-01 11:30:00	MSFT	Stock	27.005	27.04	26.94	27.018	3171639.0
2010-11-01 12:00:00	MSFT	Stock	27.015	27.09	27.0	27.09	2442931.0
2010-11-01 12:30:00	MSFT	Stock	27.083	27.09	26.99	27.021	2990456.0
2010-11-01 13:00:00	MSFT	Stock	27.02	27.06	26.95	26.99	2335971.0
2010-11-01 13:30:00	MSFT	Stock	26.99	27.04	26.98	26.99	2410170.0
2010-11-01 14:00:00	MSFT	Stock	26.99	27.03	26.96	27.0	2297422.0
2010-11-01 14:30:00	MSFT	Stock	27.0	27.01	26.89	26.92	4057275.0
2010-11-01 15:00:00	MSFT	Stock	26.92	26.92	26.7	26.82	6338314.0
2010-11-01 15:30:00	MSFT	Stock	26.81	26.96	26.81	26.96	6488197.0
2010-11-01 16:00:00	MSFT	Stock	26.95	27.19	26.64	26.94	3148981.0
2010-11-01 16:30:00	MSFT	Stock	26.94	26.94	26.73	26.92	8009.0

> showing 50 of 75,068 rows — these rows as CSV

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