PREVIEW / stock_30min / 2010-10-18

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-10-18.parquet
  size:    1.4 MB
  rows:    75,972
  symbols: 3,503

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-18 04:00:00	AAPL	Stock	11.3182	11.3182	11.3182	11.3182	11060.0
2010-10-18 05:00:00	AAPL	Stock	11.2275	11.2275	11.2275	11.2275	4480.0
2010-10-18 05:30:00	AAPL	Stock	11.2789	11.2789	11.2789	11.2789	2800.0
2010-10-18 06:00:00	AAPL	Stock	11.2718	11.2857	11.2693	11.2857	11480.0
2010-10-18 06:30:00	AAPL	Stock	11.2857	11.2857	11.2857	11.2857	5600.0
2010-10-18 07:00:00	AAPL	Stock	11.2854	11.3143	11.2714	11.2943	709436.0
2010-10-18 07:30:00	AAPL	Stock	11.2925	11.3314	11.2857	11.2896	882392.0
2010-10-18 08:00:00	AAPL	Stock	11.2964	11.4246	11.2864	11.4232	11116056.0
2010-10-18 08:30:00	AAPL	Stock	11.4221	11.4232	11.3757	11.3857	6634320.0
2010-10-18 09:00:00	AAPL	Stock	11.3839	11.3896	11.3625	11.3739	5886188.0
2010-10-18 09:30:00	AAPL	Stock	11.3732	11.3929	11.2246	11.3332	200915456.0
2010-10-18 10:00:00	AAPL	Stock	11.3339	11.3536	11.2893	11.3189	85877232.0
2010-10-18 10:30:00	AAPL	Stock	11.3186	11.3221	11.2968	11.3125	51024036.0
2010-10-18 11:00:00	AAPL	Stock	11.3135	11.3196	11.2857	11.3132	46950960.0
2010-10-18 11:30:00	AAPL	Stock	11.3139	11.3139	11.2836	11.2961	42576268.0
2010-10-18 12:00:00	AAPL	Stock	11.2961	11.3132	11.2907	11.3072	29862644.0
2010-10-18 12:30:00	AAPL	Stock	11.3079	11.3118	11.25	11.2551	52853780.0
2010-10-18 13:00:00	AAPL	Stock	11.2546	11.2821	11.2529	11.2736	44120972.0
2010-10-18 13:30:00	AAPL	Stock	11.2739	11.2768	11.23	11.235	47546520.0
2010-10-18 14:00:00	AAPL	Stock	11.2339	11.2964	11.2275	11.2814	61151552.0
2010-10-18 14:30:00	AAPL	Stock	11.2804	11.2964	11.2654	11.2696	50063412.0
2010-10-18 15:00:00	AAPL	Stock	11.2697	11.3286	11.2696	11.3264	60033120.0
2010-10-18 15:30:00	AAPL	Stock	11.3271	11.3643	11.3264	11.3543	120685320.0
2010-10-18 16:00:00	AAPL	Stock	11.3569	11.3746	11.1789	11.2929	11947040.0
2010-10-18 16:30:00	AAPL	Stock	10.7143	11.3571	10.4554	10.6375	68822516.0
2010-10-18 17:00:00	AAPL	Stock	10.6371	11.3659	10.6071	10.7843	50106028.0
2010-10-18 17:30:00	AAPL	Stock	10.7839	11.3536	10.6671	10.7429	17542924.0
2010-10-18 18:00:00	AAPL	Stock	10.7364	11.3571	10.7036	10.7093	5720232.0
2010-10-18 18:30:00	AAPL	Stock	10.7071	10.7114	10.6929	10.7107	1997184.0
2010-10-18 19:00:00	AAPL	Stock	10.7082	10.7111	10.6946	10.7036	1229928.0
2010-10-18 19:30:00	AAPL	Stock	10.7039	10.7039	10.6429	10.6607	3085124.0
2010-10-18 04:00:00	MSFT	Stock	25.54	25.54	25.54	25.54	200.0
2010-10-18 07:30:00	MSFT	Stock	25.47	25.56	25.47	25.5	14960.0
2010-10-18 08:00:00	MSFT	Stock	25.5	25.5	25.38	25.42	26550.0
2010-10-18 08:30:00	MSFT	Stock	25.45	25.52	25.45	25.5	22556.0
2010-10-18 09:00:00	MSFT	Stock	25.5	25.59	25.46	25.58	39398.0
2010-10-18 09:30:00	MSFT	Stock	25.58	25.79	25.45	25.79	6114255.0
2010-10-18 10:00:00	MSFT	Stock	25.785	25.95	25.78	25.855	9839916.0
2010-10-18 10:30:00	MSFT	Stock	25.859	25.93	25.85	25.908	4178606.0
2010-10-18 11:00:00	MSFT	Stock	25.908	25.92	25.78	25.82	2608737.0
2010-10-18 11:30:00	MSFT	Stock	25.82	25.82	25.7	25.82	3053003.0
2010-10-18 12:00:00	MSFT	Stock	25.82	25.83	25.715	25.73	1499556.0
2010-10-18 12:30:00	MSFT	Stock	25.728	25.75	25.69	25.7	1657826.0
2010-10-18 13:00:00	MSFT	Stock	25.698	25.72	25.68	25.7	1208963.0
2010-10-18 13:30:00	MSFT	Stock	25.7	25.73	25.65	25.722	1536274.0
2010-10-18 14:00:00	MSFT	Stock	25.729	25.79	25.72	25.755	2035606.0
2010-10-18 14:30:00	MSFT	Stock	25.76	25.76	25.7	25.74	1521604.0
2010-10-18 15:00:00	MSFT	Stock	25.739	25.81	25.73	25.785	3310438.0
2010-10-18 15:30:00	MSFT	Stock	25.785	25.83	25.78	25.81	4897893.0
2010-10-18 16:00:00	MSFT	Stock	25.82	25.89	25.54	25.78	2443924.0

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

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