PREVIEW / stock_30min / 2012-01-18

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-01-18.parquet
  size:    1.4 MB
  rows:    74,306
  symbols: 3,521

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
2012-01-18 04:00:00	AAPL	Stock	15.1921	15.2207	15.1921	15.2154	22400.0
2012-01-18 04:30:00	AAPL	Stock	15.2218	15.2218	15.2218	15.2218	2800.0
2012-01-18 05:00:00	AAPL	Stock	15.2321	15.25	15.2321	15.25	42000.0
2012-01-18 06:00:00	AAPL	Stock	15.2321	15.2321	15.2036	15.2036	25200.0
2012-01-18 07:00:00	AAPL	Stock	15.2143	15.2321	15.1982	15.1982	91532.0
2012-01-18 07:30:00	AAPL	Stock	15.2054	15.2243	15.1964	15.2143	61600.0
2012-01-18 08:00:00	AAPL	Stock	15.2093	15.2321	15.1289	15.2321	1157044.0
2012-01-18 08:30:00	AAPL	Stock	15.2311	15.2464	15.2189	15.2193	1106392.0
2012-01-18 09:00:00	AAPL	Stock	15.2182	15.2486	15.2146	15.2475	856212.0
2012-01-18 09:30:00	AAPL	Stock	15.2468	15.2886	15.225	15.2471	63120372.0
2012-01-18 10:00:00	AAPL	Stock	15.2474	15.2821	15.2411	15.2643	25543196.0
2012-01-18 10:30:00	AAPL	Stock	15.2625	15.2807	15.25	15.2557	20297536.0
2012-01-18 11:00:00	AAPL	Stock	15.2554	15.2675	15.2429	15.2439	13548556.0
2012-01-18 11:30:00	AAPL	Stock	15.2439	15.2621	15.2414	15.2557	10961104.0
2012-01-18 12:00:00	AAPL	Stock	15.2554	15.2857	15.2464	15.285	17937136.0
2012-01-18 12:30:00	AAPL	Stock	15.285	15.3007	15.2686	15.2957	14551488.0
2012-01-18 13:00:00	AAPL	Stock	15.2943	15.3021	15.2839	15.2922	10011988.0
2012-01-18 13:30:00	AAPL	Stock	15.2912	15.3018	15.2804	15.2879	9042236.0
2012-01-18 14:00:00	AAPL	Stock	15.2871	15.3036	15.2843	15.3018	9067548.0
2012-01-18 14:30:00	AAPL	Stock	15.3017	15.3057	15.29	15.3029	9627744.0
2012-01-18 15:00:00	AAPL	Stock	15.3032	15.3382	15.3032	15.3143	23939776.0
2012-01-18 15:30:00	AAPL	Stock	15.3143	15.3246	15.3089	15.3246	27694100.0
2012-01-18 16:00:00	AAPL	Stock	15.3254	15.3339	15.1679	15.3318	13948452.0
2012-01-18 16:30:00	AAPL	Stock	15.3318	15.3375	15.3134	15.3364	545076.0
2012-01-18 17:00:00	AAPL	Stock	15.3368	15.3425	15.3321	15.3357	381220.0
2012-01-18 17:30:00	AAPL	Stock	15.3357	15.3632	15.3339	15.3539	642432.0
2012-01-18 18:00:00	AAPL	Stock	15.3536	15.3661	15.3254	15.3571	142464.0
2012-01-18 18:30:00	AAPL	Stock	15.3557	15.3571	15.3482	15.3525	65800.0
2012-01-18 19:00:00	AAPL	Stock	15.3489	15.3518	15.3464	15.3464	8400.0
2012-01-18 19:30:00	AAPL	Stock	15.3464	15.3607	15.3311	15.3607	280196.0
2012-01-18 07:00:00	MSFT	Stock	28.38	28.38	28.38	28.38	500.0
2012-01-18 07:30:00	MSFT	Stock	28.3	28.35	28.3	28.35	600.0
2012-01-18 08:00:00	MSFT	Stock	28.36	28.42	28.36	28.42	10025.0
2012-01-18 08:30:00	MSFT	Stock	28.42	28.42	28.32	28.32	13695.0
2012-01-18 09:00:00	MSFT	Stock	28.3	28.34	28.28	28.29	14837.0
2012-01-18 09:30:00	MSFT	Stock	28.33	28.4	28.11	28.18	10793447.0
2012-01-18 10:00:00	MSFT	Stock	28.18	28.25	28.08	28.16	5098952.0
2012-01-18 10:30:00	MSFT	Stock	28.166	28.22	28.11	28.172	4697718.0
2012-01-18 11:00:00	MSFT	Stock	28.17	28.19	27.98	28.01	6020417.0
2012-01-18 11:30:00	MSFT	Stock	28.0	28.1	27.97	28.05	4449729.0
2012-01-18 12:00:00	MSFT	Stock	28.04	28.22	28.02	28.19	4106273.0
2012-01-18 12:30:00	MSFT	Stock	28.2	28.23	28.13	28.2	3345105.0
2012-01-18 13:00:00	MSFT	Stock	28.2	28.21	28.15	28.195	2105757.0
2012-01-18 13:30:00	MSFT	Stock	28.19	28.22	28.07	28.07	2673582.0
2012-01-18 14:00:00	MSFT	Stock	28.08	28.15	28.07	28.14	2423545.0
2012-01-18 14:30:00	MSFT	Stock	28.15	28.189	28.11	28.145	3368044.0
2012-01-18 15:00:00	MSFT	Stock	28.145	28.18	28.1	28.143	4496763.0
2012-01-18 15:30:00	MSFT	Stock	28.145	28.23	28.14	28.23	6662873.0
2012-01-18 16:00:00	MSFT	Stock	28.22	28.26	28.153	28.25	3086176.0
2012-01-18 16:30:00	MSFT	Stock	28.25	28.25	28.0	28.25	32259.0

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

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