PREVIEW / stock_30min / 2007-04-23

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-04-23.parquet
  size:    1.0 MB
  rows:    56,399
  symbols: 2,592

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
2007-04-23 05:00:00	AAPL	Stock	3.2607	3.2607	3.2607	3.2607	2800.0
2007-04-23 07:00:00	AAPL	Stock	3.25	3.25	3.25	3.25	2800.0
2007-04-23 07:30:00	AAPL	Stock	3.2571	3.285	3.2571	3.2732	669200.0
2007-04-23 08:00:00	AAPL	Stock	3.2761	3.2768	3.2661	3.2729	1791860.0
2007-04-23 08:30:00	AAPL	Stock	3.2732	3.2754	3.2489	3.2696	646632.0
2007-04-23 09:00:00	AAPL	Stock	3.2686	3.2746	3.2646	3.2714	4637780.0
2007-04-23 09:30:00	AAPL	Stock	3.2729	3.3132	3.265	3.3082	126650440.0
2007-04-23 10:00:00	AAPL	Stock	3.3086	3.3093	3.2709	3.3009	67860660.0
2007-04-23 10:30:00	AAPL	Stock	3.3007	3.3125	3.3	3.3104	53009488.0
2007-04-23 11:00:00	AAPL	Stock	3.3104	3.3304	3.3075	3.3261	67325916.0
2007-04-23 11:30:00	AAPL	Stock	3.3264	3.3271	3.3154	3.3236	45453548.0
2007-04-23 12:00:00	AAPL	Stock	3.3232	3.3318	3.3207	3.3235	42164164.0
2007-04-23 12:30:00	AAPL	Stock	3.3236	3.3289	3.3211	3.3275	19338900.0
2007-04-23 13:00:00	AAPL	Stock	3.3272	3.3343	3.3271	3.3296	32564056.0
2007-04-23 13:30:00	AAPL	Stock	3.3296	3.33	3.3125	3.3125	42917980.0
2007-04-23 14:00:00	AAPL	Stock	3.3125	3.3196	3.3089	3.3182	43672048.0
2007-04-23 14:30:00	AAPL	Stock	3.3182	3.3389	3.3179	3.3382	47982760.0
2007-04-23 15:00:00	AAPL	Stock	3.3389	3.35	3.3343	3.3493	62969900.0
2007-04-23 15:30:00	AAPL	Stock	3.3493	3.3496	3.3311	3.3407	82458516.0
2007-04-23 16:00:00	AAPL	Stock	3.3407	3.3429	3.3393	3.34	11890844.0
2007-04-23 16:30:00	AAPL	Stock	3.3407	3.3493	3.3396	3.3464	19023760.0
2007-04-23 17:00:00	AAPL	Stock	3.345	3.3482	3.3439	3.3464	203000.0
2007-04-23 17:30:00	AAPL	Stock	3.345	3.3471	3.3414	3.3464	160664.0
2007-04-23 18:00:00	AAPL	Stock	3.3464	3.3482	3.3429	3.3482	220892.0
2007-04-23 18:30:00	AAPL	Stock	3.3482	3.3482	3.3464	3.3464	89824.0
2007-04-23 19:00:00	AAPL	Stock	3.3475	3.3479	3.3464	3.3479	111244.0
2007-04-23 19:30:00	AAPL	Stock	3.3464	3.3489	3.3429	3.3454	372792.0
2007-04-23 08:00:00	MSFT	Stock	29.0	29.1	29.0	29.04	9675.0
2007-04-23 08:30:00	MSFT	Stock	29.02	29.05	29.02	29.02	23195.0
2007-04-23 09:00:00	MSFT	Stock	29.0	29.02	28.95	28.98	564473.0
2007-04-23 09:30:00	MSFT	Stock	28.96	28.99	28.8	28.81	5339157.0
2007-04-23 10:00:00	MSFT	Stock	28.82	28.87	28.72	28.76	3133883.0
2007-04-23 10:30:00	MSFT	Stock	28.77	28.82	28.76	28.77	2440241.0
2007-04-23 11:00:00	MSFT	Stock	28.77	28.89	28.76	28.88	4053777.0
2007-04-23 11:30:00	MSFT	Stock	28.88	28.88	28.769	28.82	1950606.0
2007-04-23 12:00:00	MSFT	Stock	28.83	28.83	28.74	28.75	2563050.0
2007-04-23 12:30:00	MSFT	Stock	28.75	28.79	28.69	28.79	1627979.0
2007-04-23 13:00:00	MSFT	Stock	28.79	28.82	28.78	28.78	1069842.0
2007-04-23 13:30:00	MSFT	Stock	28.78	28.8	28.68	28.7	2106406.0
2007-04-23 14:00:00	MSFT	Stock	28.71	28.77	28.67	28.75	1761924.0
2007-04-23 14:30:00	MSFT	Stock	28.76	28.83	28.75	28.79	3253192.0
2007-04-23 15:00:00	MSFT	Stock	28.782	28.82	28.74	28.81	2064937.0
2007-04-23 15:30:00	MSFT	Stock	28.81	28.84	28.76	28.79	3912896.0
2007-04-23 16:00:00	MSFT	Stock	28.78	28.82	28.75	28.82	323178.0
2007-04-23 16:30:00	MSFT	Stock	28.78	28.9	28.78	28.9	2883041.0
2007-04-23 17:00:00	MSFT	Stock	28.91	28.91	28.88	28.88	8750.0
2007-04-23 17:30:00	MSFT	Stock	28.86	28.86	28.85	28.85	3800.0
2007-04-23 18:00:00	MSFT	Stock	28.85	28.86	28.85	28.85	2630.0
2007-04-23 18:30:00	MSFT	Stock	28.85	28.87	28.85	28.87	800.0
2007-04-23 19:00:00	MSFT	Stock	28.87	28.87	28.87	28.87	1000.0

> showing 50 of 56,399 rows — these rows as CSV

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