PREVIEW / stock_1min / 2010-07-23

all stock 1-min files

  file:    by_date/stock_1min/2010/2010-07-23.parquet
  size:    12.9 MB
  rows:    984,184
  symbols: 2,807

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-07-23 04:02:00	AAPL	Stock	9.2482	9.2482	9.2482	9.2482	14000.0
2010-07-23 04:08:00	AAPL	Stock	9.2782	9.2782	9.2782	9.2782	5600.0
2010-07-23 04:09:00	AAPL	Stock	9.2854	9.2854	9.2854	9.2854	4116.0
2010-07-23 04:34:00	AAPL	Stock	9.2921	9.2921	9.2921	9.2921	2800.0
2010-07-23 05:19:00	AAPL	Stock	9.2957	9.2957	9.2957	9.2957	2800.0
2010-07-23 05:23:00	AAPL	Stock	9.3193	9.3193	9.3193	9.3193	2800.0
2010-07-23 05:26:00	AAPL	Stock	9.3175	9.3175	9.3175	9.3175	2800.0
2010-07-23 06:15:00	AAPL	Stock	9.3143	9.3143	9.3143	9.3143	2800.0
2010-07-23 06:53:00	AAPL	Stock	9.3157	9.3161	9.3157	9.3161	9548.0
2010-07-23 06:59:00	AAPL	Stock	9.2964	9.2964	9.2964	9.2964	2800.0
2010-07-23 07:00:00	AAPL	Stock	9.2961	9.3036	9.2929	9.3036	21756.0
2010-07-23 07:02:00	AAPL	Stock	9.2964	9.3036	9.2964	9.3029	41160.0
2010-07-23 07:05:00	AAPL	Stock	9.3114	9.3118	9.3114	9.3118	11396.0
2010-07-23 07:06:00	AAPL	Stock	9.3	9.3125	9.3	9.3125	38780.0
2010-07-23 07:07:00	AAPL	Stock	9.3125	9.3143	9.3125	9.3143	11200.0
2010-07-23 07:08:00	AAPL	Stock	9.3143	9.3143	9.3143	9.3143	2800.0
2010-07-23 07:09:00	AAPL	Stock	9.3036	9.3036	9.3036	9.3036	2800.0
2010-07-23 07:16:00	AAPL	Stock	9.3114	9.3114	9.3114	9.3114	15400.0
2010-07-23 07:18:00	AAPL	Stock	9.3139	9.3175	9.3139	9.3143	39200.0
2010-07-23 07:19:00	AAPL	Stock	9.3179	9.3179	9.3179	9.3179	28000.0
2010-07-23 07:20:00	AAPL	Stock	9.3179	9.3179	9.3179	9.3179	8400.0
2010-07-23 07:21:00	AAPL	Stock	9.3075	9.3075	9.3075	9.3075	4480.0
2010-07-23 07:22:00	AAPL	Stock	9.3136	9.3136	9.3136	9.3136	2800.0
2010-07-23 07:24:00	AAPL	Stock	9.3071	9.3071	9.3057	9.3057	16800.0
2010-07-23 07:26:00	AAPL	Stock	9.3036	9.3036	9.3036	9.3036	8400.0
2010-07-23 07:27:00	AAPL	Stock	9.3104	9.3104	9.3104	9.3104	7000.0
2010-07-23 07:32:00	AAPL	Stock	9.2996	9.3068	9.2993	9.3068	8400.0
2010-07-23 07:36:00	AAPL	Stock	9.3068	9.3068	9.3068	9.3068	2800.0
2010-07-23 07:41:00	AAPL	Stock	9.3036	9.3039	9.3036	9.3036	14000.0
2010-07-23 07:45:00	AAPL	Stock	9.3068	9.3161	9.3068	9.3143	125720.0
2010-07-23 07:47:00	AAPL	Stock	9.2954	9.2954	9.2954	9.2954	2800.0
2010-07-23 07:50:00	AAPL	Stock	9.295	9.295	9.295	9.295	5600.0
2010-07-23 07:51:00	AAPL	Stock	9.295	9.3036	9.295	9.3036	14000.0
2010-07-23 07:53:00	AAPL	Stock	9.295	9.295	9.2946	9.2946	27860.0
2010-07-23 07:56:00	AAPL	Stock	9.2954	9.2954	9.2954	9.2954	17724.0
2010-07-23 07:57:00	AAPL	Stock	9.2982	9.2982	9.2982	9.2982	2800.0
2010-07-23 07:58:00	AAPL	Stock	9.3007	9.3007	9.3	9.3	8400.0
2010-07-23 08:00:00	AAPL	Stock	9.2986	9.2986	9.2625	9.2625	181692.0
2010-07-23 08:01:00	AAPL	Stock	9.2779	9.2779	9.2679	9.2743	39200.0
2010-07-23 08:02:00	AAPL	Stock	9.2743	9.2782	9.2743	9.2782	40040.0
2010-07-23 08:03:00	AAPL	Stock	9.2789	9.2789	9.2775	9.2775	7280.0
2010-07-23 08:04:00	AAPL	Stock	9.2768	9.2811	9.2768	9.2811	36120.0
2010-07-23 08:05:00	AAPL	Stock	9.275	9.275	9.275	9.275	14000.0
2010-07-23 08:07:00	AAPL	Stock	9.2704	9.2704	9.2661	9.2661	43260.0
2010-07-23 08:09:00	AAPL	Stock	9.2636	9.2639	9.2632	9.2639	14000.0
2010-07-23 08:10:00	AAPL	Stock	9.2625	9.2625	9.2607	9.2607	19068.0
2010-07-23 08:11:00	AAPL	Stock	9.2643	9.2643	9.2643	9.2643	6272.0
2010-07-23 08:12:00	AAPL	Stock	9.2625	9.2632	9.2607	9.2607	50260.0
2010-07-23 08:13:00	AAPL	Stock	9.2589	9.2607	9.2589	9.2589	30240.0
2010-07-23 08:14:00	AAPL	Stock	9.2554	9.2554	9.255	9.255	8400.0

> showing 50 of 984,184 rows — these rows as CSV

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