PREVIEW / stock_30min / 2010-07-26

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-07-26.parquet
  size:    1.4 MB
  rows:    74,951
  symbols: 3,476

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-26 06:00:00	AAPL	Stock	9.2871	9.2957	9.2871	9.2943	11200.0
2010-07-26 06:30:00	AAPL	Stock	9.2861	9.2871	9.2786	9.2786	31920.0
2010-07-26 07:00:00	AAPL	Stock	9.2857	9.2864	9.2746	9.2854	68740.0
2010-07-26 07:30:00	AAPL	Stock	9.275	9.2793	9.2386	9.275	86716.0
2010-07-26 08:00:00	AAPL	Stock	9.27	9.2746	9.2507	9.2554	451472.0
2010-07-26 08:30:00	AAPL	Stock	9.2554	9.2764	9.2554	9.2764	709100.0
2010-07-26 09:00:00	AAPL	Stock	9.275	9.3129	9.275	9.2857	3173100.0
2010-07-26 09:30:00	AAPL	Stock	9.2868	9.2893	9.2154	9.2254	64527764.0
2010-07-26 10:00:00	AAPL	Stock	9.2254	9.2768	9.2236	9.235	48845468.0
2010-07-26 10:30:00	AAPL	Stock	9.2354	9.2536	9.2039	9.2521	33113640.0
2010-07-26 11:00:00	AAPL	Stock	9.2529	9.2732	9.2432	9.2554	27967184.0
2010-07-26 11:30:00	AAPL	Stock	9.2554	9.27	9.2464	9.25	19333804.0
2010-07-26 12:00:00	AAPL	Stock	9.2496	9.2557	9.2334	9.2407	16599296.0
2010-07-26 12:30:00	AAPL	Stock	9.2421	9.2464	9.215	9.2307	22969660.0
2010-07-26 13:00:00	AAPL	Stock	9.2307	9.2357	9.2075	9.2189	27592068.0
2010-07-26 13:30:00	AAPL	Stock	9.22	9.2457	9.215	9.2397	14332780.0
2010-07-26 14:00:00	AAPL	Stock	9.2404	9.2407	9.2186	9.2226	12706232.0
2010-07-26 14:30:00	AAPL	Stock	9.2221	9.2271	9.2082	9.22	20541108.0
2010-07-26 15:00:00	AAPL	Stock	9.22	9.2582	9.2179	9.2421	26945660.0
2010-07-26 15:30:00	AAPL	Stock	9.2443	9.2596	9.2379	9.2596	37499084.0
2010-07-26 16:00:00	AAPL	Stock	9.26	9.2864	9.2383	9.2571	36442140.0
2010-07-26 16:30:00	AAPL	Stock	9.2571	9.2589	9.2471	9.2521	194600.0
2010-07-26 17:00:00	AAPL	Stock	9.2571	9.2571	9.2518	9.2554	163800.0
2010-07-26 17:30:00	AAPL	Stock	9.2525	9.2571	9.2518	9.2571	55160.0
2010-07-26 18:00:00	AAPL	Stock	9.2543	9.26	9.2536	9.2554	3288656.0
2010-07-26 18:30:00	AAPL	Stock	9.2546	9.2546	9.2511	9.2514	127372.0
2010-07-26 19:00:00	AAPL	Stock	9.2514	9.2536	9.25	9.2511	128240.0
2010-07-26 19:30:00	AAPL	Stock	9.2511	9.2511	9.2321	9.25	155260.0
2010-07-26 06:00:00	MSFT	Stock	25.82	25.82	25.82	25.82	500.0
2010-07-26 07:00:00	MSFT	Stock	25.79	25.79	25.79	25.79	500.0
2010-07-26 07:30:00	MSFT	Stock	25.78	25.78	25.77	25.78	2966.0
2010-07-26 08:00:00	MSFT	Stock	25.73	25.82	25.73	25.75	27192.0
2010-07-26 08:30:00	MSFT	Stock	25.75	25.81	25.75	25.8	19244.0
2010-07-26 09:00:00	MSFT	Stock	25.79	25.91	25.79	25.88	68400.0
2010-07-26 09:30:00	MSFT	Stock	25.88	25.98	25.8	25.91	7077562.0
2010-07-26 10:00:00	MSFT	Stock	25.92	26.06	25.9	25.935	7402148.0
2010-07-26 10:30:00	MSFT	Stock	25.94	26.05	25.89	26.035	3747238.0
2010-07-26 11:00:00	MSFT	Stock	26.05	26.19	26.04	26.13	5109245.0
2010-07-26 11:30:00	MSFT	Stock	26.13	26.18	26.09	26.125	3360186.0
2010-07-26 12:00:00	MSFT	Stock	26.13	26.17	26.06	26.15	3605694.0
2010-07-26 12:30:00	MSFT	Stock	26.15	26.16	25.96	26.02	4700897.0
2010-07-26 13:00:00	MSFT	Stock	26.021	26.09	25.96	26.08	2790769.0
2010-07-26 13:30:00	MSFT	Stock	26.08	26.2	26.08	26.15	2814629.0
2010-07-26 14:00:00	MSFT	Stock	26.15	26.18	26.1	26.1	2370510.0
2010-07-26 14:30:00	MSFT	Stock	26.1	26.1	25.975	26.01	2853932.0
2010-07-26 15:00:00	MSFT	Stock	26.01	26.13	26.0	26.105	3530737.0
2010-07-26 15:30:00	MSFT	Stock	26.105	26.13	26.04	26.11	7873271.0
2010-07-26 16:00:00	MSFT	Stock	26.11	26.12	25.818	26.09	9414587.0
2010-07-26 16:30:00	MSFT	Stock	26.095	26.095	26.03	26.03	49429.0
2010-07-26 17:00:00	MSFT	Stock	25.81	26.04	25.81	26.04	7800.0

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

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